Closed (fixed)
Project:
Date
Version:
6.x-2.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
15 Dec 2009 at 23:01 UTC
Updated:
26 Aug 2010 at 22:10 UTC
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
| Comment | File | Size | Author |
|---|---|---|---|
| date_api.install.pgseq_.patch | 816 bytes | neilnz |
Comments
Comment #1
karens commentedCommitted. Thanks!