Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-401
Here is an overview of the issue:
---------------------------------------------------------------------
Key: CAY-401
Summary: improve pk sequence generator
Type: Improvement
Status: Assigned
Priority: Minor
Project: Cayenne
Components:
Cayenne Core Library
Versions:
1.2 [DEV]
Assignee: Andrus Adamchik
Reporter: Tore Halset
Created: Thu, 17 Nov 2005 8:24 AM
Updated: Thu, 17 Nov 2005 8:24 AM
Environment: PostgreSQL
Description:
Sequence should only be created for tables with single-column int pk that are not marked as generated. Currently (1.2M7) cayenne creates sequences for all tables and it looks a bit messy with \d in psql :)
Currently PostgreSQL sequences created by cayenne look like:
CREATE SEQUENCE pk_table INCREMENT 20 START 200
Perhaps we should set a ok default value:
CREATE SEQUENCE pk_table INCREMENT 20;
select setval('pk_table', max(id) + 20) from table;
---------------------------------------------------------------------
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 : Thu Nov 17 2005 - 08:24:31 EST