cmck

PostsComments

XXata

•Created by Michael Schaufelberger on 5/8/2025 in #help

Unable to start a pgroll migration using the Xata CLI

Sorry for the confusion, Michael, I got the versions wrong. The Xata CLI uses pgroll v0.7.0 and will stay on that. Support for constraints was added in v0.9.0

8 replies

XXata

•Created by Michael Schaufelberger on 5/8/2025 in #help

Unable to start a pgroll migration using the Xata CLI

Oh apologies you're dead right, I'm certain that the version in the Xata CLI is older but I must have got the version numbers mixed up, apologies 🤦‍♂️ let me double check this and get back to you.

8 replies

XXata

•Created by Michael Schaufelberger on 5/8/2025 in #help

Unable to start a pgroll migration using the Xata CLI

Hi Michael, thanks for bearing with me. Unfortunately the version of pgroll in the Xata CLI will stay at v0.11.1 for the foreseeable future. I appreciate this is a blocker for you and I apologise for any inconvenience caused. We are currently working on pgroll as a standalone tool that we will integrate also with our latest offering, coming soon. I'm afraid I can't provide much more detail, or offer an ETA, but you can stay up-to-date at https://xata.io/blog

8 replies

XXata

•Created by Michael Schaufelberger on 5/8/2025 in #help

Unable to start a pgroll migration using the Xata CLI

Yes exactly, the permissions required by the non-integrated pgroll tool won't allow it to be run with Xata. I appreciate this is a blocker so I'll bring it up with the team.

8 replies

XXata

•Created by Michael Schaufelberger on 5/8/2025 in #help

Unable to start a pgroll migration using the Xata CLI

Hi Michael, thanks for reaching out. You are correct regarding the Xata CLI not supporting the newest migration syntax of pgroll and that's likely the cause of the error. Support for constraints was added in v0.9.0 of pgroll. To the best of my knowledge, using pgroll directly with Xata won't work, unfortunately, but let me bring this to the team's attention and see if I can find a workaround.

8 replies

XXata

•Created by angelgce on 5/1/2025 in #help

COPY statement

Hey @angelgce , it looks like you're using SQL over HTTP which does not support the COPY statement as per https://xata.io/docs/postgres#supported-statements

4 replies

XXata

•Created by Michael Schaufelberger on 1/24/2025 in #help

Drizzle pull/push: Permission denied for view pg_stat_user_indexes

Thanks for the feedback, Michael, I've brought this to the team's attention. I'm afraid we don't have a fix at the moment for the drizzle introspection issue.

11 replies

XXata

•Created by brandon on 5/1/2025 in #help

Are indexes possible on free tier?

Hi! If your database is enabled for direct postgres access, then you can create indexes by connecting to the database via psql and running the statement there.

2 replies

XXata

•Created by Michael Schaufelberger on 4/29/2025 in #help

Is there a way to move files between branches?

Hi Michael, unfortunately, you're right, this is the only way to transfer the files between branches, to the best of my knowledge. I'll double-check with the team to see if there's a more efficient way. 👍

2 replies