Re: pending patch: Re: Streaming replication and pg_xlogfile_name() - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: pending patch: Re: Streaming replication and pg_xlogfile_name()
Date
Msg-id z2x3f0b79eb1004061858n84ccb711pb56ff0e0be4911b5@mail.gmail.com
Whole thread Raw
In response to Re: pending patch: Re: Streaming replication and pg_xlogfile_name()  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: pending patch: Re: Streaming replication and pg_xlogfile_name()  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
On Tue, Apr 6, 2010 at 11:48 PM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
> Fujii Masao wrote:
>> On Tue, Apr 6, 2010 at 8:02 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
>>>> Should we throw an error in pg_xlogfile_name() if called during
>>>> recovery? It's not doing anything useful as it is.
>>> I have no objection for now.
>>
>> Here is the patch.
>> ...
>> +     if (RecoveryInProgress())
>> +             ereport(ERROR,
>> +                             (errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),
>> +                              errmsg("recovery is in progress"),
>> +                              errhint("WAL control functions cannot be executed during recovery.")));
>> +
>
> The hint is a bit confusing for pg_xlogfile_name(). pg_xlogfile_name()
> is hardly a WAL control function like pg_start/stop_backup() are. How
> about "pg_xlogfile_name() cannot be executed during recovery."?

OK. Here is the revised patch.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Attachment

pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: Use UNKNOWN with PL/Perl spi_prepare()?
Next
From: Fujii Masao
Date:
Subject: Re: Quoting in recovery.conf