| From: | ZM Yang <zmpgzm(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Question about CONSTRAINT TRIGGER |
| Date: | 2015-06-27 00:24:21 |
| Message-ID: | CALPr3ozuYSC4=8VWf8uB_oEdCChKWyk58GBMSBgXZT6+nFvZ1Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2015-06-27 02:13:53 | Re: How to convert a text variable into a timestamp in postgreSQL? |
| Previous Message | David G. Johnston | 2015-06-26 19:45:02 | Re: Foreign data wrappers and indexes on remote side |