Re: PyDO suggestions/comments

Jonathan Ellis <[email protected]> Tue, 17 May 2005 11:31:54 -0600
Newsgroups gmane.comp.web.skunkweb
Message-ID <[email protected]>
Jacob Smullyan wrote:
>>if I write Bar.new(), then exit w/o committing, then write b = Bar.new(); 
>>b.commit(), my new row has i=2 since apparently the sequence query wasn't 
>>really in the uncomitted transaction.
> 
> 
> I don't quite understand you.  You *should* see i>1 at that point,
> because the sequence did generate a value in the uncommitted
> transaction, and the value 1 of that sequence was used up.  Sequences
> don't reset upon rollback in postgresql.

Why, so they do not!  My bad.  I should have checked that but it never 
occurred to me that they wouldn't.

> Sorry about that!  I'm not using CVS any longer.  SkunkWeb now uses
> subversion at berlios.  There are no doubt out-of-date pages on the
> skunk site or wiki that still refer to cvs, but info is on the home
> page at http://skunkweb.org/.

Ah.  You might want to get rid of http://skunkweb.org/cvs.html then. :)

-Jonathan


-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click