Re: [BUGS] Bug in ALTER LANGUAGE ... RENAME TO ...;

2005-02-13 Thread Tom Lane
> "Sergey N. Yatskevich" <[EMAIL PROTECTED]> writes: >> RenameLanguage procedure in src/backend/commands/proclang.c open >> and update pg_catalog.pg_shadow table instead pg_catalog.pg_language. > Wow. Apparently this has been broken since it was written, and > nobody ever tested it. Thanks! BTW

Re: [BUGS] PreparedStatement setObject

2005-02-13 Thread Oliver Jowett
Kobus Walters wrote: Create a prepared statement with sql "select localtimestamp - time ?". Call setObject(1, java.lang.String) with the String value "00:00:00" for instance. In version 7 this gets executed as "select localtimestamp - time '00:00:00'", while version 8 try to execute it as "select l

Re: [BUGS] Bug in ALTER LANGUAGE ... RENAME TO ...;

2005-02-13 Thread Tom Lane
"Sergey N. Yatskevich" <[EMAIL PROTECTED]> writes: > RenameLanguage procedure in src/backend/commands/proclang.c open > and update pg_catalog.pg_shadow table instead pg_catalog.pg_language. Wow. Apparently this has been broken since it was written, and nobody ever tested it. Thanks!

Re: [BUGS] Bug in ALTER LANGUAGE ... RENAME TO ...;

2005-02-13 Thread Bruce Momjian
Oh, good catch. We will fix that. Thanks. Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. ---

Re: [BUGS] BUG #1479: minor sintax

2005-02-13 Thread Bruce Momjian
srdjan wrote: > > The following bug has been logged online: > > Bug reference: 1479 > Logged by: srdjan > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.1 > Operating system: Linux hostname 2.4.18-3 #1 Thu Apr 18 07:31:07 EDT 2002 > i586 unknown > Description:

[BUGS] BUG #1479: minor sintax

2005-02-13 Thread srdjan
The following bug has been logged online: Bug reference: 1479 Logged by: srdjan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Linux hostname 2.4.18-3 #1 Thu Apr 18 07:31:07 EDT 2002 i586 unknown Description:minor sintax Details: in fil

[BUGS] BUG #1478: Upper function does not work

2005-02-13 Thread Tiago Magalhães Vieira
The following bug has been logged online: Bug reference: 1478 Logged by: Tiago Magalhães Vieira Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0-rc5 Operating system: Windows XP Description:Upper function does not work Details: I have been experiencing som

[BUGS] Bug in ALTER LANGUAGE ... RENAME TO ...;

2005-02-13 Thread Sergey N. Yatskevich
RenameLanguage procedure in src/backend/commands/proclang.c open and update pg_catalog.pg_shadow table instead pg_catalog.pg_language. -- Sergey N. Yatskevich <[EMAIL PROTECTED]> diff -Naur postgresql-8.0.0/src/backend/commands/proclang.c postgresql-8.0.0.new/src/backend/commands/proclang.c --- p

[BUGS] PreparedStatement setObject

2005-02-13 Thread Kobus Walters
Setting java.lang.String values with the setObject method in version 8 of the pgsql-jdbc driver (postgresql-8.0-310.jdbc3.jar) does not work as with version 7 (pg74.215.jdbc3.jar) of the driver. Example: Create a prepared statement with sql "select localtimestamp - time ?". Call setObject(1, ja

[BUGS] BUG #1477: DROP TABLE does not recover

2005-02-13 Thread Marcel Claus
The following bug has been logged online: Bug reference: 1477 Logged by: Marcel Claus Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows 2003 Server / Windows XP Description:DROP TABLE does not recover Details: Hi, I have found the f