Re: Table inheritance foreign key problem

On Wed, Dec 22, 2010 at 12:32:44AM -0500, Andy Chambers wrote:
> Hi,
>
> One of the caveats described in the documentation for table
> inheritance is that foreign key constraints cannot cover the case
> where you want to check that a value is found somewhere in a table
> or in that table's descendants. It says there is no "good"
> workaround for this.

For some values of, "good," there actually is.

http://people.planetpostgresql.org/dfetter/index.php?/archives/51-Partitioning-Is-Such-Sweet-Sorrow.html
http://people.planetpostgresql.org/dfetter/index.php?/archives/59-Partitioning-Glances.html

Cheers,
David (hoping PostgreSQL will be able to infer how to automate this some day).
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate