Re: BUG #5621: Insufficient locking of dependent objects

On Tue, Aug 17, 2010 at 2:15 PM, Caleb Welton <cwelton(at)greenplum(dot)com> wrote:
> There is a general class of concurrency bugs related to insufficient
> locking
> of dependent objects.  This can occur with just about any inter-object
> dependency that exists in the system:
>
>  Creating a table while dropping the schema it is in
>  Creating a table while dropping a type it depends on
>  Creating a function while dropping the language
>  Creating an aggregate while dropping the transition function.
>  Etc.

More specifically, I think the bug is that we don't really do much
locking on database objects other than tables. This would be good to
fix, but probably we'd need to start by coming up with a coherent
overall plan.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company