Re: [GENERAL] FK violation on (emtpy) parent table

2011-09-04 Thread Jasen Betts
On 2011-08-11, Louis-David Mitterrand wrote: > Hi, > > I have an empty parent 'price' table with several partitioned child > tables that contain the actual data. > > How can I reference the parent 'price' table in a FK? When I try I get a > FK violation. Is that expected behavior? Is there anothe

Re: [GENERAL] Parameterized prepared statements

2011-09-04 Thread Martijn van Oosterhout
On Wed, Aug 31, 2011 at 09:44:09AM +0800, Craig Ringer wrote: > Things like pre-parsed prepared statements that're re-planned on > every execution are often proposed as solutions to this. This has me > wondering: rather than expensively re-planning from scratch, would > it be possiblet to adjust th

Re: [GENERAL] Parameterized prepared statements

2011-09-04 Thread Dmitriy Igrishin
Hey Craig, Things like pre-parsed prepared statements that're re-planned on every > execution are often proposed as solutions to this. This has me wondering: > rather than expensively re-planning from scratch, would it be possiblet to > adjust the planning process so that *multiple* alternative pl

Re: [GENERAL] CentOS 6 - www.pgrpms.org - SELinuxi dn

2011-09-04 Thread Devrim GÜNDÜZ
Hi, On Fri, 2011-09-02 at 20:18 -0700, Michael A. Peters wrote: > I'm setting up a new server for a CMS I have written (er, partially, > needs work) that uses PostgreSQL as a backend. > > All my existing CentOS 5 servers, I use pgrpms for PostgreSQL. > > I would like to do the same with CentOS