Determines which columns are used to comprise the keyset that the driver uses to create the initial keyset on which cursor operations are based. PostgreSQL does not offer a true row identifier column; the driver instead uses a hidden system column provided by the PostgreSQL database, ctid. Because the database might reassign the ID following a Vacuum operation, the driver can be configured to also include other columns to help ensure that data integrity is maintained.
Valid Values
0 | 1
Behavior
If set to 1 - RowID and Searchable Columns (Enabled), the driver uses a combination of every non-LOB column in the Select list and the ctid ahidden column to build the keyset. By adding other Select list fields to the keyset, the driver is able to indicate the row cannot be found if the IDs change following a Vacuum operation.
If set to 0 - RowID Columns (Disabled), the driver uses the ctid hidden system column.
Notes
This option has no effect unless the EnableKeysetCursors (EKC) connection option is enabled.
This option has no effect unless the EnableKeysetCursors (EKC) connection option is enabled.