Hi Mike, Thanks for your prompt reply. We are using Postgresql and I am talking about the SQL insert statement which gives me error when I execute using Aqua Studio or PSQL tool.
Do you think I am missing something? Well this is not a show stopper and I can create an extra version to execute DDL script to set default values. Farrukh Sent from my iPhone On 2010-09-18, at 11:28 PM, Mike Schrag <[email protected]> wrote: > default values is not supported by eof directly ... it's up to your database > plugin to support wonder's extension for this to work. currently i believe > only frontbase and postgresql migrations support this. > > ms > > On Sep 18, 2010, at 4:17 PM, Farrukh Ijaz wrote: > >> Hi, >> >> I've noticed that MIgrations code does not respect the default values >> specified. E.g. Following code creates a database table called CALENDAR. >> >> ERXMigrationTable calendarTable = database.newTableNamed("CALENDAR"); >> calendarTable.newStringColumn("CAL_DESC", 512, true); >> calendarTable.newStringColumn("CAL_NAME", 64, false); >> calendarTable.newIntegerColumn("IS_PUBLIC", false, 0); >> calendarTable.newIntegerColumn("OID", false); >> calendarTable.create(); >> calendarTable.setPrimaryKey("OID"); >> >> Technically this should set the column to set the default value to 0 for >> IS_PUBLIC column whenever a record is inserted in this table. But this is >> not the case, inspecting the table structure tells there is no default value >> set for this column and inserting a new record in this table without >> explicitly specifying the is_public value to 0, it gives Not Null sql >> exception. >> >> Any comments? >> >> 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/mschrag%40pobox.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/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]
