Re: [BUGS] Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable

2009-04-25 Thread Daniel Grace
On Sat, Apr 25, 2009 at 9:52 AM, Tom Lane wrote: > Daniel Grace writes: > > The following nonsensical query causes PostgreSQL to fail with ERROR: > plan > > should not reference subplan's variable. (This was stripped down from an > > 'useful' query that triggered the same bug). First encounter

Re: [BUGS] BUG #4772: The server is hanging

2009-04-25 Thread Devrim GÜNDÜZ
On Wed, 2009-04-22 at 04:41 -0700, John R Pierce wrote: > now, 8.3.1 is a early version in the 8.3 series (they are up to > 8.3.7). before persuing too many other avenues, I think I'd > temporarily disable postgres (boot up in safe mode, and disable the > postgres service via `chkconfig` or

Re: [BUGS] Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable

2009-04-25 Thread Tom Lane
Daniel Grace writes: > The following nonsensical query causes PostgreSQL to fail with ERROR: plan > should not reference subplan's variable. (This was stripped down from an > 'useful' query that triggered the same bug). First encountered on 8.3.4, > reproduced on 8.3.7 Patch is here: http://arc

[BUGS] PGAdminIII Query Tool Edit Window Key Commands stopped working between 1.0 and 1.10.0 beta.

2009-04-25 Thread Larry Silvermintz
Hello, I just (April 20 download) switched from PG 8.3 (with the PgAdminIII that it shipped with, to 8.4 beta, with it's included PGAdminIII 1.10.0 beta. I am running the Win32 (Precompiled) version on Win XP Pro. Language: English. In the Query Tool Edit window, the tab key Commands stopped w

[BUGS] BUG #4782: pljava.dll version mismatch

2009-04-25 Thread Santi Wangkerkoon
The following bug has been logged online: Bug reference: 4782 Logged by: Santi Wangkerkoon Email address: sant...@yahoo.com PostgreSQL version: 8.4beta1 Operating system: windows Description:pljava.dll version mismatch Details: Query - share/pljva/install.sql ERROR

[BUGS] BUG #4781: Error de Windows Installer

2009-04-25 Thread Alejandro Oyarce
The following bug has been logged online: Bug reference: 4781 Logged by: Alejandro Oyarce Email address: alejandro_oya...@live.cl PostgreSQL version: 8.3.7-1 Operating system: Windows 2000 Description:Error de Windows Installer Details: Estimados, necesito de vuestr