[drupal-devel] [bug] Postgres fixes for 4.6 release

[adrian]

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?