Tickets :: Comment on [#6759] Automatic table creation fails on postgresql

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

Saved Queries