How to amend Aurora Postgres' parameter `babelfishpg_tsql.escape_hatch_rowversion` value from `strict` to `ignore`

0

Hi.

TL;DR: I'm trying to understand how to change the parameter babelfishpg_tsql.escape_hatch_rowversion values to ignore for all SQL sessions ran against the TDS port.


I'm using Aurora Postgres and would like to create a table with a column of type timestamp. By default, the parameter babelfishpg_tsql.escape_hatch_rowversion defined in the Babelfish Postgres extension babelfishpg_tsql is set to strict, thus running a script to create a table with a column of type timestamp against the TDS port returns an error like the following: error : To use the TIMESTAMP datatype, set 'babelfishpg_tsql.escape_hatch_rowversion' to 'ignore'.

Example of a Create Table script:

CREATE TABLE schema1.tablename1 (
  column1 timestamp NOT NULL,
)

I can change the parameter value against the Postgres port using the command SET babelfishpg_tsql.escape_hatch_rowversion TO 'ignore';, and against the TDS port using the command sp_babelfish_configure 'babelfishpg_tsql.escape_hatch_rowversion', 'ignore'.

When running the command sp_babelfish_configure 'babelfishpg_tsql.escape_hatch_rowversion', 'ignore' against the TDS port in SQL Server Management Studio, I can run the above-mentioned create table command on the same SQL session successfully.

The parameter value change, though, is limited to a single session. I wanted to change the parameter value in a custom Aurora cluster parameter group created based on the default parameter group named aurora-postgresql15, but the parameter did not exist in the parameter group.

Liroy
질문됨 8달 전291회 조회
1개 답변
0

To apply changes to the current session and on the cluster level, include the server keyword.

To set one or more escape hatches to the value specified, run sp_babelfish_configure ['hatch_name' [, 'strict'|'ignore' [, 'server']]. To make the settings permanent on a cluster-wide level, include the server keyword, such as shown in the following:

EXECUTE sp_babelfish_configure 'escape_hatch_unique_constraint', 'ignore', 'server'

To set them for the current session only, don't use server.

[+] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/babelfish-strict.html#babelfish-escape_hatches

AWS
지원 엔지니어
답변함 8달 전
profile pictureAWS
전문가
검토됨 8달 전
  • Thank you!

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인