> >> ERROR: copy: line 3910, Bad timestamp external representation
> >> '2000-01-05 00:00:60.00+08'
> >> Weird because those timestamps were generated by default now().
...
> Is there a work-around to this aside from manually changing the dump file?
> Distribution Version: Linux Mandrake
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> Just a wild guess, but I would imagine
> a corrupt (old) index on the userid field would
> cause this kind of behavior.
A corrupt index might be a contributing factor, but it doesn't seem like
it could be the only one. From what I know of the in
Just a wild guess, but I would imagine
a corrupt (old) index on the userid field would
cause this kind of behavior.
You could test this by dropping the index and
then rebuilding it.
Troy
>
> "pgsql-sql" <[EMAIL PROTECTED]> writes:
> > migrate=# select userid from users where userid = '[EMAI
"pgsql-sql" <[EMAIL PROTECTED]> writes:
> migrate=# select userid from users where userid = '[EMAIL PROTECTED]';
>userid
> -
> [EMAIL PROTECTED]
> admin
> (2 rows)
That's a tad, um, startling :-(
However, you haven't given us nearly enough information to have a shot