On Tue, Apr 27, 2010 at 11:02 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > zhong ming wu <mr.z.m.wu@xxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
