Received: from druid.net (root@druid.net [216.126.72.98]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA20272; Mon, 26 Jul 1999 06:30:59 -0400 (EDT) (envelope-from darcy@druid.net) Received: from localhost (1321 bytes) by druid.net via sendmail with P:stdio/R:bind_hosts/T:inet_zone_bind_smtp (sender: ) (ident using unix) id for ; Mon, 26 Jul 1999 06:30:58 -0400 (EDT) (Smail-3.2.0.104 1998-Nov-20 #4 built 1999-Apr-13) Message-Id: Subject: Re: [SQL] database design SQL prob. In-Reply-To: <379BE136.BF6EB662@vpcit.ru> from Don Yury at "Jul 26, 1999 10:16:54 am" To: yura@vpcit.ru (Don Yury) Date: Mon, 26 Jul 1999 06:30:57 -0400 (EDT) From: "D'Arcy" "J.M." Cain Cc: pgsql-sql@postgreSQL.org, pgsql-hackers@postgreSQL.org Reply-To: pgsql-hackers@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL50 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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 | 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.