Steve Horn <steve(at)stevehorn(dot)cc> writes:
> When I issue the drop command for a table, the server doesn't respond - not
> even with increased disk activity or CPU usage. I am wondering if a lock is
> blocking it?
Look into pg_locks to find out.
> When I select from pg_stat_activity the table I am intending
> on dropping is not listed as having anything actively using it.
Perhaps it has a foreign key link to/from something that's in use?
regards, tom lane