Issue status update for http://drupal.org/node/20440 Project: Drupal Version: cvs Component: postgresql database Category: bug reports Priority: critical Assigned to: adrian Reported by: adrian Updated by: adrian Status: patch Attachment: http://drupal.org/files/issues/postgres_1.patch (6.05 KB) I was unaware that our use of the sequences table is inconsistent, we are using auto_increment for smaller tables, and the sequences table for most of the important ones. I have been unable to reproduce the bug in the last message. Forums work fine for me, however I did add a new version of the IF() sql function to handle integer inputs (they were causing an error on forum display). adrian Previous comments: ------------------------------------------------------------------------ April 13, 2005 - 18:46 : adrian Attachment: http://drupal.org/files/issues/postgres_0.patch (6.74 KB) Attached are a bunch of postgres fixes. Caveat: Search index has to be rebuilt after this patch, and there is a postgres specific updates.inc entry. ------------------------------------------------------------------------ April 13, 2005 - 20:10 : Dries There is no sequence for the role table in MySQL's case. I think this patch would break adding new roles using MySQL. ------------------------------------------------------------------------ April 13, 2005 - 20:13 : Dries And how about this http://drupal.org/node/19562 issue?