Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Lock while delete a table
Date
Msg-id 23491.1325524026@sss.pgh.pa.us
Whole thread Raw
In response to Lock while delete a table  (Sergio Sinuco <sergiosinuco@datatraffic.com.co>)
Responses Re: Lock while delete a table  (Sergio Sinuco <sergiosinuco@datatraffic.com.co>)
List pgsql-novice
Tree view 
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: "Jean-Yves F. Barbier"
Date:
Subject: Re: Lock while delete a table
Next
From: Tom Lane
Date:
Subject: Re: error tryiing to insert with collate