Re: inheritance question 2/ref integrity - Mailing list pgsql-hackers

From Chris
Subject Re: inheritance question 2/ref integrity
Date
Msg-id 39E052E8.A9460471@bitmead.com
Whole thread Raw
In response to inheritance question 2/ref integrity  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-hackers
The referential integrity doesn't work properly with inheritance I
think. It would be nice if it was fixed to work with inheritance but
that would probably also need inheritable indexes to work (?? I don't
know how much ref integrity relies on having an index in place).

Alex Pilosov wrote:
> 
> Can I do  following?
> 
> create table foo (
> x int4 references bar*
> )
> 
> Or, since 7.1 will have bar* as default for bar, will using 'references
> bar' do what I want?
> 
> -alex

-- 
Chris Bitmead
mailto:chris@bitmead.com
http://www.techphoto.org - Photography News, Stuff that Matters


pgsql-hackers by date:

Previous
From: Chris
Date:
Subject: Re: inheritance/oid questions
Next
From: Bruce Momjian
Date:
Subject: Re: Suggested change in include/utils/elog.h