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

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

On Jan 28, 2010, at 12:41 PM, Vladimir Gapeyev wrote:

> Bill, do you mean the data migration was done on the DB2 instance ... and then the result was ported to Postgres (via an SQL dump and restore?). 

Yes. (and as a corollary, a scary thing is that the migration scripts have never been tested on the Pg instance)

> If so, was the web app connected to the DB2 instance ever used to enter new data after the migration?

Yes, in that we went through a beta-testing phase intermingled with data migration. My recollection is that new records from beta-testing increased ids in normal fashion (meaning i+1 from the prior one -- not an order of magnitude greater). 

For example, go here:

http://8ball.sdsc.edu:6666/treebase-web/home.html

go to submission tab and log-in as "Pieltest" with password "Pieltest". You'll see that the submission_ids are in the 2,300 - 2,400 range.

You can try creating several dummy submissions one after the other -- and see if they increment by one. 

bp