Re: [HACKERS] inheritance question 2/ref integrity

2000-10-08 Thread Chris
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: > >

Re: [HACKERS] inheritance question 2/ref integrity

2000-10-07 Thread Stephan Szabo
On Sat, 7 Oct 2000, 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? No, and not really. Parts of it may sort of work, but referential actions will

[HACKERS] inheritance question 2/ref integrity

2000-10-07 Thread Alex Pilosov
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