6.0.0-alpha12
6/12/25

[#6759] Automatic table creation fails on postgresql
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

History
06/11/2008 08:03:22 AM Jan Schneider Comment #3
Assigned to Jan Schneider
State ⇒ Resolved
Reply to this comment
I guess there is nothing more we can fix on our side.
05/31/2008 09:05:13 AM Jan Schneider Comment #2
State ⇒ Feedback
Reply to this comment
This is weird, because MDB2 tries to create the index before the 
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.
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.
This is fixed.
05/26/2008 03:47:47 PM chris (at) vandenberghe (dot) org Comment #1
Priority ⇒ 1. Low
Patch ⇒ No
Milestone ⇒
Queue ⇒ Horde Groupware Webmail Edition
Summary ⇒ Automatic table creation fails on postgresql
Type ⇒ Bug
State ⇒ Unconfirmed
Reply to this comment
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.

Saved Queries