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.
Thank you!