[Nitro] Og, adapting postgresql to reorgnaization

[Jonathan Buch]

Hi,

> Think this has been discussed before and the solution is to not use
> autoincrement. There shoud be an adapter method #new_id(table). In
> PostgreSQL this would quesry the sequence.

yes, I think this would be the way to go...

SELECT AUTO_INCREMENT FROM information_schema.tables
             WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'addresses';

maybe around those lines...  Just now to find out how to
actually increment the auto increment..

Well, how about:

ALTER TABLE tbl AUTO_INCREMENT = 100;

and just set that to one above and use the correct oid for inserting,
should replicate the psql behaviour.  Someone care to find out how
to do that stuff for sqlite?

Jo

-- 
Feel the love
http://pinkjuice.com/pics/ruby.png