Re: invalid abstime to timestamp error only on specific date range - Mailing list pgsql-general

From Tom Lane
Subject Re: invalid abstime to timestamp error only on specific date range
Date
Msg-id 14343.1272380536@sss.pgh.pa.us
Whole thread Raw
In response to invalid abstime to timestamp error only on specific date range  (zhong ming wu <mr.z.m.wu@gmail.com>)
Responses Re: invalid abstime to timestamp error only on specific date range  (zhong ming wu <mr.z.m.wu@gmail.com>)
List pgsql-general
zhong ming wu <mr.z.m.wu@gmail.com> writes:
> I have a postgres table with a column type abstime.  (all data in this
> database are loaded from an ancient propriety database)

> When I filter data from this table with a specific date range on this
> column it works.  When I filter with a different date range
> it gives me an error like

> invalid abstime to timestamp

> I don't have that server at this moment and I cannot post exact error.

The closest thing I can find to that in the code is

    cannot convert abstime "invalid" to timestamp

The abstime type does have a special reserved value "invalid", while
timestamp doesn't so that value can't be converted to timestamp.

I'm guessing that you have an "invalid" or two lurking in the table
somewhere, but it's hard to be specific with so few details.  You've not
shown us enough information to tell why your query would be trying to
convert any abstime values to timestamp --- let alone that particular
one.

            regards, tom lane

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: [ANNOUNCE] Live CD based on CentOS 5.4 and PG 8.4.3 released
Next
From: Greg Smith
Date:
Subject: Re: PostgreSQL Performance issue