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?

No. Please give me a line to add.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026