[
https://issues.apache.org/jira/browse/CAY-1660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13202244#comment-13202244
]
Andrus Adamchik commented on CAY-1660:
--------------------------------------
Hi Keith,
Thanks for offering help. Ingres has fallen of the Cayenne radar lately. The
latest set of Jiras including this one, promoted us to look back at our Ingres
adapter. Olga (a Cayenne committer) is now installing Ingres to see where we
stand right now. We'll likely be asking more questions as we go.
> 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
