Re: Patch: show xid and xmin in pg_stat_activity and pg_stat_replication - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Patch: show xid and xmin in pg_stat_activity and pg_stat_replication
Date
Msg-id 21071.1391624518@sss.pgh.pa.us
Whole thread Raw
In response to Re: Patch: show xid and xmin in pg_stat_activity and pg_stat_replication  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> It feels weird to me that the new columns are called transactionid and
> xmin.  Why not xid and xmin?

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.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Viability of text HISTORY/INSTALL/regression README files (was Re: [COMMITTERS] pgsql: Document a few more regression test hazards.)
Next
From: Robert Haas
Date:
Subject: Re: should we add a XLogRecPtr/LSN SQL type?