| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: ADD/DROP CONSTRAINT and inheritance |
| Date: | 2001-05-23 16:21:37 |
| Message-ID: | Pine.BSF.4.21.0105230917280.67638-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 23 May 2001, Christopher Kings-Lynne wrote:
> For the add/drop constraint clauses would it be an idea to change the syntax
> to:
>
> ALTER TABLE [ ONLY ] x ADD CONSTRAINT x;
> ALTER TABLE [ ONLY ] x DROP CONSTRAINT x;
>
> So that people can specify whether the constraint should be inherited or
> not?
I'm not sure. I don't much use the inheritance stuff, so I'm not sure
what would be better for them. Hopefully one of the people interested
in inheritance will speak up. :) Technically it's probably not difficult
to do.
A related question is whether or not you can drop a constraint on a
subtable that's inherited from a parent.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2001-05-23 16:21:48 | Re: Not released yet, but could someone take a quick peak ... |
| Previous Message | Bruce Momjian | 2001-05-23 15:58:51 | Re: More pgindent follies |