Re: Newbie "Copy From" not working

Поиск
Список
Период
Сортировка
От Walter Vaughan
Тема Re: Newbie "Copy From" not working
Дата
Msg-id 44E4E73D.7080502@steelerubber.com
обсуждение исходный текст
Ответ на Re: Newbie "Copy From" not working  (Michael Fuhr <mike@fuhr.org>)
Список 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 по дате отправления:

Предыдущее
От: gustavo halperin
Дата:
Сообщение: Re: Dynamic Partial Index
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: select * from users where user_id NOT in (select