Re: [GENERAL] Foreign keys to inherited tables

2008-03-20 Thread Leon Mergen
On 3/20/08, Erik Jones <[EMAIL PROTECTED]> wrote: > I think he's talking about foreign keys from a "partitioned table", > i.e. a parent and all of its child tables, to another table. That > would, at first, sound simple, but scenarios like this make it tricky > as something to be handled automa

Re: [GENERAL] Foreign keys to inherited tables

2008-03-19 Thread Erik Jones
On Mar 19, 2008, at 10:42 PM, brian wrote: Leon Mergen wrote: Hello, I was wondering, I'm reading that there is no support for foreign keys to inherited (child) tables -- are there any plans on supporting these in the (near) future, and/or are there any practical workarounds for this ?

Re: [GENERAL] Foreign keys to inherited tables

2008-03-19 Thread brian
Leon Mergen wrote: Hello, I was wondering, I'm reading that there is no support for foreign keys to inherited (child) tables -- are there any plans on supporting these in the (near) future, and/or are there any practical workarounds for this ? This has worked well for me: CREATE TABLE child_