Kevin.Wilson@comtrol.com wrote:
> Server = PostgreSQL v7.4.2 on SuSE Linux 9.1
> PgAdminIII v1.1.0 Devel(Apr 14 2004) on Windows 2000-sp4
>
> Using the ddl created by the create table & index UI wizards I then
> post that ddl into the query window and hit explain. I receive and
> error message that some syntax is invalid.
>
> These were generated using PgAdminIII:
>
> CREATE TABLE "INDEODB"."COMPANY"
> (
> "COMPANY_ID" numeric(10) NOT NULL,
> "COM_NAME" varchar(40),
> CONSTRAINT "COMPANY_pkey" PRIMARY KEY ("COMPANY_ID")
> ) WITHOUT OIDS;
>
> CREATE INDEX "IDX_COMPANY_COM_NAME"
> ON "INDEODB"."COMPANY"
> USING btree
> ("COM_NAME");
>
> output of explain on create table is:
>
> Query inserted one rows with OID 0.
> ERROR: syntax error at or near "numeric" at character 59
>
> output of explain on create index is:
>
> Query inserted one rows with OID 0.
> ERROR: syntax error at or near "INDEX" at character 16
>
>
> The real execution of these work fine.
>
There's nothing to explain on CREATE TABLE or any other DDL command;
pgsql's error message is misleading.
Regards,
Andreas