Re: Postgresql and External type

Hi, 

I've been using "int4" as the external type for Number (Integer),
and it works fine. 

Also, make sure that you use Kenny Leung's PostgresqlPlugIn
and PostgresqlPlugInBundle.

http://www.hexdreams.com

Hope this helps, 
Tatsuya


 
> Hi,
> 
> When I add an attribute with external type 'integer' or 'smallint' or
> 'bigint' and try to generate the create table sql-statement I am
> getting the following message:
> 
> Unable to find type information for external type 'integer' in
> attribute 'age' of entity 'Author'.  Check spelling and capitalization.
> 
> If I change it to external type char or numeric - which are legal data
> types in Postgresql just like integer - EOF has no problem generating
> the create table sql.
> 
> What does it takes to also work with integer external type ?  Are any
> other known external data types EOF is picky with using Postgresql ?
> 
> Thanks ahead,
> János
> P.S.  I am using Posgresql 7.2.3 and Webobjects 5.1.4