[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] list blocking queries
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2012-01-31 21:43:03
Message-ID: 11192.1328046183 () sss ! pgh ! pa ! us
[Download RAW message or body]

Scot Kreienkamp <SKreien@la-z-boy.com> writes:
> There's something wrong with the query that I've written based on what you gave me.

It looks like you forgot the ON condition for the next-to-last JOIN,
so the parser is still expecting another ON when it runs into the WHERE.

Personally I think this sort of FROM construction is pretty bad style
anyway, because it takes an eagle eye to see which ON goes with which
JOIN, and even worse it's very easy to get them connected up wrongly.
You'd be a lot better off with explicit parentheses, viz

from
	(pg_catalog.pg_locks bl join pg_catalog.pg_stat_activity a on bl.pid = a.procpid)
  join
	(pg_catalog.pg_locks kl join pg_catalog.pg_stat_activity ka on kl.pid = ka.procpid)
  on the-long-on-condition-goes-here

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]