unsupported types in 8.0.1

From: Ben <bench(at)silentmedia(dot)com>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: unsupported types in 8.0.1
Date: 2005-03-26 16:25:24
Message-ID: 73ffdcf251e5cd3dd258a9f1c5148b2b@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm attempting to upgrade to 8.0.1, and have hit my latest hurdle: an
unsupported type when I try to compare ints. Example:

gr-test=> \d invitecodes
Table "public.invitecodes"
Column | Type | Modifiers
------------+---------
+-----------------------------------------------------------------
invite | integer | not null default
nextval('public.invitecodes_invite_seq'::text)
sponsor | bigint | not null
generated | integer | not null default ((now())::abstime)::integer
expires | integer | not null
acceptedby | bigint |
acceptedon | integer |
expiredon | integer |

gr-test=> select expires from invitecodes;
expires
------------
1111611373
1111551093
1112139900
1112169368
(4 rows)

gr-test=> select expires from invitecodes where expires <
((now())::abstime)::int4;
ERROR: unsupported type: 23

gr-test=> select expires from invitecodes where expires > 1;
expires
------------
1111611373
1111551093
1112139900
1112169368
(4 rows)

gr-test=> select expires from invitecodes where 1 <
((now())::abstime)::int4;
expires
------------
1111611373
1111551093
1112139900
1112169368
(4 rows)

I haven't a clue how to go about debugging this. Any pointers?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-03-26 17:24:07 Re: unsupported types in 8.0.1
Previous Message John DeSoi 2005-03-26 13:12:14 Re: help w/ a little naive brainstorming ...