Thread: Q: pgaccess + restoring a table from a previous txt export

Hi,

In my database, I have exported a few tables which
contain test data to text files, delimited with some #

Now my tables are empty and I would like to restore
the content of the table using "Import" in the DATABASE
menu of pgaccess, and I have the following error:

Bad timestamp external representation
'2001-06-01 00:00:00.00+002'

Note that this value was inserted in the table using now().
The format must therefore be correct I guess....

Any idea of the problem and how to fix it ?

Regards,

Eric Chopin
echopin@sqli.com

"Eric Chopin" <chopin@cari.fr> writes:

> Now my tables are empty and I would like to restore
> the content of the table using "Import" in the DATABASE
> menu of pgaccess, and I have the following error:
>
> Bad timestamp external representation
> '2001-06-01 00:00:00.00+002'

What version of Postgres is this?  There was at least one timestamp
parsing bug that was fixed in the 7.1 beta cycle.  Does 7.1.2 work?

-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time...          --Dylan