-- fail because of an invalid name

SELECT 'init' FROM pg_create_logical_replication_slot('Invalid Name', 'test_decoding');

ERROR: replication slot name "Invalid Name" contains invalid character

HINT: Replication slot names may only contain letters, numbers, and the underscore character.

HINT: Replication slot names may only containlower caseletters, numbers, and the underscore character.

-- fail twice because of an invalid parameter values

SELECT 'init' FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', 'frakbar');

ERROR: could not parse value "frakbar" for parameter "include-xids"

(errcode(ERRCODE_INVALID_NAME),

errmsg("replication slot name \"%s\" contains invalid character",

name),

errhint("Replication slot names may only contain letters, numbers, and the underscore character.")));

errhint("Replication slot names may only containlower caseletters, numbers, and the underscore character.")));

return false;

}

}