Re: table contraints checks only happen in planner phase

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: table contraints checks only happen in planner phase
Дата
Msg-id 4D960C28.9020401@agliodbs.com
обсуждение исходный текст
Ответ на table contraints checks only happen in planner phase  (Joseph Shraibman <jks@selectacast.net>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: COPY with high # of clients, partitioned table locking issues?
Следующее
От: Eliot Gable
Дата:
Сообщение: C on Client versus C on Server