Updated on 2025-05-29 GMT+08:00

GS_SQLAPPLY_SKIP

GS_SQLAPPLY_SKIP records rules that can be skipped during logical replay.

Table 1 GS_SQLAPPLY_SKIP columns

Column

Type

Description

createtime

timestamp

Creation timestamp.

originid

int4

Replication source ID.

skiptype

int4

SKIP types:
  • 1: SKIP OBJ
  • 2: SKIP TXN
  • 3: SKIP ERR

dumpcontext

char

Dumps transactions to a file.
  • 'a': The entire transaction is dumped.
  • 'n': no dumping.
  • 's': Only changes skipped by the transaction are dumped.

param1

text

For details, see Table 2 and Table 3.

param2

text

For details, see Table 2 and Table 3.

param3

text

For details, see Table 2.

param4

text

For details, see Table 2.

param5

text

Reserved column.

Table 2 Columns of param1–4 in SKIP OBJ or SKIP ERR

Column

Type

Description

db_name

text

Database name.

schema_name

text

Schema name.

object_name

text

Object name.

stmt_type

text

SQL statement type.

Table 3 Columns of param1–2 in SKIP TXN

Column

Type

Description

csn

text

Transaction SN.

xid

text

Transaction ID.