Thread: BUG #1322: Bug while Insert into TempResult Select cols ..... statement

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

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> 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