Re: [BUGS] BUG #5902: pl/pgsql plans are not invalidated on discard all

2011-03-01 Thread Ingmar Brouns
Hi Tom, thanks for your reply. > > I was looking for a workaround to this problem, and figured that calling > > 'discard all', or 'discard plans' should do the trick. > > That's not a solution because the plancache module intentionally > preserves the original search_path value while replanning.

Re: [BUGS] BUG #5902: pl/pgsql plans are not invalidated on discard all

2011-03-01 Thread Merlin Moncure
On Tue, Mar 1, 2011 at 5:11 AM, Ingmar Brouns wrote: > Hi Tom, > > thanks for your reply. > >> >> > I was looking for a workaround to this problem, and figured that calling >> > 'discard all', or 'discard plans' should do the trick. >> >> That's not a solution because the plancache module intentio

[BUGS] BUG #5905: segfault on pg_terminate_backend

2011-03-01 Thread Matt Harrington
The following bug has been logged online: Bug reference: 5905 Logged by: Matt Harrington Email address: matt.harring...@rentrak.com PostgreSQL version: 8.4.3 Operating system: CentOS 4.7 Description:segfault on pg_terminate_backend Details: I have occasionally trigg

Re: [BUGS] BUG #5905: segfault on pg_terminate_backend

2011-03-01 Thread Merlin Moncure
On Tue, Mar 1, 2011 at 12:50 PM, Matt Harrington wrote: > > The following bug has been logged online: > > Bug reference:      5905 > Logged by:          Matt Harrington > Email address:      matt.harring...@rentrak.com > PostgreSQL version: 8.4.3 > Operating system:   CentOS 4.7 > Description:    

Re: [BUGS] BUG #5905: segfault on pg_terminate_backend

2011-03-01 Thread Heikki Linnakangas
On 01.03.2011 20:50, Matt Harrington wrote: Bug reference: 5905 Logged by: Matt Harrington Email address: matt.harring...@rentrak.com PostgreSQL version: 8.4.3 Operating system: CentOS 4.7 Description:segfault on pg_terminate_backend Details: I have occasionally trig

Re: [BUGS] BUG #5905: segfault on pg_terminate_backend

2011-03-01 Thread Matt Harrington
Thank you both! I will get right on the upgrade. On Tue, Mar 1, 2011 at 11:26 AM, Heikki Linnakangas < heikki.linnakan...@enterprisedb.com> wrote: > On 01.03.2011 20:50, Matt Harrington wrote: > >> Bug reference: 5905 >> Logged by: Matt Harrington >> Email address: matt.harrin

Re: [BUGS] BUG #5905: segfault on pg_terminate_backend

2011-03-01 Thread Craig Ringer
On 02/03/11 02:50, Matt Harrington wrote: > > The following bug has been logged online: > > Bug reference: 5905 > Logged by: Matt Harrington > Email address: matt.harring...@rentrak.com > PostgreSQL version: 8.4.3 > Operating system: CentOS 4.7 > Description:segfault