Explain Bug in PgAdmin III Query window

From: Kevin(dot)Wilson(at)comtrol(dot)com
To: pgadmin-support(at)postgresql(dot)org
Subject: Explain Bug in PgAdmin III Query window
Date: 2004-06-03 17:30:07
Message-ID: 8CA8D92FACEB5447AB1ABA12B13A54CE117863@exchange-2.comtrol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

Thanks,

Kevin

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2004-06-04 07:55:18 Re: Explain Bug in PgAdmin III Query window
Previous Message m.p.kooij 2004-05-29 10:34:02 Compiling problem on SuSe 9.1