Re: [SQL] database design SQL prob.

Thus spake Don Yury
> > Not completely accurate. Create some tables using both methods then
> However, if you create table with primary key, for example
>
> create table tab(
> id int4 primary key,
> ...
> );
>
> and make dump of database, it will write in dump file
>
> create table tab(
> id int4,
> ...
> );
> create unique index "tab_pkey" on "tab" using btree ("id");

So it does. I thought that this was fixed in 6.5 but it seems not. Is
this on the TODO list?

--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.