Plenty of ERRORS during "update-davical-database"
After a fresh install I receive this in /var/log/messages. After some research it occurs to me, that this happens because "IF EXISTS" SQL statements are not being used in patches like
views/dav_principal.sql
rrule_functions.sql
[...] etc.
Blind "DROPPING" causes this ugly and very confusing output:
postgres[78253]: [3-1] ERROR: view "dav_principal" does not exist
postgres[78253]: [3-2] STATEMENT: DROP VIEW dav_principal CASCADE;
postgres[78272]: [3-1] ERROR: function rename_davical_user(text, text) does not exist
postgres[78272]: [3-2] STATEMENT: DROP FUNCTION rename_davical_user( TEXT, TEXT );
postgres[78272]: [4-1] ERROR: trigger "usr_modified" for table "usr" does not exist
postgres[78272]: [4-2] STATEMENT: DROP TRIGGER usr_modified ON usr CASCADE;
postgres[78272]: [5-1] ERROR: trigger "collection_modified" for table "collection" does not exist
postgres[78272]: [5-2] STATEMENT: DROP TRIGGER collection_modified ON collection CASCADE;
postgres[78272]: [6-1] ERROR: trigger "caldav_data_modified" for table "caldav_data" does not exist
postgres[78272]: [6-2] STATEMENT: DROP TRIGGER caldav_data_modified ON caldav_data CASCADE;
postgres[78272]: [7-1] ERROR: trigger "calendar_item_sync_dav_id" for table "calendar_item" does not exist
postgres[78272]: [7-2] STATEMENT: DROP TRIGGER calendar_item_sync_dav_id ON calendar_item CASCADE;
postgres[78272]: [8-1] ERROR: trigger "principal_modified" for table "principal" does not exist
postgres[78272]: [8-2] STATEMENT: DROP TRIGGER principal_modified ON principal CASCADE;
postgres[78272]: [9-1] ERROR: trigger "grants_modified" for table "grants" does not exist
postgres[78272]: [9-2] STATEMENT: DROP TRIGGER grants_modified ON grants CASCADE;
postgres[78272]: [10-1] ERROR: trigger "alarm_changed" for table "calendar_alarm" does not exist
postgres[78272]: [10-2] STATEMENT: DROP TRIGGER alarm_changed ON calendar_alarm CASCADE;
postgres[78301]: [3-1] ERROR: type "rrule_parts" does not exist
postgres[78301]: [3-2] STATEMENT: /**
postgres[78301]: [3-3] * PostgreSQL Functions for RRULE handling
postgres[78301]: [3-4] *
postgres[78301]: [3-5] * @package rscds
postgres[78301]: [3-6] * @subpackage database
postgres[78301]: [3-7] * @author Andrew McMillan andrew@morphoss.com
postgres[78301]: [3-8] * @copyright Morphoss Ltd - http://www.morphoss.com/
postgres[78301]: [3-9] * @license http://gnu.org/copyleft/gpl.html GNU GPL v2 or later
postgres[78301]: [3-10] *
postgres[78301]: [3-11] * Coverage of this function set
postgres[78301]: [3-12] * - COUNT & UNTIL are handled, generally
postgres[78301]: [3-13] * - DAILY frequency, including BYDAY, BYMONTH, BYMONTHDAY, BYWEEKNO, BYMONTHDAY
postgres[78301]: [3-14] * - WEEKLY frequency, including BYDAY, BYMONTH, BYMONTHDAY, BYWEEKNO, BYSETPOS
postgres[78301]: [3-15] * - MONTHLY frequency, including BYDAY, BYMONTH, BYSETPOS
postgres[78301]: [3-16] * - YEARLY frequency, including BYMONTH, BYMONTHDAY, BYSETPOS, BYDAY
postgres[78301]: [3-17] *
postgres[78301]: [3-18] * Not covered as yet
postgres[78301]: [3-19] * - DAILY: BYYEARDAY, BYSETPOS*
postgres[78301]: [3-20] * - WEEKLY: BYYEARDAY
postgres[78301]: [3-21] * - MONTHLY: BYYEARDAY, BYMONTHDAY, BYWEEKNO
postgres[78301]: [3-22] * - YEARLY: BYYEARDAY
postgres[78301]: [3-23] * - SECONDLY
postgres[78301]: [3-24] * - MINUTELY
postgres[78301]: [3-25] * - HOURLY
postgres[78301]: [3-26] *
postgres[78301]: [3-27] */
postgres[78301]: [3-28]
postgres[78301]: [3-29] DROP TYPE rrule_parts CASCADE;
postgres[78301]: [4-1] ERROR: type "rrule_instance" does not exist
postgres[78301]: [4-2] STATEMENT: DROP TYPE rrule_instance CASCADE;