On 3/31/11 5:41 PM, Joseph Shraibman wrote: > Is there a reason that when executing queries the table constraints are > only checked during planning and not execution? I end up making 2 round > trips to the database to get around this. This is a limitation with our current partitioning implementation. It only understands literal values, not JOINs. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance