[Tickets #6759] Automatic table creation fails on postgresql

Mon May 26 15:47:48 UTC 2008

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

Ticket URL: http://bugs.horde.org/ticket/6759
-----------------------------------------------------------------------
 Ticket             | 6759
 Created By         | chris at vandenberghe.org
 Summary            | Automatic table creation fails on postgresql
 Queue              | Horde Groupware Webmail Edition
 Version            | 1.1
 Type               | Bug
 State              | Unconfirmed
 Priority           | 1. Low
 Milestone          |
 Patch              |
 Owners             |
-----------------------------------------------------------------------

chris at vandenberghe.org (2008-05-26 11:47) wrote:

Hi,

Automatic table creation fails with Horde Groupware Webmail edition 1.1 on
Postgres 8.3.  Permissions etc are set correctly.  User is horde11, db is
ouaga, default schema for user horde11 is horde11 (who is also the owner of
this schema).

The postgres logs are:

2008-05-26 16:15:16 CEST ouaga horde11 LOG:  statement: SET SESSION
DATESTYLE = 'ISO'
2008-05-26 16:15:16 CEST ouaga horde11 LOG:  statement: BEGIN
2008-05-26 16:15:16 CEST ouaga horde11 LOG:  statement: SELECT c.relname
AS "Name" FROM pg_class c, pg_user u WHERE c.relowner = u.usesysid AND
c.relkind = 'r' AND NOT EXISTS (SELECT 1 FROM pg_views  WHERE viewname =
c.relname) AND c.relname !~ '^(pg_|sql_)' UNION SELECT c.relname AS "Name"
FROM pg_class c WHERE c.relkind = 'r' AND NOT EXISTS (SELECT 1 FROM
pg_views  WHERE viewname = c.relname) AND NOT EXISTS (SELECT 1 FROM pg_user
 WHERE usesysid = c.relowner) AND c.relname !~ '^pg_'
2008-05-26 16:15:16 CEST ouaga horde11 LOG:  statement: CREATE  TABLE
horde_alarms (alarm_id VARCHAR(255) DEFAULT ' ' NOT NULL, alarm_uid
VARCHAR(255) DEFAULT NULL, alarm_start TIMESTAMP without time zone DEFAULT
'1970-01-01 00:00:00' NOT NULL, alarm_end TIMESTAMP without time zone
DEFAULT '1970-01-01 00:00:00', alarm_methods VARCHAR(255) DEFAULT NULL,
alarm_params TEXT, alarm_title VARCHAR(255) DEFAULT ' ' NOT NULL,
alarm_text TEXT, alarm_snooze TIMESTAMP without time zone DEFAULT
'1970-01-01 00:00:00', alarm_dismissed SMALLINT DEFAULT 0 NOT NULL,
alarm_internal TEXT)
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: SELECT relname
FROM pg_class WHERE oid IN (SELECT indexrelid FROM pg_index, pg_class WHERE
pg_class.relname='horde_alarms' AND pg_class.oid=pg_index.indrelid AND
indisunique != 't' AND indisprimary != 't')
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: CREATE INDEX
alarm_id_idx_idx ON horde_alarms (alarm_id)
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: SELECT relname
FROM pg_class WHERE oid IN (SELECT indexrelid FROM pg_index, pg_class WHERE
pg_class.relname='horde_alarms' AND pg_class.oid=pg_index.indrelid AND
indisunique != 't' AND indisprimary != 't')
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: CREATE INDEX
alarm_user_idx_idx ON horde_alarms (alarm_uid)
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: SELECT relname
FROM pg_class WHERE oid IN (SELECT indexrelid FROM pg_index, pg_class WHERE
pg_class.relname='horde_alarms' AND pg_class.oid=pg_index.indrelid AND
indisunique != 't' AND indisprimary != 't')
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: CREATE INDEX
alarm_start_idx_idx ON horde_alarms (alarm_start)
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: SELECT relname
FROM pg_class WHERE oid IN (SELECT indexrelid FROM pg_index, pg_class WHERE
pg_class.relname='horde_alarms' AND pg_class.oid=pg_index.indrelid AND
indisunique != 't' AND indisprimary != 't')
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: CREATE INDEX
alarm_end_idx_idx ON horde_alarms (alarm_end)
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: SELECT relname
FROM pg_class WHERE oid IN (SELECT indexrelid FROM pg_index, pg_class WHERE
pg_class.relname='horde_alarms' AND pg_class.oid=pg_index.indrelid AND
indisunique != 't' AND indisprimary != 't')
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: CREATE INDEX
alarm_snooze_idx_idx ON horde_alarms (alarm_snooze)
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: SELECT relname
FROM pg_class WHERE oid IN (SELECT indexrelid FROM pg_index, pg_class WHERE
pg_class.relname='horde_alarms' AND pg_class.oid=pg_index.indrelid AND
indisunique != 't' AND indisprimary != 't')
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: CREATE INDEX
alarm_dismissed_idx_idx ON horde_alarms (alarm_dismissed)
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: SELECT c.relname
AS "Name" FROM pg_class c, pg_user u WHERE c.relowner = u.usesysid AND
c.relkind = 'r' AND NOT EXISTS (SELECT 1 FROM pg_views  WHERE viewname =
c.relname) AND c.relname !~ '^(pg_|sql_)' UNION SELECT c.relname AS "Name"
FROM pg_class c WHERE c.relkind = 'r' AND NOT EXISTS (SELECT 1 FROM
pg_views  WHERE viewname = c.relname) AND NOT EXISTS (SELECT 1 FROM pg_user
 WHERE usesysid = c.relowner) AND c.relname !~ '^pg_'
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: CREATE  TABLE
horde_cache (cache_id VARCHAR(32) DEFAULT ' ' NOT NULL, cache_timestamp INT
DEFAULT 0 NOT NULL, cache_expiration INT DEFAULT 0 NOT NULL, cache_data
BYTEA)
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: SELECT c.relname
AS "Name" FROM pg_class c, pg_user u WHERE c.relowner = u.usesysid AND
c.relkind = 'r' AND NOT EXISTS (SELECT 1 FROM pg_views  WHERE viewname =
c.relname) AND c.relname !~ '^(pg_|sql_)' UNION SELECT c.relname AS "Name"
FROM pg_class c WHERE c.relkind = 'r' AND NOT EXISTS (SELECT 1 FROM
pg_views  WHERE viewname = c.relname) AND NOT EXISTS (SELECT 1 FROM pg_user
 WHERE usesysid = c.relowner) AND c.relname !~ '^pg_'
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: SELECT relname
FROM pg_class WHERE oid IN (SELECT indexrelid FROM pg_index, pg_class WHERE
pg_class.relname='horde_datatree' AND pg_class.oid=pg_index.indrelid AND
indisunique != 't' AND indisprimary != 't')
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: SELECT relname
FROM pg_class WHERE oid IN (SELECT indexrelid FROM pg_index, pg_class WHERE
pg_class.relname='horde_datatree' AND pg_class.oid=pg_index.indrelid AND
indisunique != 't' AND indisprimary != 't')
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: SELECT relname
FROM pg_class WHERE oid IN (SELECT indexrelid FROM pg_index, pg_class WHERE
pg_class.relname='horde_datatree' AND pg_class.oid=pg_index.indrelid AND
indisunique != 't' AND indisprimary != 't')
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: SELECT relname
FROM pg_class WHERE oid IN (SELECT indexrelid FROM pg_index, pg_class WHERE
pg_class.relname='horde_datatree' AND pg_class.oid=pg_index.indrelid AND
indisunique != 't' AND indisprimary != 't')
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: SELECT relname
FROM pg_class WHERE oid IN (SELECT indexrelid FROM pg_index, pg_class WHERE
pg_class.relname='horde_datatree' AND pg_class.oid=pg_index.indrelid AND
indisunique != 't' AND indisprimary != 't')
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: CREATE INDEX
datatree_parents_idx ON horde_datatree (datatree_parents)
2008-05-26 16:15:17 CEST ouaga horde11 ERROR:  relation "horde_datatree"
does not exist
2008-05-26 16:15:17 CEST ouaga horde11 STATEMENT:  CREATE INDEX
datatree_parents_idx ON horde_datatree (datatree_parents)
2008-05-26 16:15:17 CEST ouaga horde11 LOG:  statement: COMMIT

Manual db creation with groupware script worked flawlessly.  Please do
update the README in sql dir as that one talks only about 3 scripts users,
prefs and datatree.

Please let me know if you need more information.

Regards,
Chris.