[Zope] ZSQL retreive auto_increment id inserted [Q]

[Steen Suder]

Sam Gendler wrote:
> 
> Does zope have some kind of locking around the ZSQLMethods, or is there
> a chance that another query could slip in between the first and the
> second query.  If there is a guarantee in zope that a single ZSQLMethod
> will execute in a threadsafe manner, I am comfortable with it.  I can
> make sure that there is no insert access from outside of zope. Of
> course, this becomes a problem againa as soon as you use Zeo for
> anything (something I was planning to do), since there will presumably
> be a different database connection from each zope instance, so no way to
> do this without locking of some sort.  I can feel a switch to postgresql
> or oracle coming on... (Ugh!)
> 
> --sam
<CUT>

It sounds a bit like you fear PostgreSQL (I don't know Oracle)...?!
You have nothing to fear, I say.
PostgreSQL is really nice to work with and lots of features that MySQL
and others... ehh... has not.

I dig PostgreSQL!

-- 
Best regards / Mvh.,
Steen Suder
sysadm kollegie6400.dk
OpenSource --- Sign of the time