Search Postgresql Archives

Re: Newbie "Copy From" not working

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux