Re: Upgrade from 2.5.0 to 2.5.2 does not work [message #12323 is a reply to message #12317] |
Mon, 04 August 2003 17:20 |
|
prottoss wrote on Mon, 04 August 2003 18:13 |
lstep wrote on Mon, 04 August 2003 03:44 |
On the SQL upgrade, it chokes/stops on a new error:
PostgreSQL Error: ERROR: ALTER TABLE: Attribute "pm_notify" contains NULL values
Query: ALTER TABLE fud25_users ALTER COLUMN pm_notify SET NOT NULL
What's supposed to be in this pm_notify? I just see it's a sequence.
|
Hmm strange error this is the last item in SQL upgrading and it shouldn't have failed since the table has a default value for that column that should've been set upon the column addition.
|
You're right, it's very strange. The record is set up to reveice a value from a sequence, so it should be ok:
fudbase=# select pm_notify from fud25_users limit 1;
pm_notify
-----------
(1 row)
May I do a update fud25_users set pm_notify = 1; ? What's the use of that pm_notify? (I've got 2 users, that not really a problem I guess)
|
|
|