TABLE ADD KEY — Add primary key for use by Slony-I for a table with no suitable key
TABLE ADD KEY (options);
In the Slony-I replication system,
every replicated table is required to have at least one
UNIQUE
constraint whose columns are
declared NOT NULL.
Any primary key
satisfies this requirement.
As a last resort, this command can be used to add such an attribute to a table that does not have a primary key. Since this modification can have unwanted side effects, it is strongly recommended that users add a unique and not null attribute by other means.
NODE ID = ival
Node ID of the set origin where the table will be added as a set member. (See SET ADD TABLE.)
FULLY QUALIFIED NAME = 'string'
The full name of the table consisting of the schema
and table name as the SQL expression quote_ident(nspname)
|| '.' || quote_ident(relname)
would return it.
There is a limitation at present; you can create a
PostgreSQL table with no columns, as with create table
real_short ();
. Slony-I will refuse to handle such a
table. This isn't presently regarded as a serious limitation, as
we can't see there being terribly much interest in replicating
tables that contain no application data.
This uses schemadoctableaddkey( text ).