Skip site navigation (1) Skip section navigation (2)

Re: Explain Bug in PgAdmin III Query window

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Kevin(dot)Wilson(at)comtrol(dot)com
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Explain Bug in PgAdmin III Query window
Date: 2004-06-04 07:55:18
Message-ID: 40C02AE6.9010008@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
Kevin(dot)Wilson(at)comtrol(dot)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



In response to

pgadmin-support by date

Next:From: carmectDate: 2004-06-08 16:08:33
Subject: Schemas seem to disapear!
Previous:From: Kevin.WilsonDate: 2004-06-03 17:30:07
Subject: Explain Bug in PgAdmin III Query window

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group