November
November
PostsComments
XXata
Created by November on 1/6/2025 in #help
Error: Out of Memory when creating a new sequence on pg-enabled DBs
No description
3 replies
XXata
Created by November on 1/5/2025 in #help
CLI/programmatic migrations for pg-enabled dbs
Hey all, I'm looking to try and test out xata, and want to be able to do some migrations programmatically So far, it looks like re-using my existing Flyway migrations is out (I can't just point it to the xata instance unless it's a dedicated instance), so I figured that pgroll CLI would be the way to go I know that pgroll is already built-in to the UI itself for managing, and prior questions seem to point to the UI (https://discord.com/channels/996791218879086662/1268594196474757121), but I was wondering if there was a way to get programmatic or externally-driven migrations working with xata- trying with: 
pgroll init --postgres-url <my xata connection string>
pgroll init --postgres-url <my xata connection string>
results in: 
ERROR   Failed to initialize pgroll: pq: unsupported statement [CREATE FUNCTION] on regular level, see https://xata.io/sql-support for the support matrix
Error: pq: unsupported statement [CREATE FUNCTION] on regular level, see https://xata.io/sql-support for the support matrix
ERROR   Failed to initialize pgroll: pq: unsupported statement [CREATE FUNCTION] on regular level, see https://xata.io/sql-support for the support matrix
Error: pq: unsupported statement [CREATE FUNCTION] on regular level, see https://xata.io/sql-support for the support matrix
2 replies