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

From: Tore Halset (JIRA) ("Tore)
Date: Tue Dec 18 2007 - 04:11:44 EST

  • Next message: Andrus Adamchik (JIRA): "[JIRA] Created: (CAY-945) PropertyUtils support for "compiled" property access"

        [ 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.

    This archive was generated by hypermail 2.0.0 : Tue Dec 18 2007 - 04:12:09 EST