Skip site navigation (1) Skip section navigation (2)

Problems when inserting a very large sequence of records

From: "Marcelo \(AdSolutions\)" <marcelo(at)adsolutions(dot)com(dot)br>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Problems when inserting a very large sequence of records
Date: 2001-10-26 18:34:12
Message-ID: 003001c15e4c$db79c2c0$0c02a8c0@adsolutions.com.br (view raw or flat)
Thread:
Lists: pgsql-bugs
I am experiencing a problem when I was inserting a lot of records to one
table.

At the end of process (I was insering about 15,000 lines) after the COMMIT
statement some
records were not stored.  No error messages, no warnings.  If  I decrease
the number of inserted lines to 1,500 they are stored.

Do you know what is happening ?

Note: I am using RedHat Lynux, Postgresql version 7.3 on a Windows Me client
machine with odbc version 7.0.7.  I connect to postgresql using ODBC API
fuctions.


Thanks.

Marcelo. ( São Paulo, Brazil).



Responses

pgsql-bugs by date

Next:From: Rumi SzabolcsDate: 2001-10-27 06:08:13
Subject: reference to inherited column in parent
Previous:From: Andy HallamDate: 2001-10-26 15:38:05
Subject: Select with backslash '\' character

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group