Re: [SQL] An easy question about creating a primary key

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [SQL] An easy question about creating a primary key
Date: 2002-01-02 03:36:53
Message-ID: GNELIHDDFBOCMGBFGEFOMEPNCAAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-odbc pgsql-sql

Note that although I added a regression test for ADD UNIQUE (and had some
confusion as it was Tom's error messages generated, not mine!), I didn't add
an ADD PRIMARY KEY one. It should be done in 7.3 I guess.

Chris

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Friday, 28 December 2001 1:11 PM
> To: Tom Lane
> Cc: Christopher Kings-Lynne; Ligia Pimentel; Hackers
> Subject: Re: [HACKERS] [SQL] An easy question about creating a primary
> key
>
>
>
> Is this resolved?
>
> ------------------------------------------------------------------
> ---------
>
> > "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:
> > > Oh well, it was a fun coding exercise ;) Feel free to remove
> the ADD UNIQUE
> > > stuff from command.c to see if the parser will handle it.
> However, your
> > > commit message also just implies that all you fixed was ADD
> PRIMARY KEY???
> >
> > It says that because I thought that was all I was changing; I hadn't
> > realized the side-effects on ADD UNIQUE.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(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
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Barry Lind 2002-01-02 05:23:44 Re: problems with new vacuum (??)
Previous Message Tom Lane 2002-01-02 01:07:53 Re: problems with new vacuum (??)

Browse pgsql-odbc by date

  From Date Subject
Next Message Tatsuo Ishii 2002-01-03 01:18:25 Re: LWLock contention: I think I understand the problem
Previous Message Bruce Momjian 2001-12-30 23:44:13 My email is fixed

Browse pgsql-sql by date

  From Date Subject
Next Message Karel Zak 2002-01-02 13:04:07 Re: [SQL] Unpredictable text -> date implicit casting behaviour/to_date bug
Previous Message Calvin Dodge 2002-01-01 23:50:06 Re: PostgreSQL SELECT error