Sorry, consider the following exception to be correct:
Caused by: org.postgresql.util.PSQLException: ERROR: column "test_column"
contains null values
On 2010-09-16, at 10:07 AM, Farrukh Ijaz wrote:
> Hi,
>
> Using Migrations I faced an issue. There is a table "TEST_TABLE" with
> existing data. I added a "Not Null" column "TEST_COLUMN" with default value
> "0". When I started migration, it failed to execute with following message:
>
> Caused by: org.postgresql.util.PSQLException: ERROR: column
> "is_dynamic_integer" contains null values
>
> The migration code is below which failed:
>
> ERXMigrationTable testTable = database.existingTableNamed("TEST_TABLE");
> testTable.newIntegerColumn("TEST_COLUMN", false, 0);
>
> Here is the modified version that works:
>
> ERXMigrationTable testTable = database.existingTableNamed("TEST_TABLE");
> testTable.newIntegerColumn("TEST_COLUMN", true);
> ERXJDBCUtilities.executeUpdateScript(database.adaptorChannel(), "UPDATE
> TEST_TABLE SET TEST_COLUMN = 0");
> ERXMigrationColumn testColumn = testTable.existingColumnNamed("TEST_COLUMN");
> testColumn.setAllowsNull(false);
> testColumn.setDefaultValue(0);
>
> Is this something I should always do for any additional Not Null column?
>
> Thanks,
>
> Farrukh
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/farrukh.ijaz%40fuegodigitalmedia.com
>
> This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
