Re: copy losing information - Mailing list pgsql-general

From Tom Lane
Subject Re: copy losing information
Date
Msg-id 12925.1154037857@sss.pgh.pa.us
Whole thread Raw
In response to Re: copy losing information  ("Silvela, Jaime \(Exchange\)" <JSilvela@Bear.com>)
List pgsql-general
"Silvela, Jaime \(Exchange\)" <JSilvela@bear.com> writes:
> Tom, how and why would INSERTs be dropped on the client side?

[ shrug... ] I don't know your code; I was thinking about garden variety
bugs in your ruby script.  However, if you can make it happen just
through psql \copy then that theory seems to lose its luster :-(

Something else that might be worth looking at: have you got any
user-written BEFORE INSERT triggers on that table?  A trigger that
sometimes returned NULL would explain the symptoms.

            regards, tom lane

pgsql-general by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: automatic and randomally population
Next
From: Ian Johnson
Date:
Subject: Re: Can't start PostgreSQL