On Wed, Oct 12, 2005 at 04:11:00AM +0000, Carlos Benkendorf wrote: > How can I know which rows are locked?
There's no query that says "show me all rows that are locked"; even if there was, it would be out of date by the time you got the results. PostgreSQL 8.1 will enhance pg_locks to show tuple locks in certain cases but it won't show all tuple locks. Why do you want to know? What are you trying to do? -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
