Ingres primary key generator doesn't work correctly with Ingres 10
------------------------------------------------------------------
Key: CAY-1660
URL: https://issues.apache.org/jira/browse/CAY-1660
Project: Cayenne
Issue Type: Bug
Components: Database integration
Affects Versions: 3.0.2
Environment: Ingres 10 (open source) on Linux (64 bit) (server), code
running on FreeBSD 9 openjdk 6 + cayenne 3.0.2
Reporter: Lucas Holt
Priority: Minor
I'm unable to create new objects using Cayenne due to problems using the
sequence. Later versions of Ingres added support for what they call identity
columns. They're similar to PostgreSQL serial columns and work with a sequence
which is either system defined or specified by the user. They're just an int
column with a default of the sequence. I'm certain the ingres pk generator
needs to be changed, but I'm not sure what information is necessary to fix this
problem in Ingres. The default appears to be assuming that pk_table_name or
similar is used. Ingres seems to generate very odd sequence names with $ii as
a prefix.
http://docs.actian.com/ingres/10.0/sql-reference-guide/4813-identity-columns
I suspect specifying a custom sequence name would get around this problem, but
it would be nice if it were supported automatically and I'm willing to help.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
