Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Add Column - Not Null (Yes) bug?

Apr 8, 2006, 12:37 AM
rgbworld
User (325 posts)
rgbworld's avatar
Apr 8, 2006, 12:37 AM
Post #1 of 2
Views: 1389
Shortcut
Quote Reply
Add Column - Not Null (Yes) bug?
When adding a new column to the links table via admin, if you set NOT NULL to 'Yes',
it gives the following error:

Unable to add column 'Test3': Column Test3 was specified as not null, but has no default value

To add the column, you must enter data in the 'Default' field.
Then the column adds sucessfully.

Once the column has been added, you can edit it and remove the default value.

Hope that helps,
Chris
RGB World, Inc. - Software & Web Development.
rgbworld.com
Apr 8, 2006, 1:41 AM
brewt
Staff (4101 posts)
brewt's avatar
Apr 8, 2006, 1:41 AM
Post #2 of 2
Views: 1295
Shortcut
Quote Reply
Re: [rgbworld] Add Column - Not Null (Yes) bug? In reply to
I took a look at the code and it looks like it's supposed to be like that:
Code:
# You are not permitted to add a not_null column without a default to a table -
# the default is required for existing columns. You could, if you really want
# it with no default, create it with a default, then alter it to drop the
# default.

Adrian