Re: [BUGS] Grantor name gets lost when grantor role dropped

2007-04-16 Thread Alvaro Herrera
Jeff Davis wrote: > CREATE ROLE test_role > NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE; > > CREATE ROLE invalid_grantor > SUPERUSER INHERIT NOCREATEDB NOCREATEROLE; > > SET ROLE invalid_grantor; > GRANT "postgres" TO "test_role"; > SET ROLE postgres; > > select * from pg_roles; > > se

[BUGS] Grantor name gets lost when grantor role dropped

2007-04-16 Thread Jeff Davis
I am sending this email on behalf of Russel Smith. He discovered this bug and his description follows: Verified on 8.2.3 on Fedora Core 6 Verified on 8.1.3 on RHEL4, custom compile. (I can't control the update to 8.1.8) The output of an empty role name would possibly not be a problem, but when

Re: [BUGS] BUG #3230: Division problem

2007-04-16 Thread Jon Sime
Jeferson Kasper wrote: > The following bug has been logged online: > > Bug reference: 3230 > Logged by: Jeferson Kasper > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.5 > Operating system: Linux RedHat 9 > Description:Division problem > Details: > > i w

Re: [BUGS] BUG #3230: Division problem

2007-04-16 Thread Theodore Petrosky
try: select 30/50::float; ?column? -- 0.6 (1 row) Ted --- Jeferson Kasper <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 3230 > Logged by: Jeferson Kasper > Email address: [EMAIL PROTECTED] > PostgreSQL version:

Re: [BUGS] BUG #3231: Duplicate rows primary key bug

2007-04-16 Thread Heikki Linnakangas
Amorn Buchheit wrote: version - PostgreSQL 7.3.4 on i386-redhat-linux-gnu, compiled by GCC 2.96 There are several tables have two same rows with the same primary key. Some tables have a unique index with two same value. Thi

Re: [BUGS] BUG #3229: Incorrect temp table work

2007-04-16 Thread Stefan Kaltenbrunner
ALEXEY PARSHIN wrote: > The following bug has been logged online: > > Bug reference: 3229 > Logged by: ALEXEY PARSHIN > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.8 > Operating system: Gentoo Linux > Description:Incorrect temp table work > Details: >

[BUGS] BUG #3231: Duplicate rows primary key bug

2007-04-16 Thread Amorn Buchheit
The following bug has been logged online: Bug reference: 3231 Logged by: Amorn Buchheit Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.4 Operating system: Linux Description:Duplicate rows primary key bug Details: Duplicate primary key record Report

[BUGS] BUG #3230: Division problem

2007-04-16 Thread Jeferson Kasper
The following bug has been logged online: Bug reference: 3230 Logged by: Jeferson Kasper Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: Linux RedHat 9 Description:Division problem Details: i was trying to divide a number and the result

[BUGS] BUG #3228: Linux/M32R project

2007-04-16 Thread Kazuhiro Inaoka
The following bug has been logged online: Bug reference: 3228 Logged by: Kazuhiro Inaoka Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: linux Description:Linux/M32R project Details: Developing Linux/M32R. ---(end

[BUGS] BUG #3229: Incorrect temp table work

2007-04-16 Thread ALEXEY PARSHIN
The following bug has been logged online: Bug reference: 3229 Logged by: ALEXEY PARSHIN Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.8 Operating system: Gentoo Linux Description:Incorrect temp table work Details: If I call the following function two or m

Re: [BUGS] Continuous archiving fails

2007-04-16 Thread David Darville
On Thu, Apr 12, 2007 at 11:05:40AM -0400, Tom Lane wrote: > David Darville <[EMAIL PROTECTED]> writes: > > While testing a continuous archiving setup using PostgreSQL 8.2.3, on Debian > > Etch amd64, I found out that the slave database crashed when I did a 'DROP > > DATABASE' on the master. > > Th