Re: Postgresql 9.1 pg_last_xact_replay_timestamp limitations - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgresql 9.1 pg_last_xact_replay_timestamp limitations
Date
Msg-id 20406.1291839843@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgresql 9.1 pg_last_xact_replay_timestamp limitations  (Gabi Julien <gabi.julien@broadsign.com>)
List pgsql-general
Gabi Julien <gabi.julien@broadsign.com> writes:
> I just tried with postgresql 9.1alpha from http://www.enterprisedb.com/products/pgdevdownload.do (linux x86-32):
> postgres=# select pg_last_xact_replay_timestamp(), now() as not_modified_since;
> ERROR:  function pg_last_xact_replay_timestamp() does not exist
> LINE 1: select pg_last_xact_replay_timestamp(), now() as not_modifie...
>                ^
> HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

> A bug in the package?

No, only lack of a time machine.  That function was added on 2010-11-09
according to the git logs.  alpha2 froze at the end of October.

            regards, tom lane

pgsql-general by date:

Previous
From: Gabi Julien
Date:
Subject: Re: Postgresql 9.1 pg_last_xact_replay_timestamp limitations
Next
From: Simon Riggs
Date:
Subject: Re: Uncommitted Data