# warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "pmi" at character 17 in /home/forum/drupal-6.9/includes/database.pgsql.inc on line 139.
# user warning: query: UPDATE pm_index pmi SET is_new = 0 WHERE uid = 1 AND is_new = 1 AND mid

CommentFileSizeAuthor
#1 privatemsg.pgsql_fix_set_new_status.patch864 bytesberdir

Comments

berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Status: Active » Needs review
StatusFileSize
new privatemsg.pgsql_fix_set_new_status.patch864 bytes

Which PostgreSQL version are you using ?

I can't reproduce the error with PostgreSQL 8.3 but the pmi isn't needed anyway, so please test the attached patch

litwol’s picture

litwol commented
Status: Needs review » Fixed

Small and to the point, just how i like 'em ;)

Thanks!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.