[BUGS] BUG #4463: unique constraint error

2008-10-10 Thread zhengzhong_zhou
The following bug has been logged online: Bug reference: 4463 Logged by: zhengzhong_zhou Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: centos 5.2 x64 Description:unique constraint error Details: i create a table : tbl_test (col1 varch

[BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-10 Thread Tony Marston
The following bug has been logged online: Bug reference: 4465 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: Windows XP Description:GROUP BY is not to SQL standard Details: The Postgresql implementation of GROUP

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-10 Thread Peter Eisentraut
Tony Marston wrote: The following bug has been logged online: Bug reference: 4465 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: Windows XP Description:GROUP BY is not to SQL standard Details: The Postgresql im

Re: [BUGS] BUG #4462: Adding COUNT to query causes massive slowdown

2008-10-10 Thread Jussi Pakkanen
On Thu, Oct 9, 2008 at 6:55 PM, Tom Lane <[EMAIL PROTECTED]> wrote: >> Given that PostgreSQL does the scan even with the huge seqscan >> penalty, I can think of only two different causes: >> 1) some sort of a bug in the query analyzer >> 2) SELECT COUNT(DISTINCT x) for some reason requires informa

Re: [BUGS] BUG #4462: Adding COUNT to query causes massive slowdown

2008-10-10 Thread Tom Lane
"Jussi Pakkanen" <[EMAIL PROTECTED]> writes: > On Thu, Oct 9, 2008 at 6:55 PM, Tom Lane <[EMAIL PROTECTED]> wrote: >> Try (3) COUNT(DISTINCT x) ... or any DISTINCT aggregate for that matter >> ... is implemented by a sort-and-uniq step inside the aggregate function >> itself. You can't see it in t