Provided by: slony1-2-doc_2.1.4-1ubuntu1_all bug

NAME

       DEFINE - Defining a named symbol

SYNOPSIS

       define [ name ] [ value ]

DESCRIPTION

       This  defines  a  named symbol. Symbol names must follow the slonik rules for constructing
       identifiers, by starting with a letter, followed by letters, numbers, and underscores.

       Symbol values may contain spaces and may recursively contain symbol references.

       Symbols are referenced by using a ‘@’ followed  by  the  symbol  name.  Note  that  symbol
       referencing is suppressed inside string literals.

EXAMPLE

       define    cluster movies;
       define    sakai   1;
       define    chen    2;
       define    fqn     fully qualified name;

       cluster name = @cluster;
       node @sakai admin conninfo = 'service=sakai-replication';
       node @chen  admin conninfo = 'service=chen-replication';
       define setMovies    id = 1;
       define sakaiMovies  @setMovies, origin = @sakai;

       create set ( @sakaiMovies, comment = 'movies' );

       set add table( set @sakaiMovies, id = 1, @fqn = 'public.customers',
                      comment = 'sakai customers' );
       set add table( set @sakaiMovies, id = 2, @fqn = 'public.tapes',
                      comment = 'sakai tapes' );
       echo 'But @sakaiMovies will display as a string, and is not expanded';

VERSION INFORMATION

       This command was introduced in Slony-I 1.1

                                         6 February 2014                         SLONIK DEFINE(7)