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  (Michael Fuhr <mike@fuhr.org>)
Список 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 по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: help w/ a little naive brainstorming ...
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: unsupported types in 8.0.1