Re: [HACKERS] Inheritance, referential integrity and other constraints - Mailing list pgsql-hackers

From Don Baccus
Subject Re: [HACKERS] Inheritance, referential integrity and other constraints
Date
Msg-id 3.0.1.32.20000126110539.00fb0790@mail.pacifier.com
Whole thread Raw
In response to Inheritance, referential integrity and other constraints  ("Oliver Elphick" <olly@lfix.co.uk>)
Responses Re: [HACKERS] Inheritance, referential integrity and other constraints
List pgsql-hackers
At 07:35 PM 1/26/00 +0100, Peter Eisentraut wrote:
>On 2000-01-24, Oliver Elphick mentioned:
>
>> I would like to work on improving implementation of inheritance,
>> especially with regard to referential integrity.   I suspect there are
>> a number of issues that may be related and will need to be done together.
>
>What I really consider a problem, and it would be great if you could
>tackle that, is that there is no real standard that all of this does or
>even could follow. For example, I wrote the other day that depending on
>which way you see it, the behaviour of alter table x* add colum might be
>considered right.

Are you basing this on your earlier comment:

"
Or maybe look at it this way:
create table test1 (a int4);
create table test2 (b int4) inherits (test1);                   ^ col #1          ^ col #2
alter table test1* add column c int4;                             ^ col #3

"?

If so, I thought Oliver pointed out that you had the numbering wrong.
I thought so, too...

Which is right?



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.
 


pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: RE: [HACKERS] --enable-debug
Next
From: Don Baccus
Date:
Subject: Re: AW: AW: [HACKERS] Some notes on optimizer cost estimates