The following bug has been logged online:
Bug reference: 1322
Logged by: Bahadur Singh
Email address: bahadursingh@yahoo.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