Re: Newbie "Copy From" not working - Mailing list pgsql-general

From Walter Vaughan
Subject Re: Newbie "Copy From" not working
Date
Msg-id 44E4E73D.7080502@steelerubber.com
Whole thread Raw
In response to Re: Newbie "Copy From" not working  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Michael Fuhr wrote:

> On Thu, Aug 17, 2006 at 03:27:26PM -0400, Walter Vaughan wrote:
>>ERROR:  missing data for column "processed_timestamp"

> The table you posted has 42 columns; at least one line in the file
> doesn't have that many fields.

Yes, we didn't have the right number of columns...

We've had only experience with MySQL's tools which are much less picky. :(
We've also discovered that it will also stop on fields that are too wide. I'm
fairly sure that its better for the transaction to fail and tell us that it
would be chopping off data rather than to just go on silently and stripping off
data...

Thanks as well to "terry at esc1.com" for helping.

--
Walter


pgsql-general by date:

Previous
From: gustavo halperin
Date:
Subject: Re: Dynamic Partial Index
Next
From: Stephan Szabo
Date:
Subject: Re: select * from users where user_id NOT in (select