module installs properly, but gives an error while adding a new view:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "views_union" does not exist in /var/www/drupal/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT id, U.parent, P.name AS parent_name, U.child, C.name AS child_name, U.lim, U.ignore_on_filter FROM views_union U LEFT JOIN view_view P ON U.parent=P.vid LEFT JOIN view_view C ON U.child=C.vid WHERE U.parent='0' in /var/www/drupal/includes/database.pgsql.inc on line 144.

Comments

Anonymous’s picture

Anonymous (not verified) commented

This is probably due to the same problem as the other bug ("sql error"). I just committed the (embarassingly simple) fix to that. Try it again. Try it in a fresh database, if at all possible, because the messed-up installer may have left your database in some sort of weird state. If it has, and starting a fresh database isn't a possibility, you can remove the changes by hand, by doing things like this:

DROP INDEX {views_union}_parent_idx;
DROP INDEX {views_union}_child_idx;
DROP SEQUENCE {views_union}_id_seq;
DROP TABLE {views_union};

and, if necessary,
DELETE FROM {system} WHERE name='views_union' and type='module';

But it looks like your views_union table never got created.

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Closed (duplicate)

This is probably due to the same problem as the other bug ("sql error"). I just committed the (embarassingly simple) fix to that. Try it again. Try it in a fresh database, if at all possible, because the messed-up installer may have left your database in some sort of weird state. If it has, and starting a fresh database isn't a possibility, you can remove the changes by hand, by doing things like this:

DROP INDEX {views_union}_parent_idx;
DROP INDEX {views_union}_child_idx;
DROP SEQUENCE {views_union}_id_seq;
DROP TABLE {views_union};

and, if necessary,
DELETE FROM {system} WHERE name='views_union' and type='module';

But it looks like your views_union table never got created.