Re: SQL3 UNDER - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: SQL3 UNDER
Date
Msg-id 392A27EA.7182B07B@tm.ee
Whole thread Raw
In response to SQL3 UNDER  (Chris Bitmead <chris@bitmead.com>)
List 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


pgsql-hackers by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: SQL3 UNDER
Next
From: Hannu Krosing
Date:
Subject: Re: A test to add to the crashme test