Re: [SQL] database design SQL prob.

D'Arcy Cain <darcy@druid.net>

From: "D'Arcy" "J.M." Cain <darcy@druid.net>
To: yura@vpcit.ru (Don Yury)
Cc: pgsql-sql@postgreSQL.org, pgsql-hackers@postgreSQL.org
Date: 1999-07-26T10:30:57Z
Lists: pgsql-hackers
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@{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.