Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-61
Here is an overview of the issue:
---------------------------------------------------------------------
Key: CAY-61
Summary: Check starting value of next_id in auto_pk_support
Type: New Feature
Status: Assigned
Priority: Minor
Project: Cayenne
Components:
CayenneModeler GUI
Assignee: Andrus Adamchik
Reporter: Jim Menard
Created: Tue, 16 Dec 2003 5:59 PM
Updated: Tue, 16 Dec 2003 5:59 PM
Environment: Any
Description:
It would be nice if the SQL generator could gneerate update statements for the auto_pk_support table that set the next_id value to be larger than any existing primary key value in each table.
For example, I've had to write a script that generates SQL that does this for each table:
update auto_pk_support set next_id =
((select coalesce(max(id), 0) from the_table_name) + 20)
where table_name = 'the_table_name';
(In PostgreSQL, "coalesce" returns the first value in the series that is not NULL. Some tables may be empty, and max(id) will return NULL.)
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://objectstyle.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
This archive was generated by hypermail 2.0.0 : Tue Dec 16 2003 - 18:01:19 EST