Обсуждение: Question about CONSTRAINT TRIGGER

Поиск
Список
Период
Сортировка

Question about CONSTRAINT TRIGGER

От
ZM Yang
Дата:
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

Re: Question about CONSTRAINT TRIGGER

От
"David G. Johnston"
Дата:
On Friday, June 26, 2015, ZM Yang <zmpgzm@gmail.com> wrote:
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

I presume these are used by the system to choose between different triggers based upon which PK table caused the on update or on delete cascade to start.  Think of it as another kind of when clause.

David J.