From 6f289c2b7d00f07f13f679092f7c71f78950e9da Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Wed, 19 Feb 2014 11:13:44 -0500 Subject: Switch various builtin functions to use pg_lsn instead of text. The functions in slotfuncs.c don't exist in any released version, but the changes to xlogfuncs.c represent backward-incompatibilities. Per discussion, we're hoping that the queries using these functions are few enough and simple enough that this won't cause too much breakage for users. Michael Paquier, reviewed by Andres Freund and further modified by me. --- doc/src/sgml/catalogs.sgml | 2 +- doc/src/sgml/func.sgml | 24 ++++++++++++------------ 2 files changed, 13 insertions(+), 13 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index dca24fc0705..908f947f81a 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -5244,7 +5244,7 @@ restart_lsn - text + pg_lsn The address (LSN) of oldest WAL which still might be required by the consumer of this slot and thus won't be diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index be548d79826..a6396620fe7 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -15884,35 +15884,35 @@ SELECT set_config('log_statement_stats', 'off', false); pg_create_restore_point(name text) - text + pg_lsn Create a named point for performing restore (restricted to superusers) pg_current_xlog_insert_location() - text + pg_lsn Get current transaction log insert location pg_current_xlog_location() - text + pg_lsn Get current transaction log write location pg_start_backup(label text , fast boolean ) - text + pg_lsn Prepare for performing on-line backup (restricted to superusers or replication roles) pg_stop_backup() - text + pg_lsn Finish performing on-line backup (restricted to superusers or replication roles) @@ -15933,26 +15933,26 @@ SELECT set_config('log_statement_stats', 'off', false); pg_switch_xlog() - text + pg_lsn Force switch to a new transaction log file (restricted to superusers) - pg_xlogfile_name(location text) + pg_xlogfile_name(location pg_lsn) text Convert transaction log location string to file name - pg_xlogfile_name_offset(location text) + pg_xlogfile_name_offset(location pg_lsn) text, integer Convert transaction log location string to file name and decimal byte offset within file - pg_xlog_location_diff(location text, location text) + pg_xlog_location_diff(location pg_lsn, location pg_lsn) numeric Calculate the difference between two transaction log locations @@ -16107,7 +16107,7 @@ postgres=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup()); pg_last_xlog_receive_location() - text + pg_lsn Get last transaction log location received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed this will @@ -16121,7 +16121,7 @@ postgres=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup()); pg_last_xlog_replay_location() - text + pg_lsn Get last transaction log location replayed during recovery. If recovery is still in progress this will increase monotonically. If recovery has completed then this value will remain static at @@ -16335,7 +16335,7 @@ postgres=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup()); pg_create_physical_replication_slot(slotname text, plugin text) - (slotname text, xlog_position text) + (slotname text, xlog_position pg_lsn) Creates a new physical replication slot named -- cgit v1.2.3