I have a migration that is working perfectly. But I need to set the starting 
value of a sequence... how can I do this?

I tried to add (before I inserted any rows):

ERXJDBCUtilities.executeUpdate(database.adaptorChannel(), 
"SELECT setval('t_plum_job_seq', 1000)");

which works... the sequence is set to the value. however the migration fails 
with an error:

PSQLException: A result was returned when none was expected.

which causes the _dbupdater transaction to rollback. so the app won't run... 

is there a way to do this in the migration or do I have to do this manually?

Ted


      
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to