On Mon, Apr 19, 2010 at 01:52:31PM +0200, Petr Jake?? wrote:
> > OMG, you did mean FB generator, not Python! You need to be more specific.
> > (-:
>
> Sorry about that, my feeling was all SQL engines are using ID generators to
> store in it.
They use, but some of them are internal and don't have any SQL-based
access. For example, SQLite internally use MAX(id); this means if you
delete some rows, id could be reused. MySQL has an internal monotonous
generator that can only be queried with SELECT LAST_INSERT_ID(). Postgres
has generators (called "sequences") with full SQL-based access; one can
query and set them at will.
Oleg.
--
Oleg Broytman http://phd.pp.ru/ p...@phd.pp.ru
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
