Jeanna Geier wrote:
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...
That's the constraint name.
More detailed here:
http://www.postgresql.org/docs/8.1/interactive/sql-createtable.html
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
