NAME

       UPDATE FUNCTIONS - Reload stored functions

SYNOPSIS

       UPDATE FUNCTIONS (options);

DESCRIPTION

       Reloads stored functions for a node.

       Reloads  all  stored  procedure  and  function  definitions  in the Slony-I schema for the
       specified node. This command is usually part of the Slony-I software upgrade procedure.

       ID = ival
              The node to refresh.

EXAMPLE

       UPDATE FUNCTIONS (
           ID = 3        # Update functions on node 3
       );

LOCKING BEHAVIOUR

       No application-visible locking should take place.

SLONIK EVENT CONFIRMATION BEHAVIOUR

       Slonik does not wait for event confirmations before performing this command.

VERSION INFORMATION

       This command was introduced in Slony-I 1.0

ODDITIES

       Any mismatch between slonik(1) and the C libraries ‘living’ in the PostgreSQL installation
       will  result in this failing to do what is expected, and, more than likely, failing to run
       at all. You may think you are upgrading to version 1.1.5, but if you are running slonik(1)
       from  version  1.1.2,  or if you didn't restart the database with a version that has 1.1.5
       libraries, and instead are referencing C stored functions from version 1.1.1, the  attempt
       to upgrade will fail, because the sets of C functions have regularly changed between major
       versions.

       Before  Slony-I  1.2,  the  error  messages  that  would  result  would  be  not  terribly
       informative; what you'd find, in PostgreSQL logs, is some error message about being unable
       to load some stored function that happens to be implemented in C. As of 1.2,  one  of  the
       first  things done is to load a stored function to verify version numbers; it complains in
       a much more direct fashion if you have some versioning mismatch.

                                         1 November 2021               SLONIK UPDATE FUNCTIONS(7)