Re: Newbie Constraint ? - Mailing list pgsql-general

From Jeanna Geier
Subject Re: Newbie Constraint ?
Date
Msg-id FBEGJLLJBCOMCDBJHIMEIEKBCCAA.jgeier@apt-cafm.com
Whole thread Raw
Responses Re: Newbie Constraint ?
Re: Newbie Constraint ?
List pgsql-general
 Hello List!

 OK, so I'm new to SQL and Postgres and am working on taking over this DB
work, and ran across a command that I'm not sure of and am wondering if you
can help me with... Probably a basic SQL question, but thought more than one
person on here would be able to point me in the right direction!!

 In on of the tables in the DB, there is a constraint defined that I'm not
familiar with:

   CONSTRAINT "Relationship182" FOREIGN KEY (elementid)
      REFERENCES element (elementid) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE


 Not quite sure what the: CONSTRAINT "Relationship182" is exactly...  can
anyone help me with this one?  Haven't seen this one yet...


 Thanks much for your help and support!
 -Jeanna


pgsql-general by date:

Previous
From: Oisin Glynn
Date:
Subject: Re: Database Failure on Windows XP Pro psql (PostgreSQL)
Next
From: "Brandon Aiken"
Date:
Subject: Re: Database Failure on Windows XP Pro psql (PostgreSQL) 8.1.4