# warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "project_rid_seq" does not exist in /home/p/drupal/includes/database.pgsql.inc on line 84.
# user warning: query: SELECT nextval('project_rid_seq') in /home/p/drupal/includes/database.pgsql.inc on line 103.

Comments

dww’s picture

dww
we/he/they
commented

thanks for the report. however, for anyone to fix this, it'd be helpful if you indicated what you did to generate that error. i.e. what page did you view, what link did you follow, what form values did you select, etc.

the error message is fairly obvious. however, it'll save time for us maintainers if we can easily reproduce the problem ourselves, fix the problem, then see the error go away.

thanks!
-derek

p.s. i'm on vacation until july 16th, so i won't be able to work on this for real until after that...

dww’s picture

dww
we/he/they
commented

bump: http://drupal.org/node/82696 is duplicate with this.

thsutton’s picture

thsutton commented

I got those error messages when add a new release to my project. They went away after a "CREATE SEQUENCE project_rid_seq;".

dww’s picture

dww
we/he/they
commented
Status: Active » Closed (won't fix)

this is specific to the evil old release system. this particular bug is no longer a problem on pgsql if you use the 4.7.x-2.* series of project.module. i'd rather put my efforts into the upgrade path for 4.7.x-1.* -> 4.7.x-2.* (and therefore, 5.x-1.*), than do the same kind of work i just did to fix a similar bug with issue followups in http://drupal.org/node/82696.