Re: [BUGS] BUG #4632: Duplicate

2009-01-27 Thread Euler Taveira de Oliveira
Juan Moreno escreveu: > I have a problem for certain tables. When mysql executes pg_query(), then it > duplicates the insertion, or sometimes 3,4 times. But it is not a constant > issue and with all the tables > Witout a test case, it is hard to say something about it. It could be a trigger functi

Re: [BUGS] pg_listener entries deleted under heavy NOTIFY load only on Windows

2009-01-27 Thread Marshall, Steve
As I posted before, changing the timeout from 1000 to NMPWAIT_WAIT_FOREVER fixed the problem, or at least moved it such it does not occur easily anymore. To better understand the problem, I added debugging as Tom suggested. I restored timeout on CalledNamedPipe 1000 ms, and reran my tests. Indeed

Re: [BUGS] BUG #4633: Bug in PL/PgSQL "SELECT .. INTO" statement parser

2009-01-27 Thread Tom Lane
"Oleg" writes: > DECLARE > row_test1 test1%rowtype; > row_test2 test2%rowtype; > BEGIN > SELECT test1, test2 > FROM test1 JOIN test2 ON(chunk.id = test2.chunk_id) > LIMIT 1 > INTO row_test1, row_test2; Can't do that. The INTO target can be either a row variable

[BUGS] BUG #4633: Bug in PL/PgSQL "SELECT .. INTO" statement parser

2009-01-27 Thread Oleg
The following bug has been logged online: Bug reference: 4633 Logged by: Oleg Email address: sero...@gmail.com PostgreSQL version: PostgreSQL 8.3 Operating system: CentOS Description:Bug in PL/PgSQL "SELECT .. INTO" statement parser Details: Here is an example: CRE

Re: [BUGS] BUG #4631: Hibernate Restriction bigint~~bigint

2009-01-27 Thread Guillaume Smet
On Tue, Jan 27, 2009 at 4:20 PM, Hauke Runge wrote: > this was working very well. Changing to postgreSql 8.3 we got the following > error: > ERROR: operator does not exist: bigint ~~ bigint > > we changed the jdbc driver to the latest jdbc3 driver - but the error was > the same. > > > I think, thi

[BUGS] BUG #4632: Duplicate

2009-01-27 Thread Juan Moreno
The following bug has been logged online: Bug reference: 4632 Logged by: Juan Moreno Email address: j...@petlifestyleonline.com PostgreSQL version: 7.4.19 Operating system: Debian 4 Description:Duplicate Details: I have a problem for certain tables. When mysql execu

Re: [BUGS] BUG #4631: Hibernate Restriction bigint~~bigint

2009-01-27 Thread Tom Lane
"Hauke Runge" writes: > ERROR: operator does not exist: bigint ~~ bigint > I think, this could be a bug. Yes: in Hibernate. They shouldn't be using LIKE on integers. If it happens that that's intentional and not a symptom of a logic error on their part, they need to cast the integers to text ex

[BUGS] BUG #4631: Hibernate Restriction bigint~~bigint

2009-01-27 Thread Hauke Runge
The following bug has been logged online: Bug reference: 4631 Logged by: Hauke Runge Email address: ru...@tembit.de PostgreSQL version: 8.3 Operating system: XP professional Description:Hibernate Restriction bigint~~bigint Details: Developing a project with spring,

[BUGS] BUG #4630: Null-pointer dereference on FreeBSD / PowerPC in PageIsPrunable ()

2009-01-27 Thread Nick Withers
The following bug has been logged online: Bug reference: 4630 Logged by: Nick Withers Email address: n...@nickwithers.com PostgreSQL version: 8.3.5 Operating system: FreeBSD 7-STABLE Description:Null-pointer dereference on FreeBSD / PowerPC in PageIsPrunable () Detail