migrations and return values
migrations and return values
- Subject: migrations and return values
- From: Theodore Petrosky <email@hidden>
- Date: Sat, 14 Feb 2009 05:04:02 -0800 (PST)
is there a way to set values in the database from a migration. I refer to something like this:
SELECT setval('t_plum_job_seq', 1000)
If I issue a normal
ERXJDBCUtilities.executeUpdate(database.adaptorChannel(), "SELECT setval('t_plum_job_seq', 1000)");
This generates an error because of the return value.
Is there a way to do this? I am using the sequence to generate 'job numbers' and I want them to start at 1000. BTW, this is the PK of the table if that matters.
Ted
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden