Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [GENERAL] [HACKERS] Hot Standby utility and administrator functions
- From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
- To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, pgadmin-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
- Subject: Re: [GENERAL] [HACKERS] Hot Standby utility and administrator functions
- Date: Mon, 20 Oct 2008 21:56:06 +0100
- Message-id: <1224536166.3808.864.camel@ebony.2ndQuadrant> <text/plain>
On Mon, 2008-10-20 at 17:44 -0300, Alvaro Herrera wrote: > Simon Riggs escribió: > > > > On Mon, 2008-10-20 at 16:22 -0400, Robert Haas wrote: > > > > * pg_last_recovered_xact_xid() > > > > Will throw an ERROR if *not* executed in recovery mode. > > > > returns bigint > > > > > > > > * pg_last_completed_xact_xid() > > > > Will throw an ERROR *if* executed in recovery mode. > > > > returns bigint > > > > > > Should these return xid? > > > > Perhaps, but they match txid_current() which returns bigint. > > http://developer.postgresql.org/pgdocs/postgres/functions-info.html > > That's been "extended with an epoch counter" per the docs; I don't think > that's appropriate for the new functions, is it? I assumed it was, so you can subtract them easily. It can be done either way, I guess. Happy to provide what people need. I just dreamed up a few that sounded useful. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support
- References:
- Hot Standby utility and administrator functions
- From: Simon Riggs
- Re: [HACKERS] Hot Standby utility and administrator functions
- From: Robert Haas
- Re: [HACKERS] Hot Standby utility and administrator functions
- From: Simon Riggs
- Re: [GENERAL] [HACKERS] Hot Standby utility and administrator functions
- From: Alvaro Herrera
- Hot Standby utility and administrator functions
- Prev by Date: Re: [GENERAL] [HACKERS] Hot Standby utility and administrator functions
- Next by Date: Re: extending functionality strategy
- Previous by thread: Re: [GENERAL] [HACKERS] Hot Standby utility and administrator functions
- Next by thread: Re: [GENERAL] [HACKERS] Hot Standby utility and administrator functions
- Indexes: