dbsync_app.collect_local_pkeys()

Collect local primary keys for a set of tables.

Syntax

FUNCTION collect_local_pkeys() RETURNS INTEGER
Returns:
  1. The status.

Usage

Use this function in DB Sync client app code to build the list of primary keys existing locally. These will be sent to the server to check which rows are still valid and which can be deleted.

The current schema must have been loaded with register_local_dbschema().

The list of tables must have been registered with register_local_tables().