how to release a transaction lock on a table?

From: Si Chen <schen(at)graciousstyle(dot)com>
To: PgSql General <pgsql-general(at)postgresql(dot)org>
Subject: how to release a transaction lock on a table?
Date: 2005-01-31 18:13:26
Message-ID: 41FE7546.2090700@graciousstyle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone. I am trying to do an ALTER TABLE, but it hangs
indefinitely. I think the table is locked from a transaction, and in
pg_locks I found:
relation 75907
database 74861
pid 29604
mode AccessExclusiveLock
granted f

Is there a way to release this lock? Or does the database need to
re-started?

Si

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-01-31 18:16:49 Re: "Invalid multibyte character for locale" still there
Previous Message Edward Macnaghten 2005-01-31 18:12:21 Re: Identity Problem