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@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
