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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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