Re: Patch: show xid and xmin in pg_stat_activity and pg_stat_replication

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Patch: show xid and xmin in pg_stat_activity and pg_stat_replication
Дата
Msg-id 29843.1391627351@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Patch: show xid and xmin in pg_stat_activity and pg_stat_replication  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Patch: show xid and xmin in pg_stat_activity and pg_stat_replication  (Christian Kruse <christian@2ndquadrant.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Feb 5, 2014 at 1:21 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Actually the part of that that bothers me is "xmin", which conflicts
>> with a reserved system column name.  While you can legally pick such
>> conflicting names for view columns, it's not going to be so much fun
>> when you try to join that view against some regular table.

> That's a fair point, too.  So maybe we should go with something like
> backend_xid and backend_xmin or some other prefix that we come up
> with.  My concern is more that I think they should be consistent
> somehow.

Works for me.
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: mvcc catalo gsnapshots and TopTransactionContext
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: jsonb and nested hstore