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

2008-02-13 Thread Marcus Torres
The following bug has been logged online: Bug reference: 3958 Logged by: Marcus Torres Email address: [EMAIL PROTECTED] PostgreSQL version: 8.19 Operating system: Linux - Ubuntu Description:Self-Join Group-By Clause Produces Incorrect Results Details: This is a repo

[BUGS] BUG #3959: Huge calculation error

2008-02-13 Thread Renaud Diez
The following bug has been logged online: Bug reference: 3959 Logged by: Renaud Diez Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Debian Description:Huge calculation error Details: the basic mathematical expression like the following on

Re: [BUGS] BUG #3959: Huge calculation error

2008-02-13 Thread Heikki Linnakangas
Renaud Diez wrote: The following bug has been logged online: Bug reference: 3959 Logged by: Renaud Diez Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Debian Description:Huge calculation error Details: the basic mathematical expression

Re: [BUGS] BUG #3959: Huge calculation error

2008-02-13 Thread Magnus Hagander
Renaud Diez wrote: The following bug has been logged online: Bug reference: 3959 Logged by: Renaud Diez Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Debian Description:Huge calculation error Details: the basic mathematical expression

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

2008-02-13 Thread Heikki Linnakangas
Marcus Torres wrote: The following bug has been logged online: Bug reference: 3958 Logged by: Marcus Torres Email address: [EMAIL PROTECTED] PostgreSQL version: 8.19 Operating system: Linux - Ubuntu Description:Self-Join Group-By Clause Produces Incorrect Results Det

Re: [BUGS] BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name

2008-02-13 Thread Adam Hardy
Kris Jurka on 12/02/08 16:40, wrote: On Tue, 12 Feb 2008, Adam Hardy wrote: Because this rules out certain important features of the JPA framework such as native SQL queries, you may want to prioritize this issue. I will have to use Oracle or mySQL until PostgreSQL can rectify things. I woul

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

2008-02-13 Thread Tom Lane
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Marcus Torres wrote: >> I wrote a simple self-join query to sum the transaction count of different >> types of records in a audit table and the result set for the different sum >> totals was the same which is incorrect. > Looks perfectly correct

Re: [BUGS] BUG #3959: Huge calculation error

2008-02-13 Thread Rodriguez Fernando
Renaud Diez wrote: The following bug has been logged online: Bug reference: 3959 Logged by: Renaud Diez Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Debian Description:Huge calculation error Details: the basic mathematical expression

[BUGS] psql malloc problem

2008-02-13 Thread Marc Munro
Postgres version 8.3.0 on Mac OSX Version 10.4.11 Built from source with no parameters to configure script (ie a simple default build). Error occurs every time I exit psql: marc:[prototype]$ psql -d postgres Welcome to psql 8.3.0, the PostgreSQL interactive terminal. Type: \copyright for d

Re: [BUGS] psql malloc problem

2008-02-13 Thread Tom Lane
Marc Munro <[EMAIL PROTECTED]> writes: > Postgres version 8.3.0 on Mac OSX Version 10.4.11 > Error occurs every time I exit psql: This is a known bug in Apple's version of libedit. Your options are to update to OSX 10.5 (where they fixed it) or to use readline instead of libedit. See the PG arch