[Tickets #8700] Re: type cast needed for event_recurtype for postgresql-8.3.8

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/8700
------------------------------------------------------------------------------
  Ticket             | 8700
  Updated By         | michael.menge at zdv.uni-tuebingen.de
  Summary            | type cast needed for event_recurtype for
                     | postgresql-8.3.8
  Queue              | Kronolith
  Version            | 2.3.2
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Jan Schneider
------------------------------------------------------------------------------


michael.menge at zdv.uni-tuebingen.de (2009-11-12 07:41) wrote:

Here is the Table defenition,

                   Tabelle »public.kronolith_events«
        Spalte        |             Typ             |     Attribute
---------------------+-----------------------------+--------------------
  event_id            | character varying(32)       | not null
  event_uid           | character varying(255)      | not null
  calendar_id         | character varying(255)      | not null
  event_creator_id    | character varying(255)      | not null
  event_description   | text                        |
  event_location      | text                        |
  event_status        | integer                     | default 0
  event_attendees     | text                        |
  event_keywords      | text                        |
  event_exceptions    | text                        |
  event_title         | character varying(255)      |
  event_category      | character varying(80)       |
  event_recurtype     | character varying(11)       | default 0
  event_recurinterval | character varying(11)       |
  event_recurdays     | character varying(11)       |
  event_recurenddate  | timestamp without time zone |
  event_start         | timestamp without time zone |
  event_end           | timestamp without time zone |
  event_alarm         | integer                     | default 0
  event_modified      | integer                     | not null
  event_private       | integer                     | not null default 0
  event_recurcount    | integer                     |
Indexe:
     »kronolith_events_pkey« PRIMARY KEY, btree (event_id)
     »kronolith_calendar_idx« btree (calendar_id)
     »kronolith_uid_idx« btree (event_uid)


an Alter Table to change the type of event_recurtype to integer failed

alter table kronolith_events alter column event_recurtype type integer ;
ERROR:  column "event_recurtype" cannot be cast to type "pg_catalog.int4"

Tracking this down showed that the type was changed
http://cvs.horde.org/h/chora/diff.php/kronolith/scripts/sql/kronolith.pgsql.sql?r1=1.5&r2=1.6

There is a upgrade script to fix this for mysql but not for postgres