Re: Hashagg planning bug (8.0.1)

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Hashagg planning bug (8.0.1)
Дата
Msg-id 1115744422.6888.90.camel@home
обсуждение исходный текст
Ответ на Re: Hashagg planning bug (8.0.1)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Hashagg planning bug (8.0.1)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Tue, 2005-05-10 at 12:50 -0400, Tom Lane wrote:
> Rod Taylor <pg@rbt.ca> 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)

-- 



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Views, views, views! (long)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Hashagg planning bug (8.0.1)