Обсуждение: valid using INITIALLY DEFERRED

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

valid using INITIALLY DEFERRED

От
Pavel Stehule
Дата:
Hello,

  I try INITIALLY DEFERRED clause. In doc is relation between general
constraint and this clause. But combination with CHECK clause ends with
err message misplaced INITIALLY DEFERRED clause.

Is possible use INITIALLY DEFERRED with other variants constraint than
REFERENCES?

Thank You
Pavel Stehule



Re: valid using INITIALLY DEFERRED

От
Michael Fuhr
Дата:
On Wed, Dec 22, 2004 at 04:17:29PM +0100, Pavel Stehule wrote:

>   I try INITIALLY DEFERRED clause. In doc is relation between general
> constraint and this clause. But combination with CHECK clause ends with
> err message misplaced INITIALLY DEFERRED clause.

The CREATE TABLE documentation for INITIALLY DEFERRED says, "If a
constraint is deferrable, this clause specifies the default time
to check the constraint."  Just above that, the documentation for
DEFERRABLE says, "Only foreign key constraints currently accept
this clause.  All other constraint types are not deferrable."

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Re: valid using INITIALLY DEFERRED

От
Tom Lane
Дата:
Pavel Stehule <stehule@kix.fsv.cvut.cz> writes:
> Is possible use INITIALLY DEFERRED with other variants constraint than
> REFERENCES?

No, we only support deferring foreign key constraints at the moment.

            regards, tom lane