Re: External Representation

Am Samstag, 04.10.03, um 17:50 Uhr (Europe/Zurich) schrieb Giorgio 
Valoti:
> On Sabato, ott 4, 2003, at 16:35 Europe/Rome, Philip Mötteli wrote:
>> When I try to save a date to my Postgres db, I always have the same 
>> error:
>>
>> ERROR:  Bad abstime external representation '10-03-2003 14:15:16 
>> Europe/Zurich'
>>
>>
>> In EOModeler I have chosen 'abstime' as the external type and Date 
>> (NSCalendarDate) with the local timezone (Europe/Zurich) as the 
>> internal data type.
>> I have initialized the db with 'initdb --locale=de_CH' and set 
>> "datestyle = 'sql, us'".
>>
>> Can anybody give me a hint, what else I could try?
>
> With postgreSQL, I usually use timestamptz as external type.

Thanks, that was the solution! The reason, why I stuck with abstime, 
was becaue my Postgres adapter for EOModeler only offered timestamp, 
abstime and datetime. datetime isn't available any more on Postgres and 
timestamp had, as abstime, this annoying bad external representation 
error. But by manually chosing timestamptz in the attribute inspector, 
I could solve the problem. Thanks!
Do you know by chance, what I should do, if I would like to use the 
money type of Postgres, but my currency is not $? I have the same 'bad 
money external representation' error?


Thanks
Phil