Hi,

I just noticed I lost the ability to insert new custom formats following the upgrade including 6004 and 6005. The table was renamed from date_format to date_formats, but the sequence name remains date_format_dfid_seq. This works OK, except the call to db_last_insert_id() can't find the new sequence:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "date_formats_dfid_seq" does not exist in /var/www/drupal-site-intel-engage/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT CURRVAL('date_formats_dfid_seq') in /var/www/drupal-site-intel-engage/includes/database.pgsql.inc on line 232.

To correct this, I've made a patch that creates a 6006 update hook to fix up the sequence name. This should fix the problem up for anyone who has already run up to 6005 on PostgreSQL. I've tested it on my site.

Thanks

CommentFileSizeAuthor
date_api.install.pgseq_.patch816 bytesneilnz

Comments

karens’s picture

Status: Needs review » Fixed

Committed. Thanks!

Status: Fixed » Closed (fixed)

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