Postgresql rename column

[danimontoya]

Using sqldelight with postgres I'm trying to rename a column of table:
2.sqm:

ALTER TABLE technologyEntity
    RENAME COLUMN keywords TO tags;

that is valid in postgresql but I'm getting this error:
Error Reading 2.sqm:

../entertainment/migrations/2.sqm line 2:11 - TO expected, got 'COLUMN'
1    ALTER TABLE technologyEntity
2        RENAME COLUMN keywords TO tags
                ^^^^^^

and if I remove the keyword COLUMN I get the same error.. any hints? 🙏 thanks!

[pabl0rg]

Thanks for the release!

Unfortunately now that I tried to use this with my codebase I got this error in the first query in my .sq file that inserts into the renamed column.

  > Failed to compile /builds/kkmmkk/kotlin/catalog/src/main/sqldelight/a/b/c/Table.sq:197:
       VALUES (:id, :email, :verified)

In the IDE i can also see this:

Cause: sqldelight.com.alecstrong.sql.psi.core.psi.impl.SqlColumnAliasImpl incompatible with sqldelight.com.alecstrong.sql.psi.core.psi.SqlColumnName

[pabl0rg]

something similar happens when i rename a table. The error in CI seems random/wrong and the error in the IDE is:

Cannot get reference table for psi type class sqldelight.com.alecstrong.sql.psi.core.psi.impl.SqlNewTableNameImpl

[treitmaier]

I also got the same error when renaming a table as part of a sqlight migration on Android

CREATE TABLE New(
...
);

INSERT INTO New SELECT ... FROM Existing;
DROP TABLE Existing;
ALTER TABLE New RENAME TO Existing;

This resulted in the same error @pabl0rg mentioned:

Cannot get reference table for psi type class sqldelight.com.alecstrong.sql.psi.core.psi.impl.SqlNewTableNameImpl

However, if I changed the order of operations and renamed the existing table first, the error no longer occurs and the migration runs without problems.

ALTER TABLE Existing RENAME TO Old;
CREATE TABLE Existing(
...
);
INSERT INTO Existing SELECT ... FROM Old;
DROP TABLE Old;

Posting here in case it helps anyone experiencing this error.