[
https://issues.apache.org/jira/browse/CAY-1660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13210422#comment-13210422
]
Lucas Holt commented on CAY-1660:
---------------------------------
I just tested this with my application and it is working.
Thanks Olga!
> 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
