On Mon, Mar 14, 2011 at 12:42 PM, Samba GUEYE <samba.gueye@xxxxxxxxxxxx> wrote: > Yeah but is there a workaround to force the root table to propagate the > foreign key to the partitionned table > because right now all foreign keys to partitionned table throws constraints > violation and it's a big problem for me No. Generally, table partitioning is not a good idea unless you are dealing with really large tables, and nearly all of your queries apply only to a single partition. Most likely you are better off not using table inheritance in the first place if you need this feature. It would be nice if we had a way to do this for the rare cases where it would be useful, but we don't. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
