Re: Lock while delete a table

From: Sergio Sinuco <sergiosinuco(at)datatraffic(dot)com(dot)co>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Lock while delete a table
Date: 2012-01-02 19:13:58
Message-ID: CAHn1vgEm+dHWpHt7FkaYeUBczKLTfcP8ngPf6PkN3kGZuhgquA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

So, ¿a possible solution is to create the foreign key in table A with the
option "ON UPDATE NO ACTION ON DELETE NO ACTION" ?

Thanks.

2012/1/2 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

> Sergio Sinuco <sergiosinuco(at)datatraffic(dot)com(dot)co> writes:
> > Why does a drop table need an AccessExclusiveLock in tables refered by
> > the deleted table?
>
> To remove the triggers on the other table.
>
> regards, tom lane
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message avalon78 geek 2012-01-03 12:24:14 Re: ERROR: invalid input syntax for integer: SQL state: 22P02
Previous Message Tom Lane 2012-01-02 18:07:07 Re: error tryiing to insert with collate