[drupal-devel] [bug] Incorrect order of sql statements can make update fail

[Cvbge]

Issue status update for 
http://drupal.org/node/28986
Post a follow up: 
http://drupal.org/project/comments/add/28986

 Project:      Drupal
 Version:      4.6.2
 Component:    postgresql database
 Category:     bug reports
-Priority:     critical
+Priority:     normal
 Assigned to:  Cvbge
 Reported by:  Cvbge
 Updated by:   Cvbge
 Status:       patch (code needs review)

It's probably not 'critical' bug.




Cvbge



Previous comments:
------------------------------------------------------------------------

Tue, 16 Aug 2005 17:22:21 +0000 : Cvbge

Attachment: http://drupal.org/files/issues/update_131.diff (1010 bytes)

The code adds new column and then immediately sets it to NOT NULL. If
there are any rows in the table the new column is NULL and setting it 
to NOT NULL fails. Changing the order or sql statesments solves the
problem