BUG #1322: Bug while Insert into TempResult Select cols ..... statement
PostgreSQL Bugs List
The following bug has been logged online:
Bug reference: 1322
Logged by: Bahadur Singh
Email address: bahadu...@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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Tom Lane
> Description: Bug while Insert into TempResult Select cols .....
> statement
It is not possible to investigate this report based on the small amount of
information you provided. Give us a test case, or at least something
that would give someone else a chance to reproduce what you saw.
(No, I don't believe that inserting 500K rows is in and of itself buggy.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings