| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Chris Bitmead <chrisb(at)nimrod(dot)itg(dot)telstra(dot)com(dot)au> |
| Cc: | "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com>, Postgres Hackers List <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: SQL3 UNDER |
| Date: | 2000-05-23 06:40:42 |
| Message-ID: | 392A27EA.7182B07B@tm.ee |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Chris Bitmead wrote:
>
> "Robert B. Easter" wrote:
> > This contrasts with UNDER, where a subtable does maintain a link to its
> > supertable in order to cascade inserts etc to the supertable for the subrow it
> > inherited.
>
> What you have just described for the behaviour of UNDER (as opposed to
> implementation) is just how INHERITS works now. i.e. you can't destroy
> the parent unless there are no children.
We could supply DROP TABLE parent CASCADE; syntax to destroy bot parent and
all
inherited tables.
---------------------
Hannu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthias Urlichs | 2000-05-23 06:40:54 | Re: A test to add to the crashme test |
| Previous Message | Robert B. Easter | 2000-05-23 06:16:52 | Re: SQL3 UNDER |