Re: [SQL] database design SQL prob. - Mailing list pgsql-sql

From D'Arcy" "J.M." Cain
Subject Re: [SQL] database design SQL prob.
Date
Msg-id m118i26-0000bFC@druid.net
Whole thread Raw
In response to Re: [SQL] database design SQL prob.  (Don Yury <yura@vpcit.ru>)
Responses Re: [SQL] database design SQL prob.  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: [SQL] Expr Abbreviations/Functions?
Next
From: Herouth Maoz
Date:
Subject: Re: [SQL] NOT IN clause performing badly