PostgreSQL update fails on nodewords_custom_pages [#939672]

Somehow, my nodewords_custom_pages tables have a corresponding sequence table named nodewords_page_weight_pid_seq.

Running the following command fixes the problem:

ALTER SEQUENCE nodewords_page_weight_pid_seq RENAME TO nodewords_custom_pid_seq;

I've looked at the module and I just cannot find anything that renames the table nodewords_page_weight to nodewords_custom. So I'm not too sure why this happens... Generally, the rename function does not automatically rename the sequences.

The error appears whenever the user adds a new custom entry:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "nodewords_custom_pid_seq" does not exist in /usr/clients/www_html/new.m2osw.com/public_html/includes/database.pgsql.inc on line 189.
* user warning: query: SELECT CURRVAL('nodewords_custom_pid_seq') in /usr/clients/www_html/new.m2osw.com/public_html/includes/database.pgsql.inc on line 282.

Thank you.
Alexis Wilke

Comments

Comment #1

AlexisWilke commented 13 October 2010 at 00:50

IMPORTANT NOTE: This statement fails on PostgreSQL 8.2 and older. It works since 8.3.

Thank you.
Alexis

Comment #2

AlexisWilke commented 18 October 2010 at 20:03

Issue tags:

+v6.x-1.12 blocker

Comment #3

dave reid

he/him

English

Nebraska USA

commented 30 October 2010 at 16:38

Status:

Active

» Fixed

I don't see anywhere where this could be coming from in the module, so I'm going to mark this as fixed unless you can point to the specific code that needs to be fixed.