alter table "foo" alter column "bar" type bigint using ("bar"::bigint);
And the error
alter table "foo" alter column "bar" type bigint using ("bar"::bigint) - 💔 Your query failed to parse.
rig-data:test:dev: This is most likely due to a SQL syntax error.
alter table "foo" alter column "bar" type bigint using ("bar"::bigint);
^
Unexpected kw_using token: "using". Instead, I was expecting to see one of the following:
- A "dot" token
- A "lparen" token
- A "kw_array" token
- A "lbracket" token
- A "comma" token
- A "semicolon" token
Describe the bug
Knex has the following migration code
This generates the SQL
And the error
Looking at the Postgres docs that is valid syntax