how to release a transaction lock on a table? - Mailing list pgsql-general

From Si Chen
Subject how to release a transaction lock on a table?
Date
Msg-id 41FE7546.2090700@graciousstyle.com
Whole thread Raw
Responses Re: how to release a transaction lock on a table?  (Michael Fuhr <mike@fuhr.org>)
List 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

pgsql-general by date:

Previous
From: Edward Macnaghten
Date:
Subject: Re: Identity Problem
Next
From: Tom Lane
Date:
Subject: Re: "Invalid multibyte character for locale" still there