Re: wal archiving on a hot-standby server

On 11/22/11 1:51 AM, Enrico Sirola wrote:
> create or replace function current_xlog_bytes()
> returns int8
> as
> $$
>     select cast(cast( 'x' || lpad(split_part(
>                                   pg_current_xlog_location(), '/', 1),
>                                   8, '0')
>                      as bit(32))
>                 as int8) * 16*1024*1024*254 +
>            cast(cast( 'x' || lpad(split_part(
>                                   pg_current_xlog_location(), '/', 2),
>                                   8, '0')
>                      as bit(32))
>                 as int8)
> $$
> language sql immutable strict;
>
> Any comment?

I don't believe that function is immutable, since it depends on the
value of pg_current_xlog_location() which will change over time.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast