| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | bpalmer <bpalmer(at)crimelabs(dot)net> |
| Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 7.4 Wishlist |
| Date: | 2002-11-30 20:13:48 |
| Message-ID: | 1038687228.72409.76.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-general pgsql-hackers |
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(at)rbt(dot)ca>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Langille | 2002-11-30 20:19:09 | Re: 7.4 Wishlist |
| Previous Message | bpalmer | 2002-11-30 20:06:15 | Re: 7.4 Wishlist |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Langille | 2002-11-30 20:19:09 | Re: 7.4 Wishlist |
| Previous Message | bpalmer | 2002-11-30 20:06:15 | Re: 7.4 Wishlist |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Wheeler | 2002-11-30 20:18:23 | Re: Boolean casting in 7.3 -> changed? |
| Previous Message | bpalmer | 2002-11-30 20:06:15 | Re: 7.4 Wishlist |