| From: | "Jeanna Geier" <jgeier(at)apt-cafm(dot)com> |
|---|---|
| To: | "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Newbie Constraint ? |
| Date: | 2007-01-08 20:55:29 |
| Message-ID: | FBEGJLLJBCOMCDBJHIMEIEKBCCAA.jgeier@apt-cafm.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brandon Aiken | 2007-01-08 20:56:06 | Re: Database Failure on Windows XP Pro psql (PostgreSQL) 8.1.4 |
| Previous Message | Oisin Glynn | 2007-01-08 20:54:20 | Re: Database Failure on Windows XP Pro psql (PostgreSQL) |