[BUGS] BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5

2007-05-29 Thread chee leong
The following bug has been logged online: Bug reference: 3318 Logged by: chee leong Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Windows XP Description:PostgreSQL : server process (PID 3480) was terminated by signal 5 Details: Dear Si

[BUGS] BUG #3319: Superuser can't revoke grants on a schema given by aother user

2007-05-29 Thread Pedro Gimeno
The following bug has been logged online: Bug reference: 3319 Logged by: Pedro Gimeno Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux Description:Superuser can't revoke grants on a schema given by aother user Details: When a USAGE

[BUGS] [HACKERS] exit

2007-05-29 Thread Marcos Fabrício Corso
I would like to leave the list ...  -- Acelerador POP Acelere a sua conexão discada em até 19 x. Use o Acelerador POP. É grátis, pegue já o seu. http://www.pop.com.br/acelerador

Re: [BUGS] [HACKERS] exit

2007-05-29 Thread Richard Huxton
Marcos Fabrício Corso wrote: I would like to leave the list ... Not really a question worth posting several lists. If you don't know how to unsubscribe, try starting with the form linked from here. http://www.postgresql.org/community/lists/ -- Richard Huxton Archonet Ltd --

[BUGS] BUG #3320: Error when using INSERT...RETURNING as a subquery

2007-05-29 Thread Jan Szumiec
The following bug has been logged online: Bug reference: 3320 Logged by: Jan Szumiec Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Windows XP Description:Error when using INSERT...RETURNING as a subquery Details: Having: CREATE TABLE

Re: [BUGS] BUG #3319: Superuser can't revoke grants on a schema given by aother user

2007-05-29 Thread Tom Lane
"Pedro Gimeno" <[EMAIL PROTECTED]> writes: > When a USAGE grant on a SCHEMA is given by an user (non-superuser in my > case), the superuser can't revoke it; instead the REVOKE statement is > silently ignored. This is not a bug. If you want to revoke the privilege, revoke the GRANT OPTION you orig

Re: [BUGS] BUG #3320: Error when using INSERT...RETURNING as a subquery

2007-05-29 Thread Tom Lane
"Jan Szumiec" <[EMAIL PROTECTED]> writes: > UPDATE items SET (type, post_id) = (INSERT INTO efforts (effort) VALUES > (667) RETURNING 'Item', id) WHERE id = 1937 Sorry, RETURNING is only supported at the top level of a query. regards, tom lane ---(

Re: [BUGS] BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5

2007-05-29 Thread Bruce Momjian
What is signal 5 in XP? I looked in the MinGW source used to build PostgreSQL 8.1.4 and there is no mention of a signal 5 there. I see signal 5 mentioned here: http://archives.postgresql.org/pgsql-bugs/2004-11/msg00175.php and it was diagnosed as an invalid memory access. I suggest yo

Re: [BUGS] BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5

2007-05-29 Thread Magnus Hagander
Bruce Momjian wrote: > What is signal 5 in XP? I looked in the MinGW source used to build > PostgreSQL 8.1.4 and there is no mention of a signal 5 there. I see > signal 5 mentioned here: Access denied. Most often showed for accessing memory outside the mapped space, so this similar to SIGSEGV.

Re: [BUGS] BUG #3320: Error when using INSERT...RETURNING as a subquery

2007-05-29 Thread David Fetter
On Tue, May 29, 2007 at 09:41:38AM -0400, Tom Lane wrote: > "Jan Szumiec" <[EMAIL PROTECTED]> writes: > > UPDATE items SET (type, post_id) = (INSERT INTO efforts (effort) VALUES > > (667) RETURNING 'Item', id) WHERE id = 1937 > > Sorry, RETURNING is only supported at the top level of a query. Wha

Re: [BUGS] BUG #3320: Error when using INSERT...RETURNING as a subquery

2007-05-29 Thread Gregory Stark
"David Fetter" <[EMAIL PROTECTED]> writes: > On Tue, May 29, 2007 at 09:41:38AM -0400, Tom Lane wrote: >> "Jan Szumiec" <[EMAIL PROTECTED]> writes: >> > UPDATE items SET (type, post_id) = (INSERT INTO efforts (effort) VALUES >> > (667) RETURNING 'Item', id) WHERE id = 1937 >> >> Sorry, RETURNING

[BUGS] BUG #3321: No start service

2007-05-29 Thread Alceu Paz
The following bug has been logged online: Bug reference: 3321 Logged by: Alceu Paz Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Windows XP Description:No start service Details: When the service of postgres initiates windows Xp this mark

Re: [BUGS] BUG #3320: Error when using INSERT...RETURNING as a subquery

2007-05-29 Thread Jeff Davis
On Tue, 2007-05-29 at 18:10 +0100, Gregory Stark wrote: > It has the same problem that SELECT triggers have. How many rows should you > expect that subquery to insert, update, or delete if it's used in a join > clause? Or in the where clause of another insert/update/delete statement? > We could h

Re: [BUGS] BUG #3320: Error when using INSERT...RETURNING as a subquery

2007-05-29 Thread Tom Lane
Jeff Davis <[EMAIL PROTECTED]> writes: > On Tue, 2007-05-29 at 18:10 +0100, Gregory Stark wrote: >> It has the same problem that SELECT triggers have. How many rows should you >> expect that subquery to insert, update, or delete if it's used in a join >> clause? Or in the where clause of another in