Deferrable constraint checking with SAVEPOINT? - Mailing list pgsql-general

From Mike Toews
Subject Deferrable constraint checking with SAVEPOINT?
Date
Msg-id AANLkTilzs3YOvxZhsoxdeSXQm_A9lgnDcIChx8_BQqcT@mail.gmail.com
Whole thread Raw
Responses Re: Deferrable constraint checking with SAVEPOINT?
List pgsql-general
Hi,

I have a question that is not specified in the docs[1]. I am using
deferrable constraints in a transaction with SET CONSTRAINTS ALL
DEFERRED. Now I know that DEFERRED constraints are not checked until
transaction COMMIT (i.e., the end), however are they checked with
SAVEPOINT (i.e., part-way in)?

Thanks,

-Mike

[1] http://www.postgresql.org/docs/8.4/static/sql-set-constraints.html

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Dell Poweredge server and Postgres
Next
From: Vick Khera
Date:
Subject: Re: Dell Poweredge server and Postgres