On Tue, Apr 27, 2010 at 11:02 AM, Tom Lane <[email protected]> wrote: > zhong ming wu <[email protected]> writes: > > The closest thing I can find to that in the code is > > cannot convert abstime "invalid" to timestamp
Yes this is the message. There were invalid values in that table at first. Then I deleted such entries and tried the same query and got the same message. The query is four table joins but in order to pin-point the problem I pruned it down to as simple as what I posted originally. In any case I reloaded the data and on this second pass I stopped receiving the error. The reloading scripts were different and I don't know what that did to the reloaded data. Thanks -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
