Re: DbRelationship and FK_NAME

From: Tore Halset (halse..vv.ntnu.no)
Date: Wed Dec 19 2007 - 08:20:25 EST

  • Next message: Andrus Adamchik: "Re: DbRelationship and FK_NAME"

    On Dec 19, 2007, at 12:36 , Andrus Adamchik wrote:

    > Hmm... I thought FK_NAME was a column name of the FK?

    Example from cayenne junit db in PostgreSQL:

    cayenne=> \d painting
                       Table "public.painting"
             Column | Type | Modifiers
    ----------------------+------------------------+-----------
      artist_id | integer |
      estimated_price | numeric(10,2) |
      gallery_id | integer |
      painting_description | character varying(255) |
      painting_id | integer | not null
      painting_title | character varying(255) | not null
    Indexes:
         "painting_pkey" PRIMARY KEY, btree (painting_id)
    Foreign-key constraints:
         "painting_artist_id_fkey" FOREIGN KEY (artist_id) REFERENCES
    artist(artist_id)
         "painting_gallery_id_fkey" FOREIGN KEY (gallery_id) REFERENCES
    gallery(gallery_id)

    Here "painting_artist_id_fkey" and "painting_gallery_id_fkey" are
    FK_NAMEs. Those are needed only when you want to drop the foreign key.

    Regards,
      - Tore.

    This archive was generated by hypermail 2.0.0 : Wed Dec 19 2007 - 08:21:03 EST