Documentation
 
 
 

TABLE ADD KEY

Name

TABLE ADD KEY --  Add primary key for use by edb-async-replic for a table with no suitable key

Synopsis

TABLE ADD KEY (options);

Description

In the edb-async-replic 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.

Example

     TABLE ADD KEY ( NODE ID = 1, 
     FULLY QUALIFIED NAME = 'public.history' );
    
 
 ©2004-2007 EnterpriseDB All Rights Reserved