Thread

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

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2004-11-16T10:38:29Z

   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
   
   
   
   
   
   
   
   
   

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

   Tom Lane <tgl@sss.pgh.pa.us> — 2004-11-16T15:18:08Z

   "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