Thread: bug report

bug report

From
"Mike Arace"
Date:
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


Re: bug report

From
Dave Page
Date:

> -----Original Message-----
> From: Mike Arace [mailto:mikearace@hotmail.com]
> Sent: 17 September 2001 03:20
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] bug report
>
>
> Hey guys,
>
> I'd like to let you know you have a great product and i love
> using it.

Thanks, It's good to know people like what we're doing.

> 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:

<snip>

Thanks for the info. I've fixed this now in the cvs and am preparing a new
preview release at the moment.

Regards, Dave.