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

16 Aug 2005

      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
 Assigned to:  Cvbge
 Reported by:  Cvbge
 Updated by:   Cvbge
 Status:       patch (code needs review)
 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

Cvbge