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.
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.