Re: Cannot DROP while process running

Steve Horn <steve@stevehorn.cc> writes:
> Here is the result of this select:
> select datname, procpid, current_query from pg_stat_activity;

> As you can see, there appears to be no connection to the other tables with
> the AccessShareLocks.

Well, it's hard to tell what other locks those transactions have already
got.  You really ought to be looking in pg_locks not just
pg_stat_activity.

BTW, another thing that occasionally trips people up is unintended use
of a prepared transaction (that they then forget to commit or roll back).
Does the pg_prepared_xacts view show anything?

                       regards, tom lane