| Summary | Automatic table creation fails on postgresql |
| Queue | Horde Groupware Webmail Edition |
| Queue Version | 1.1 |
| Type | Bug |
| State | Resolved |
| Priority | 1. Low |
| Owners | jan (at) horde (dot) org |
| Requester | chris (at) vandenberghe (dot) org |
| Created | 05/26/2008 (6226 days ago) |
| Due | |
| Updated | 06/11/2008 (6210 days ago) |
| Assigned | 05/31/2008 (6221 days ago) |
| Resolved | 06/11/2008 (6210 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
Assigned to Jan Schneider
State ⇒ Resolved
State ⇒ Feedback
actual table. Since table creation is completely out-sourced to the
MDB2 package, there is not much we can do about this. But at least the
fall-back method works.
do update the README in sql dir as that one talks only about 3
scripts users, prefs and datatree.
Priority ⇒ 1. Low
Patch ⇒ No
Milestone ⇒
Queue ⇒ Horde Groupware Webmail Edition
Summary ⇒ Automatic table creation fails on postgresql
Type ⇒ Bug
State ⇒ Unconfirmed
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.