The following bug has been logged online:

Bug reference: 1322
Logged by: Bahadur Singh

Email address: bahadursingh (AT) yahoo (DOT) com

PostgreSQL version: 8.0 Beta

Operating system: Windows 2000 server

Description: Bug while Insert into TempResult Select cols .....
statement

Details:

PostgreSQL Version : PostgreSQL 8.0.0 Beta 4
OS : Windows Server 2000


I found a bug on Beta 4 release for Windows 2000 when inserting a large
amount of data from Select statement using pgdev-306-JDBC2 driver.

The Select returns 480,384 rows if executed on pgAdmin III SQL tool.

SQL :
INSERT INTO TEMPRESULT Select cols ...... with some consitions

When I call

stmt.execute()
it inserts onyl 192 rows to result table.

More problematic ??

on calling
int n = stmt.executeUpdate ()
it inserts 480,384 rows but returns 239,199 as value of n.

Less problematic: Rows in DB are correct.

It is working well, if result amount is less (less means about 10,000).


Best Wishes
Bahadur








---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster