On Mon, May 19, 2008 at 12:05:45AM -0700, Sam's Lists wrote:
> Now it seems to be working...more or less. But sqlobject can't figure
> out the next unused id when creating a record. Instead it seems to be
> starting at 1. The program then errors out with a
> "psycopg2.IntegrityError: duplicate key value violates unique
> constraint" error.
Not a problem of SQLObject. PostgreSQL uses sequences for serial
(autoincremented) fields. For a new empty table sequences are automatically
set to start from 1. You have to setup the sequences for all serial fields
if you want to start from a specific value. Do
SELECT setval('sequence_name', value);
to set the value for the sequence. Read
http://www.postgresql.org/docs/8.3/static/functions-sequence.html
for further reference.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
