[BUGS] BUG #5552: incorrect returned value of time

2010-07-12 Thread Konstantin Kulikov
The following bug has been logged online: Bug reference: 5552 Logged by: Konstantin Kulikov Email address: k.e.kuli...@gmail.com PostgreSQL version: 8.3 Operating system: unix Description:incorrect returned value of time Details: select current_timestamp at time zon

[BUGS] BUG #5553: Repeating the keyword DECLARE in the CREATE FUNCTION statement

2010-07-12 Thread Sergey
The following bug has been logged online: Bug reference: 5553 Logged by: Sergey Email address: s...@mail.ur.ru PostgreSQL version: 9 beta 2 Operating system: Windows XP Description:Repeating the keyword DECLARE in the CREATE FUNCTION statement Details: Is it a norma

Re: [BUGS] BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'

2010-07-12 Thread David Schmitt
On 7/9/2010 4:53 PM, Tom Lane wrote: "David Schmitt" writes: This is not implemented: DECLARE working_cursor NO SCROLL CURSOR FOR EXECUTE $$SELECT something $$ || tbl || $$ ... $$; What's wrong with OPEN FOR EXECUTE? The proposed addition seems a bit weird anyway since it presumes no

[BUGS] BUG #5554: PostgreSQL 8.4.0 doesn't update my table

2010-07-12 Thread jose soares
The following bug has been logged online: Bug reference: 5554 Logged by: jose soares Email address: jose.soa...@sferacarta.com PostgreSQL version: 8.4.0 Operating system: Linux Debian 4.3.3-13 64-bit Description:PostgreSQL 8.4.0 doesn't update my table Details: I a

Re: [BUGS] BUG #5554: PostgreSQL 8.4.0 doesn't update my table

2010-07-12 Thread Tom Lane
"jose soares" writes: > I found a strange behavior in my DB, I have a table which Pg isn't be able > to update. Maybe you've got a rule or trigger on the table that is interfering with the update? If there actually is a bug here, you've not provided nearly enough information for anyone else to d

Re: [BUGS] BUG #5553: Repeating the keyword DECLARE in the CREATE FUNCTION statement

2010-07-12 Thread Tom Lane
"Sergey" writes: > Description:Repeating the keyword DECLARE in the CREATE FUNCTION > statement > Is it a normal behavior of the parser: Yes. This isn't a bug, you've just written a bunch of empty DECLARE sections. regards, tom lane -- Sent via pgsql-bugs mail

Re: [BUGS] BUG #5552: incorrect returned value of time

2010-07-12 Thread Milen A. Radev
На 12.07.2010 г. 10:16, Konstantin Kulikov написа: The following bug has been logged online: Bug reference: 5552 Logged by: Konstantin Kulikov Email address: k.e.kuli...@gmail.com PostgreSQL version: 8.3 Operating system: unix Description:incorrect returned value of

Re: [BUGS] BUG #5552: incorrect returned value of time

2010-07-12 Thread Tom Lane
"Konstantin Kulikov" writes: > Description:incorrect returned value of time > select current_timestamp at time zone 'GMT+3'; > will return actually 'GMT-3' This is unfortunate, but it's not a bug. There are two different standards about the sign of timezone offsets, and Postgres has to

[BUGS] BUG #5555: ALTER TABLE ONLY ... SET NOT NULL on parent prevent prior inherited tables from being restored

2010-07-12 Thread Michael Glaesemann
The following bug has been logged online: Bug reference: Logged by: Michael Glaesemann Email address: g...@seespotcode.net PostgreSQL version: 8.4.4 Operating system: Mac OS X Description:ALTER TABLE ONLY ... SET NOT NULL on parent prevent prior inherited tables

[BUGS] Bad localization in psql (french version) for Windows

2010-07-12 Thread Antonio Rivas Valle
Hi I downloaded PostgreSQL-8.4.4 for Windows (french version) a few days ago. Starting psql, I got a warning related to a possible malfunction because of the page code of the console. Every character with accents was displayed in a wrong way. After trying without success seve

Re: [BUGS] BUG #5555: ALTER TABLE ONLY ... SET NOT NULL on parent prevent prior inherited tables from being restored

2010-07-12 Thread Tom Lane
"Michael Glaesemann" writes: > If you add a column to a parent table with no NOT NULL constraint and then > add the NOT NULL constraint on the parent using ALTER TABLE ONLY (so only > future tables inheriting from the parent have the constraint), the dump file > does not indicate that those childr

Re: [BUGS] Bad localization in psql (french version) for Windows

2010-07-12 Thread Peter Eisentraut
On mån, 2010-07-12 at 19:08 +0200, Antonio Rivas Valle wrote: > Hi > > I downloaded PostgreSQL-8.4.4 for Windows (french version) a few days > ago. Starting psql, I got a warning related to a possible > malfunction because of the page code of the console. Every > character with acc

[BUGS] BUG #5556: "cannot drop active portal" and "ERRORDATA_STACK_SIZE exceeded" lead to server crash

2010-07-12 Thread Robert Walker
The following bug has been logged online: Bug reference: 5556 Logged by: Robert Walker Email address: robwalke...@speedymail.org PostgreSQL version: 9.0 beta3 Operating system: WinXP 32-bit Description:"cannot drop active portal" and "ERRORDATA_STACK_SIZE exceeded" le

Re: [BUGS] BUG #5556: "cannot drop active portal" and "ERRORDATA_STACK_SIZE exceeded" lead to server crash

2010-07-12 Thread Tom Lane
"Robert Walker" writes: > Description:"cannot drop active portal" and "ERRORDATA_STACK_SIZE > exceeded" lead to server crash We're really going to need to see a self-contained example to do much with this. regards, tom lane -- Sent via pgsql-bugs mailing list (p

Re: [BUGS] BUG #5556: "cannot drop active portal" and "ERRORDATA_STACK_SIZE exceeded" lead to server crash

2010-07-12 Thread Craig Ringer
On 13/07/10 05:00, Robert Walker wrote: > The intent of what I was originally trying to do is to intentionally cause a > unique constraint violation for the sake of testing to ensure that I won't > get duplicate data in the final design. But when the unique violation > occurs, a series of other (p

[BUGS] BUG #5557: Problema com Bytea

2010-07-12 Thread Rafael Almeida
The following bug has been logged online: Bug reference: 5557 Logged by: Rafael Almeida Email address: raf...@rafaeldeveloper.com PostgreSQL version: 9.0 Operating system: Windows XP Description:Problema com Bytea Details: Ae amigos, Bom estive testando a nova versã

[BUGS] BUG #5558: Problema com Bytea (BRASIL)

2010-07-12 Thread Rafael Almeida
The following bug has been logged online: Bug reference: 5558 Logged by: Rafael Almeida Email address: raf...@rafaeldeveloper.com PostgreSQL version: 9.0 Operating system: Windows XP Description:Problema com Bytea (BRASIL) Details: Ae friends I am Brazilian, Well I