are you using an up-to-date postgresql plugin from Wonder?
in PostgresqlExpression:
public void addCreateClauseForAttribute(EOAttribute attribute) {
NSDictionary userInfo = attribute.userInfo();
Object defaultValue = null;
if (userInfo != null) {
defaultValue =
userInfo.valueForKey("er.extensions.eoattribute.default");
}
String allowsNullClauseForConstraint =
allowsNullClauseForConstraint(shouldAllowNull(attribute));
String sql;
if (defaultValue == null) {
sql =
_NSStringUtilities.concat(this.quoteIdentifier(attribute.columnName()), " ",
columnTypeStringForAttribute(attribute), " ", allowsNullClauseForConstraint);
}
else {
sql =
_NSStringUtilities.concat(this.quoteIdentifier(attribute.columnName()), " ",
columnTypeStringForAttribute(attribute), " DEFAULT ",
formatValueForAttribute(defaultValue, attribute), " ",
allowsNullClauseForConstraint);
}
appendItemToListString(sql, _listString());
}
the "er.extensions.eoattribute.default" is injected into the attribute userInfo
by migrations ... you can add some debug to this method and see what is going
on, but i'm pretty sure this works.
ms
On Sep 18, 2010, at 4:37 PM, Farrukh Ijaz wrote:
> 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]
