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

bug report

From: "Mike Arace" <mikearace(at)hotmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: bug report
Date: 2001-09-17 02:19:44
Message-ID: F267xObFlAlfpCzWcT80000fe4f@hotmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
Hey guys,

I'd like to let you know you have a great product and i love using it.  I 
noticed that when you add muliple foreign keys in the "Create Table" wizard, 
the SQL string generated does not put a comma between the different foreign 
keys.  For instance, the log reads:

9/16/2001 10:08:22 PM - SQL (hedge): CREATE TABLE 
"component_container_assign" ("c_cont_id" int4 NOT NULL, "row" int2 NOT 
NULL, "column" int2 NOT NULL, "l_comp_id" int4 NOT NULL, "group_id" int2 NOT 
NULL, "row_span" int2 NOT NULL, "col_span" int2 NOT NULL, PRIMARY KEY 
("c_cont_id", "row", "column"), CONSTRAINT "c_cont_ass_c_id_fk" FOREIGN KEY 
("c_cont_id") REFERENCES "component_containers" ("c_cont_id")  ON DELETE 
CASCADE ON UPDATE CASCADE INITIALLY IMMEDIATECONSTRAINT 
"c_cont_ass_comp_id_fk" FOREIGN KEY ("l_comp_id") REFERENCES 
"layout_components" ("l_comp_id")  ON DELETE CASCADE ON UPDATE CASCADE 
INITIALLY IMMEDIATE)

when it should read:

9/16/2001 10:09:48 PM - SQL (hedge):  CREATE TABLE 
"component_container_assign" ("c_cont_id" int4 NOT NULL, "row" int2 NOT 
NULL, "column" int2 NOT NULL, "l_comp_id" int4 NOT NULL, "group_id" int2 NOT 
NULL, "row_span" int2 NOT NULL, "col_span" int2 NOT NULL, PRIMARY KEY 
("c_cont_id", "row", "column"), CONSTRAINT "c_cont_ass_c_id_fk" FOREIGN KEY 
("c_cont_id") REFERENCES "component_containers" ("c_cont_id") ON DELETE 
CASCADE ON UPDATE CASCADE INITIALLY IMMEDIATE, CONSTRAINT 
"c_cont_ass_comp_id_fk" FOREIGN KEY ("l_comp_id") REFERENCES 
"layout_components" ("l_comp_id") ON DELETE CASCADE ON UPDATE CASCADE 
INITIALLY IMMEDIATE)

with the comma between the IMMEDIATE and the CONSTRAINT on the third line 
from the bottom.  I hope this helps, and keep up the good work.

Mike

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


pgadmin-support by date

Next:From: Dave PageDate: 2001-09-17 08:08:25
Subject: Re: bug report
Previous:From: Dave PageDate: 2001-09-14 14:47:33
Subject: Re: [ODBC] pgAdmin II /odbc connect errors

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