Re: [SQL] 7.0.3 BUG

2000-11-30 Thread Thomas Lockhart
> >> 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

Re: [SQL] 7.0.3 BUG

2000-11-24 Thread Tom Lane
"[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

Re: [SQL] 7.0.3 BUG

2000-11-24 Thread [EMAIL PROTECTED]
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

Re: [SQL] 7.0.3 BUG

2000-11-24 Thread Tom Lane
"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