Re: [BUGS] copy problem

2004-02-15 Thread Tom Lane
Garrett Dangerfield <[EMAIL PROTECTED]> writes: > I am trying to load a data file into a table using the copy command. > When I do it on a small subset of the data (gotten using the Linux head command) it > all works fine, but when I run it on the full dataset, I get the following error: > ERROR:

[BUGS] copy problem

2004-02-15 Thread Garrett Dangerfield
Not sure if this is a bug or not, but it seems like one. I am trying to load a data file into a table using the copy command. When I do it on a small subset of the data (gotten using the Linux head command) it all works fine, but when I run it on the full dataset, I get the following error: ERRO

Re: [BUGS] COPY problem with bad dates

2002-12-18 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: > ERROR: copy: line 1, Bad timestamp external representation '11/31/02' > lost synchronization with server, resetting connection This is not a backend crash, this is libpq's standard operating procedure for recovering from an error during COPY. If we h

Re: [BUGS] COPY problem with bad dates

2002-12-18 Thread Bruno Wolff III
On Wed, Dec 18, 2002 at 09:14:18 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > It looks like when a bad date is entered using COPY the backend connection > gets killed. I just tried it with 7.3.1 and get the same error. ---(end of broadcast)

[BUGS] COPY problem with bad dates

2002-12-18 Thread Bruno Wolff III
It looks like when a bad date is entered using COPY the backend connection gets killed. I noticed this when having a problem loading a database with several copies in one transaction. The backend died consistantly at the same point, but not near where the bad dates were. I eventually found the bad