Re: [SQLObject] is there a way to (re)set generator?
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Oleg B. <ph...@ph...> - 2010-04-19 12:57:55
|
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/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |