Re: [BUGS] [PERFORM] pgsql inserts problem

#1

On Wed, Aug 27, 2003 at 15:50:32 +0300,
Tarhon-Onu Victor <mituc (AT) iasi (DOT) rdsnet.ro> wrote:

Quote:

The problems is that only ~15% of the lines are inserted into
the database. The same script modified to insert the same data in a
similar table created in a MySQL database inserts 100%.

Did you check the error status for the records that weren't entered?

My first guess is that you have some bad data you are trying to insert.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

#2

Quote:

The problems is that only ~15% of the lines are inserted into
the database. The same script modified to insert the same data in a
similar table created in a MySQL database inserts 100%.

Did you check the error status for the records that weren't entered?

My first guess is that you have some bad data you are trying to insert.

I wouldn't be surprised, MySQL will just insert a zero instead of failing in
most cases :P

Chris

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] [PERFORM] pgsql inserts problem

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] [PERFORM] pgsql inserts problem - 08-27-2003 , 10:31 PM

Re: [BUGS] [PERFORM] pgsql inserts problem - 08-27-2003 , 11:14 PM