Re: [BUGS] BUG #4479: Incorrect TSearch2 results when inserting after deleting

2008-10-21 Thread Tom Lane
"Dan Fabulich" <[EMAIL PROTECTED]> writes: > Description:Incorrect TSearch2 results when inserting after deleting > EXPECTED: The last two SELECT statements should return the same results (1 > row) > ACTUAL: The final SELECT statement returns 0 results. The SELECT statement > just before

Re: [BUGS] BUG #4488: jdbc : DatabaseMetaData.getPrimaryKeys no result

2008-10-21 Thread Kris Jurka
On Tue, 21 Oct 2008, Marcel Petavy wrote: Bug reference: 4488 PostgreSQL version: 8.2.4 Operating system: Windows XP Description:jdbc : DatabaseMetaData.getPrimaryKeys no result Details: If I try to query the primary key via JDBC driver "postgresql-8.3-603.jdbc4.jar" DatabaseMe

Re: [BUGS] BUG #4481: Big text insert/update using functions failed

2008-10-21 Thread Tom Lane
"Julien Vadnais" <[EMAIL PROTECTED]> writes: > When trying to insert/update long text string into the DB using a pgsql > function, an error occures. (If ~6000 char or more) People do that every day without problems. It sounds to me like you need to take this up with the authors of PDO (whatever t

Re: [BUGS] BUG #4478: = operator in connection with CASE looks like loose some functionality (bug or feature?)

2008-10-21 Thread Tom Lane
"Robert 'BoBsoN' Partyka" <[EMAIL PROTECTED]> writes: > In construction "... ind = case ..." automagic conversion from text to > integer is not done anymore in 8.3.* - you must cast it manually. > Is this bug or feature? (for me it looks like bug). It's intentional. > If this is feature then I t

Re: [BUGS] BUG #4482: Segfault error 4

2008-10-21 Thread Joshua Tolley
On Thu, Oct 16, 2008 at 10:33 AM, manish singh <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 4482 > Logged by: manish singh > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3 > Operating system: Centos 64bit > Description:

[BUGS] BUG #4488: jdbc : DatabaseMetaData.getPrimaryKeys no result

2008-10-21 Thread Marcel Petavy
The following bug has been logged online: Bug reference: 4488 Logged by: Marcel Petavy Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Windows XP Description:jdbc : DatabaseMetaData.getPrimaryKeys no result Details: Hi. If I try to quer

[BUGS] Upgrade from 7.4.5 to 8.3.3

2008-10-21 Thread Harvey, Allan AC
During an upgrade from 7.4.5 to 8.3.3 the following was dumped during the restore process from psql. psql:roperydb_v7.4_20081021.dmp:49: WARNING: could not determine encoding for locale "C_C.C": codeset is "" DETAIL: Please report this to . So I am reporting it. Back ground. I am using 8.3.3

[BUGS] BUG #4482: Segfault error 4

2008-10-21 Thread manish singh
The following bug has been logged online: Bug reference: 4482 Logged by: manish singh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: Centos 64bit Description:Segfault error 4 Details: Database Postgressql 8.3.3 is on clustering and replic

[BUGS] BUG #4478: = operator in connection with CASE looks like loose some functionality (bug or feature?)

2008-10-21 Thread Robert 'BoBsoN' Partyka
The following bug has been logged online: Bug reference: 4478 Logged by: Robert 'BoBsoN' Partyka Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: OpenSuSE Linux Description:= operator in connection with CASE looks like loose some functional

[BUGS] BUG #4481: Big text insert/update using functions failed

2008-10-21 Thread Julien Vadnais
The following bug has been logged online: Bug reference: 4481 Logged by: Julien Vadnais Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Ubuntu Linux 7.04, Kernel 2.6.20-15-server Description:Big text insert/update using functions failed De

[BUGS] BUG #4479: Incorrect TSearch2 results when inserting after deleting

2008-10-21 Thread Dan Fabulich
The following bug has been logged online: Bug reference: 4479 Logged by: Dan Fabulich Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: OS X 10.5.5 Description:Incorrect TSearch2 results when inserting after deleting Details: Run the follo