Flyway SET ROLE
Hi, has anyone used Flyway with Xata DB? Under the hood, when validate method is called, SET ROLE is used, and as I can see it is an unsupported statement: https://xata.io/docs/postgres#supported-statements
Connect to Postgres
Learn how to connect to Postgres directly via the wire protocol
2 Replies
Hi, as discussed in this thread (https://discord.com/channels/996791218879086662/996791219348852836/1250561354314813562) SET ROLE is indeed not supported by Xata, but maybe the initSql parameter in Flyway can be used to circumvent that statement.
hi, thanks, I will try