On Jul 7, 2009, at 5:32 PM, Andrew Lindesay wrote:
Hello David;
I don't use Postgresql, but I believe that the prototype "id" is
the one to use for PKs and FKs. I see that there only seems to be
an external type of integer for Postgress and even a LongNumber
prototype which has a java datatype of Long, is still an integer in
Postgress. Are postgress integers really longs?
I tend to use PG's int4 and int8 types to be sure and generally use
int8 for PK/FK's to avoid grief as tables get large.
Same here.
Based on http://www.postgresql.org/docs/8.2/static/datatype-
numeric.html I would think that bigint (8byte) would be a better
external data type than integer (4 byte).
I guess this is where Kieran's solution of using ERXModel so you can
override the ERPrototypes default of "integer" would fit in if you
think you'll need keys > 2147483647. Two billion is a lot, but not a
completely unreasonable quantity.
Dave
cheers.
___
Andrew Lindesay
www.lindesay.co.nz
_______________________________________________
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]
