Skip site navigation (1) Skip section navigation (2)

Re: Cannot DROP while process running

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Horn <steve(at)stevehorn(dot)cc>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Cannot DROP while process running
Date: 2012-04-09 20:08:55
Message-ID: 12479.1334002135@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Devrim GÜNDÜZDate: 2012-04-09 20:12:47
Subject: Re: Cannot DROP while process running
Previous:From: Steve HornDate: 2012-04-09 19:46:24
Subject: Re: Cannot DROP while process running

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group