Tickets :: Comment on [#8700] type cast needed for event

* Your Email Address
* Spam protection	Enter the letters below: .__.. .. .._..___ \| \|\|__\|\ / \| [__ \|__\\| \| \/ _\|_\|
Comment	> 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
Attachment
Watch this ticket

Saved Queries