Xata•2mo ago

i seem to be unable to run this query in the dashboard ```sql ALTER TABLE cards ADD COLUMN "index"

i seem to be unable to run this query in the dashboard

ALTER TABLE cards ADD COLUMN "index" SERIAL PRIMARY KEY;

ALTER TABLE cards ADD COLUMN "index" SERIAL PRIMARY KEY;

Error: invalid SQL: unsupported statement [ALTER TABLE] on strict level, see https://xata.io/sql-support for the support matrix

Connect to Postgres

Learn how to connect to Postgres directly via the wire protocol

6 Replies

Unknown User•3w ago

Message Not Public

Kaligraphy•3w ago

Hi everyone, looks like the files field in the database are no longer available both via the Xata UI and the CLI The workspaces I am working on, are all pro but my account itself isn’t pro, could this be the issue?

Unknown User•3w ago

Message Not Public

brownfox.dev•2w ago

Hey @tsg, do you know if xata creates views from the actual db schema? We run migrations from kysely and everything seemed to be working, but now I'm not able to drop table after few days as there's view (whole new schema) that blocks me in doing migration rollback.

tsg•2w ago

what error do you get exactly? Can you send me (private via support portal is ok) your workspace id and DB:branch name, I can look into it. Because we do use views, but it depends on exactly the type of the DB (if Postgres native or not)

Unknown User•2w ago

Message Not Public

Gaming

Programming

i seem to be unable to run this query in the dashboard ```sql ALTER TABLE cards ADD COLUMN "index"

Did you find this page helpful?