A word of warning: There is a reason experienced Ingres architects do
not use any of the table key datatypes. The system maintained version
(the only one you may feel is useful) CANNOT be copied from one
database to another or even unloaded/reloaded. This means as a
synthetic/surrogate key it is not useful. Also, the string is an odd
format and difficult for humans to process. Using an integer with a
sequence is definitely the best way to go, even if it requires some
changes. Avoid the data type "system maintained"
On Mar 29, 2005, at 12:03 AM, Javed Khan Dalwai wrote:
table_key Ingres maintains a unique identifier for the table.
object_key Ingres maintains the unique identifier for the database.
_______________________________________________
Users mailing list
[email protected]
http://ingres.ca.com/mailman/listinfo/users
