Re: ALTER .. ADD PRIMARY KEY

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Rod Taylor" <rbt(at)rbt(dot)ca>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ALTER .. ADD PRIMARY KEY
Date: 2002-12-02 21:04:14
Message-ID: 019001c29a46$89b08370$6500a8c0@internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Just check out the AlterTableSetNotNull function in tablecmds.c to see a
quick and easy example of checking for NULL values.

Chris

----- Original Message -----
From: "Rod Taylor" <rbt(at)rbt(dot)ca>
To: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Sent: Monday, December 02, 2002 12:31 PM
Subject: [HACKERS] ALTER .. ADD PRIMARY KEY

Right now ALTER .. ADD PRIMARY KEY insists that the columns must be NOT
NULL first. I'd like to change it so that it automatically creates the
NOT NULL constraint (same as CREATE TABLE). I didn't see anything in
the spec for or against doing this automatically.

I believe the best way to do this is to move the NULL test to
index_create or CreateConstraintEntry (leaning towards the latter) and
use the AlterTableAlterColumnSetNotNull function to add in the bits.

This cleans out a good chuck of transformIndexConstraints(), and will
allow PRIMARY KEYS on inherited columns do to the right thing in adding
a nullness bit.

On a new table, there are no rows to check, so alter table is almost
free. Likewise, we can add type checks to see if the type allows null,
skipping the table constraint if this is the case.

--
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-12-02 21:17:18 Re: protecting prosrc (was Re: [GENERAL] USAGE on schema allowed by
Previous Message Christopher Kings-Lynne 2002-12-02 21:04:11 Re: ALTER .. ADD PRIMARY KEY