| From: | Walter Vaughan <wvaughan(at)steelerubber(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Newbie "Copy From" not working |
| Date: | 2006-08-17 22:01:33 |
| Message-ID: | 44E4E73D.7080502@steelerubber.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2006-08-17 22:36:33 | Re: select * from users where user_id NOT in (select |
| Previous Message | gustavo halperin | 2006-08-17 21:19:16 | Re: Dynamic Partial Index |