Postgres Pro
Downloads
Home   >   mailing lists

Re: Lock while delete a table - Mailing list pgsql-novice

From Sergio Sinuco
Subject Re: Lock while delete a table
Date
Msg-id CAHn1vgEm+dHWpHt7FkaYeUBczKLTfcP8ngPf6PkN3kGZuhgquA@mail.gmail.com
Whole thread Raw
In response to Re: Lock while delete a table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view

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@sss.pgh.pa.us>
Sergio Sinuco <sergiosinuco@datatraffic.com.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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: error tryiing to insert with collate
Next
From: avalon78 geek
Date:
Subject: Re: ERROR: invalid input syntax for integer: SQL state: 22P02