With PostgreSQL long keys work for me. PK generation is more or less different in nearly every setup (EO_PK_TABLE in OpenBase and MySQL, sequences in PostgreSQL, select unique in FrontBase, you name it).

What about native key generation in OpenBase using the OpenBasePKPlugIn? Has anyone tested that?

On Mar 20, 2007, at 3:56 PM, Guido Neitzer wrote:

On 20.03.2007, at 13:45, Mike Schrag wrote:

[FrontBase]
sql = "SELECT UNIQUE FROM " + quoteTableName (eoentity.primaryKeyRootName());

AFAIK: This will not return a long value, as "select unique" on FrontBase is limited to integer.

With PostgreSQL long keys work for me. PK generation is more or less different in nearly every setup (EO_PK_TABLE in OpenBase and MySQL, sequences in PostgreSQL, select unique in FrontBase, you name it).

So - if you need BIG keys, use either a database where the plugin (and the db of course) supports long keys, or use 24 byte binary keys from EOF.

cug
_______________________________________________
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/robertwalker1% 40mac.com

This email sent to [EMAIL PROTECTED]

--
Robert Walker
[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]

Reply via email to