Re: begin transaction locks out other connections

On Thu, Apr 10, 2008 at 11:29 PM, Dennis Brakhane
<brakhane@googlemail.com> wrote:

>
>  I believe it does. See
>  http://www.postgresql.org/docs/8.3/interactive/sql-set-constraints.html
>  and the DEFERRABLE keyword in CREATE TABLE.
>
>  Or am I missing something here?
>

Only foreign key contrains checks (and triggers) can be deferred, not the
primary or unique key checks. See the following statement in the same doc
page:

"Currently, only foreign key constraints are affected by this setting. Check
and unique constraints are always effectively not deferrable. Triggers that
are declared as "constraint triggers" are also affected."

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com