On Wed, Mar 4, 2009 at 1:17 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Phoenix Kiula <phoenix.ki...@gmail.com> writes: >> How can I get rid of these open locks? > > Close the transactions that are holding them. Look into > pg_stat_activity and pg_prepared_xacts.
Thanks for this. But can I simply delete all the pg_locks table? Or delete all rows in pg_stat_activity? In my case the _xacts table is empty. Ideally I don't want to lose pg_stat_activity. I just want to change a RULE on a table. Is there any place I can do that? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
