Re: table contraints checks only happen in planner phase

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: table contraints checks only happen in planner phase
Date: 2011-04-01 17:32:24
Message-ID: 4D960C28.9020401@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Eliot Gable 2011-04-02 18:52:28 C on Client versus C on Server
Previous Message Greg Smith 2011-04-01 06:50:47 Re: COPY with high # of clients, partitioned table locking issues?