`SET` and `current_setting` Usage in Xata
I'm exploring the possibility of migrating our application to Xata. However, I've encountered some issues with the
SET statement, set_config, and current_setting functions. We rely on these functions to pass additional session parameters (e.g., userid, tenantid, etc.) for RLS and auditing purposes. Have I overlooked something, or is this functionality simply unavailable in Xata? Thanks in advance!2 Replies
Hi @theres, are you connecting to a postgres-enabled database (in the Xata UI, you should see an elephant symbol next to the database name)?
Xata runs on AWS Aurora so setting some parameters at the session level may not be permitted.
Yes, it's pg-enabled. But for tests I've started with free version and it looks like I'd probably need to have the enterprise license for that. Thanks for the hints!