unsupported types in 8.0.1
| От | Ben |
|---|---|
| Тема | unsupported types in 8.0.1 |
| Дата | |
| Msg-id | 73ffdcf251e5cd3dd258a9f1c5148b2b@silentmedia.com обсуждение исходный текст |
| Ответы |
Re: unsupported types in 8.0.1
|
| Список | 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?
В списке pgsql-general по дате отправления: