[JIRA] Commented: (CAY-937) Database Schema Migration does not create FK constraints.

["Tore Halset (JIRA)" <de...@cayenne.apache.org>]

    [ https://issues.apache.org/cayenne/browse/CAY-937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12639 ] 

Tore Halset commented on CAY-937:
---------------------------------

We already have code for adding a FK, so that one should not be too hard. Dropping a FK seem to be a bit more difficult. Both PostgreSQL and Derby support "alter table ... drop constraint fkname", but it can be hard to find the correct foreign key name.



> Database Schema Migration does not create FK constraints.
> ---------------------------------------------------------
>
>                 Key: CAY-937
>                 URL: https://issues.apache.org/cayenne/browse/CAY-937
>             Project: Cayenne
>          Issue Type: Improvement
>          Components: Cayenne Core Library
>    Affects Versions: 3.0
>            Reporter: Kevin Menard
>            Assignee: Tore Halset
>            Priority: Minor
>             Fix For: 3.0
>
>
> It'd be nifty if the database schema migration tool could detect if a FK relationship needs to be set up.  The DB generation function can set up FK relationships as is, so hopefully it's not too great a stretch to make it work with the migration tool as well.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.