On Tue, 2005-05-10 at 12:50 -0400, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > Oh, stat_activity is a view which removes idle connections from
> > displaying and allows non-privileged users to see everything that's
> > going on within the DB.
>
> Still works fine for me. Do you even have an operator 716373?
> If so what is it?
It's the = operator that Slony adds for xxid comparisons. I didn't even
think of changes Slony would have made.
ssdb=# select * from pg_operator where oid = 716373;
oprname | oprnamespace | oprowner | oprkind | oprcanhash | oprleft | oprright
| oprresult | oprcom | oprnegate | oprlsortop | oprrsortop | oprltcmpop |
oprgtcmpop | oprcode | oprrest | oprjoin
---------+--------------+----------+---------+------------+---------+----------+-----------+--------+-----------+------------+------------+------------+------------+---------------+---------+-----------
= | 2200 | 588 | b | t | 716353 | 716353
| 16 | 716373 | 716372 | 716371 | 716371 | 716371 |
716369 | _ssrep.xxideq | eqsel | eqjoinsel
(1 row)
--
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
