diff options
author | Selena Deckelmann <selenamarie@gmail.com> | 2007-11-24 14:11:46 -0800 |
---|---|---|
committer | Selena Deckelmann <selenamarie@gmail.com> | 2007-11-24 14:11:46 -0800 |
commit | ad675de05096a509169a67440a72f9e81f033a45 (patch) | |
tree | 42c79eab1aa5f786146dadd719891a0f732d36c3 /commands.c | |
parent | f2e159bb697d924982b4d588e71efc2e9bfd1e83 (diff) |
fixed query for Locks to show locks not granted
Diffstat (limited to 'commands.c')
-rw-r--r-- | commands.c | 7 |
1 files changed, 4 insertions, 3 deletions
@@ -87,10 +87,11 @@ static char *err_listem = #define GET_LOCKS \ "SELECT datname, relname, mode, granted\n" \ - "FROM pg_stat_activity, pg_locks, pg_class\n" \ + "FROM pg_stat_activity, pg_locks\n" \ + "LEFT OUTER JOIN pg_class\n" \ + "ON relation = pg_class.oid\n"\ "WHERE procpid = %d\n" \ - " AND procpid = pid\n" \ - " AND pg_class.oid = relation;" + " AND procpid = pid;" \ /* * err_compar(p1, p2) - comparison routine used by "qsort" |