Re: [Treebase-devel] Hibernate_sequence need a bigger value

[William P. <wil...@ya...>]

On Dec 23, 2009, at 12:25 PM, Vladimir Gapeyev wrote:

> I think we need someone who is more aware about what is going on in TB2 (Rutger? Bill?) to resolve this.  

Rutger would know. 

One of the early bugs after the DB2->Pg migration was that new records generated an uncaught exception because sequences had not been setup -- so Rutger went through an added sequence definitions for various tables. It's not impossible that sequences were added some for tables where Hibernate was already taking care of this, causing a clash. 

Personally, I would favor having Pg take care of all the sequences, since I guess this would make it easier for alternative connections to the database to add records, bypassing the Java. (not that this is recommended, condoned, or in any way planned for the future -- But it gives us that flexibility, no?)  But obviously I leave this up to the experts (y'all). 

bp