Unable to add column named 'id'
M
Michael C
Adding a column named 'id' to a postgres db table doesn't seem to be possible through the web UI. The 'add column' button stays disabled. I was able to add it using an SQL command though. As the postgres db is automatically adding a 'xata_id' column instead of just 'id' (which used to be the case for the 'old' xata dbs I think?) I'm guessing it should be possible to have a manually configured 'id' column as well.
Kostas Botsas
Michael C You are right, this is a known temporary limitation which stems from xata_id being the replacement for "id" in non-Postgres Xata databases. This will be addressed on the road to GA, we plan to allow users to create id columns in the UI.
M
Michael C
Kostas Botsas Great to hear it's being addressed, and thanks for the update!