Re: [Treebase-devel] we may have to give up on PK auto-generation by postgres

[Vladimir G. <vla...@du...>]

On Jan 27, 2010, at 3:04 PM, William Piel wrote:

>> Am I right in thinking that hibernate's sequencing method will make  
>> it very difficult to use alternative connections like DBI/DBD?  
>> Also, if we keep the "nextval" declaration as-is, does that  
>> preserve our ability to use DBI/DBD (even if it is deceiving)?  If  
>> the hibernate-generated ids are indeed an order of magnitude  
>> greater than the hibernate_sequence, then a new record created with  
>> nextval will collide with existing ids created by hibernate.

That's right, any inserts that bypass the TB2 DAO layer will be likely  
to cause conflicts with the PK generation algorithm used by Hibernate.  
This is what we started with, when Youjun ran into the unit tests  
(that use DAO) conflicting with PKs already in DB (generated via  
postgres  nextval()) .

--VG