[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
