Can't copy empty value to datatype 'timestamp'

Поиск
Список
Период
Сортировка
От Jon Thorson
Тема Can't copy empty value to datatype 'timestamp'
Дата
Msg-id 1042095057.12492.25.camel@ulysses.darkgeek.com
обсуждение исходный текст
Ответы Re: Can't copy empty value to datatype 'timestamp'  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Re: Can't copy empty value to datatype 'timestamp'  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
I'm running into a problem importing data into my database.  What seems
to be the issue is an empty value on a field defined as 'timestamp'.  In
psql I'm using the following command to import the data:

  copy devicem1 from '/data/tmp/scshadow/devicem1.out' delimiter '|';

I get the following error:

  ERROR:  copy: line 1, Bad timestamp external representation ''

There are 109 fields in this table, four fields with the datatype of
'timestamp'.  The data that I am trying to import has the first two of
the timestamp fields populated, and the last two are for future use.
The definition for each timestamp field is simply:

  "<field name>" timestamp,

I've tried specifically allowing null values to the fields, but I still
get the same error.  I would include a sample row but it's rather long
and it would get mangled with the word wrap of my email client.  Suffice
it to say that the data is pipe delimited and the fields that are empty
look like "||" (minus the double quotes, of course).

The verison of psql is:

  PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC 2.95.3

Any help is greatly appreciated.

Thanks.

-j



В списке pgsql-general по дате отправления:

Предыдущее
От: "Magnus Naeslund(f)"
Дата:
Сообщение: Re: PostgreSQL + Visual Basic .NET
Следующее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: Can't copy empty value to datatype 'timestamp'