Re: BUG #3479: contraint exclusion and locks - Mailing list pgsql-bugs

From Gregory Stark
Subject Re: BUG #3479: contraint exclusion and locks
Date
Msg-id 87fy3fkuap.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: BUG #3479: contraint exclusion and locks  (Tiago Daniel Jacobs <tiago@mdtestudio.com.br>)
List pgsql-bugs
"Tiago Daniel Jacobs" <tiago@mdtestudio.com.br> writes:

> <small><font face="Arial">Tom and Gregory.  U're right! The problem is
> that we're using constraints for partitioned tables and by definition,
> a partition never, absolutely never, can affect the entire system.<br>
> <br>
> But I think that we have nothing to do about this. There are plans to
> another kind of partitioning? If yes, I would like to contribute. If
> not, i`m okay. <br>

There are lots of ideas of where to go with partitioning including possibly
ditching the use of constraints. But I don't think there's any settled plans
yet.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: Tiago Daniel Jacobs
Date:
Subject: Re: BUG #3479: contraint exclusion and locks
Next
From: "christof.elmiger"
Date:
Subject: BUG #3481: wrong link on website?