i had this error when trying to use node expire in drupal 5.1 using postgreSQL

* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "node_expire" does not exist in /path_to_site/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT expire, expiremode FROM node_expire WHERE nid = 22 in /path_to_site/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "node_expire" does not exist in /path_to_site/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT expire, expiremode FROM node_expire WHERE nid = 15 in /path_to_site/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "node_expire" does not exist in /path_to_site/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT expire, expiremode FROM node_expire WHERE nid = 7 in /path_to_site/includes/database.pgsql.inc on line 144.

the module is correctly installed as far as i know

Comments

astoltz’s picture

astoltz commented

That is correct. I had intent to get PG support for this module, but I havn't had much success setting up a development server for it. I'd be glad to get support for this once I can get decent instruction on actually getting a working, locked-down PostgreSQL server.

Sorry about that.

astoltz’s picture

astoltz commented
Assigned: Unassigned » astoltz

I have added PostgreSQL support to the developmental release. This should be showing up sometime within the next 24 hours on the Drupal website. Please uninstall the module, download the latest dev release, and try installing again.

I went through the program and tried manually running the queries to make sure they worked, as well as basic testing of the module. I can't guarantee that there won't be any bugs with it, but I don't believe there are. Please try to test this out as thoroughly as you can and let me know the results.

Thanks.

astoltz’s picture

astoltz commented
Status: Active » Fixed

It's been 2 weeks since my implementation went into place with no complaints. A new ticket can be issued if there are problems with it.

astoltz’s picture

astoltz commented
Status: Fixed » Closed (fixed)