Search Postgresql Archives

Re: Newbie Constraint ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux