Ungrouped configuration parameters v18

These configuration parameters apply only to EDB Postgres Advanced Server and are for a specific, limited purpose.

nls_length_semantics

Parameter type: Enum

Default value: byte

Range: {byte | char}

Minimum scope of effect: Per session

When value changes take effect: Immediate

Required authorization to activate: Superuser

This parameter has no effect in EDB Postgres Advanced Server. For example, this form of the ALTER SESSION command is accepted in EDB Postgres Advanced Server without throwing a syntax error. However, it doesn't alter the session environment.

ALTER SESSION SET nls_length_semantics = char;

query_rewrite_enabled

Parameter type: Enum

Default value: false

Range: {true | false | force}

Minimum scope of effect: Per session

When value changes take effect: Immediate

Required authorization to activate: Session user

This parameter has no effect in EDB Postgres Advanced Server. For example, this form of the ALTER SESSION command is accepted in EDB Postgres Advanced Server without throwing a syntax error. However, it doesn't alter the session environment.

ALTER SESSION SET query_rewrite_enabled = force;

query_rewrite_integrity

Parameter type: Enum

Default value: enforced

Range: {enforced | trusted | stale_tolerated}

Minimum scope of effect: Per session

When value changes take effect: Immediate

Required authorization to activate: Superuser

This parameter has no effect in EDB Postgres Advanced Server. For example, this form of the ALTER SESSION command is accepted in EDB Postgres Advanced Server without throwing a syntax error. However, it doesn't alter the session environment.

ALTER SESSION SET query_rewrite_integrity = stale_tolerated;