Postgres Pro
Downloads
Home   >   mailing lists

Question about CONSTRAINT TRIGGER - Mailing list pgsql-general

From ZM Yang
Subject Question about CONSTRAINT TRIGGER
Date
Msg-id CALPr3ozuYSC4=8VWf8uB_oEdCChKWyk58GBMSBgXZT6+nFvZ1Q@mail.gmail.com
Whole thread Raw
Responses Re: Question about CONSTRAINT TRIGGER  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
Hi folks,

I'm confused about the usage of CONSTRAINT TRIGGER. More specifically, the documentation says that the name of another table referenced by the constraint can be specified in a FROM clause:

"The (possibly schema-qualified) name of another table referenced by the constraint. This option is used for foreign-key constraints and is not recommended for general use. This can only be specified for constraint triggers."

(1)
How can the table name specified in the the FROM clause be used? It seems that it cannot be referenced in the WHERE clause. (Please correct me if I'm wrong) 

(2)
How is the table specified in the FROM clause used for FK constraints?

Thanks,
ZM

pgsql-general by date:

Previous
From: litu16
Date:
Subject: How to convert a text variable into a timestamp in postgreSQL?
Next
From: "David G. Johnston"
Date:
Subject: Re: How to convert a text variable into a timestamp in postgreSQL?