I'm using Hibernate version 3.1 rc2, Oct 07, 2005 with Postgresql 8.0.1.

Im trying to use a unique id generator into all tables. What kind of strategy should I implement? Is that right using one sequence to all tables into database? May I use "seqhilo" to all <generator>´s using the same sequence? How large is the range of unique ids generated?

thanks for any help.

Daniel.

i would say it depends how many rows you plan to fill into that database. i would consider it a best practice to use a different sequence for every table. actually i see no reason not doing so.

OID ( Object ID ).

may I use sequence generator tag using one sequence to all tables? range are bigint/long 9x10^9 is good enough.

Please, tell me your opinion. Thanks in advance.

Daniel.