Re: [BUGS] BUG #3958: Self-Join Group-By Clause Produces Incorrect Results

2008-02-14 Thread Marc SanF
I respectfully challenge that the aggregation is correct. In the where clause, I specify A2.AUDIT_TYPE_CODE = CONTENT_2, thus returning only 2 rows for A2 and not all of the rows in A2 which happen to have a TXN_COUNT of 1 / row but could in fact be any positive number. I used 1 for simplici

Re: [BUGS] BUG #3958: Self-Join Group-By Clause Produces Incorrect Results

2008-02-14 Thread Marc SanF
Please disregard the previous email. After rereading what you sent, I realized that I need an outer join to A2 and not simply a self join...thanks and my apologies! - Original Message From: Tom Lane <[EMAIL PROTECTED]> To: Heikki Linnakangas <[EMAIL PROTECTED]> Cc: Marcus Torres <[EMAI

[BUGS] BUG #3960: initdb.log

2008-02-14 Thread Anto
The following bug has been logged online: Bug reference: 3960 Logged by: Anto Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Windows Vista Description:initdb.log Details: initdb.log is failed to run while installation. Please provide t

[BUGS] BUG #3961: ecpg lacks SQLSTATE macro definition

2008-02-14 Thread Christoph Dalitz
The following bug has been logged online: Bug reference: 3961 Logged by: Christoph Dalitz Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: Linux Description:ecpg lacks SQLSTATE macro definition Details: While ecpg defines the (deprecated)

Re: [BUGS] BUG #3960: initdb.log

2008-02-14 Thread Magnus Hagander
Anto wrote: The following bug has been logged online: Bug reference: 3960 Logged by: Anto Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Windows Vista Description:initdb.log Details: initdb.log is failed to run while installation. Pl

[BUGS] BUG #3962: Error on database cluster

2008-02-14 Thread Arjan Bolmer
The following bug has been logged online: Bug reference: 3962 Logged by: Arjan Bolmer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0-1 Operating system: Vista Description:Error on database cluster Details: When installing postgreSQL i ran into an error w

Re: [BUGS] BUG #3961: ecpg lacks SQLSTATE macro definition

2008-02-14 Thread Michael Meskes
Hallo Christoph, On Thu, Feb 14, 2008 at 11:09:11AM +, Christoph Dalitz wrote: > Description:ecpg lacks SQLSTATE macro definition Thanks for reporting this oversight. I added the definition to CVS, also for 8.2. Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De, Michael

Re: [BUGS] BUG #3961: ecpg lacks SQLSTATE macro definition

2008-02-14 Thread Tom Lane
Michael Meskes <[EMAIL PROTECTED]> writes: > Hallo Christoph, > On Thu, Feb 14, 2008 at 11:09:11AM +, Christoph Dalitz wrote: >> Description:ecpg lacks SQLSTATE macro definition > Thanks for reporting this oversight. I added the definition to CVS, also > for 8.2. Michael, we branched

[BUGS] BUG #3963: trigger delete

2008-02-14 Thread Ronald Mora
The following bug has been logged online: Bug reference: 3963 Logged by: Ronald Mora Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: windows xp Description:trigger delete Details: Para la modificacion de los datos de los cliente, cree trig