Horton

Re: 7.4 Wishlist

Rod Taylor <rbt@rbt.ca>

View thread View on postgr.es
From: Rod Taylor <rbt@rbt.ca>
To: bpalmer <bpalmer@crimelabs.net>
Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2002-11-30T20:13:48Z
Lists: pgsql-hackers, pgsql-general 
On Sat, 2002-11-30 at 15:06, bpalmer wrote:
> > * Compliant ADD COLUMN
> 
> I've missed the thread (if there was one),  how is it non-compliant?

ALTER TABLE .. ADD COLUMN colname integer DEFAULT 42 NOT NULL
CHECK(colname <= 42) REFERENCES tab2 ON DELETE CASCADE;

Can't do the above in a single statement.  It takes five statements.

It's something I'd like to see added as well.

-- 
Rod Taylor <rbt@rbt.ca>