Re: [SQL] An easy question about creating a primary key
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Ligia Pimentel" <lmpimentel@yahoo.com>, "Hackers" <pgsql-hackers@postgresql.org>
Date: 2001-12-04T02:23:19Z
Lists: pgsql-hackers, pgsql-sql
> I think you've forgotten your own work, Chris. > > regression=# create table foo (bar int not null); > CREATE > regression=# alter table foo add primary key (bar); > NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index > 'foo_pkey' for table 'foo' > CREATE > regression=# Bizarre. That patch was never committed. If you check src/backend/commands/command.c and search for 'CONSTR_' you'll notice that the CONSTR_UNIQUE function I implemented is there, but CONSTR_PRIMARY is definitely not being handled. (I'm looking at the 7.2b2 source code) Chris