这是indexloc提供的服务,不要输入任何密码
Skip to content

"INSERT has more expressions than target ..." after removed a column from the table #1991

@timgreen

Description

@timgreen

Version: v1.0.0-alpha42

What I did

  1. Remove a column from the table

What I found

The insert mutation stop working use error message: "INSERT has more expressions than target ..."

Details

  • The column deletion was done via hasura console web UI.
  • The column I removed is nullable and it is not in the allow column in insert permission so the default value has been used before.
  • I check the statement caused the error from the postgres log. The statement generate by hasura still have the DEFAULT in the values (...) for the removed column.

My Current Workaround

  1. Make some change on allow columns in insert permission, save it
  2. Reverse the change and save again

Now the insert mutation can go through again.

Metadata

Metadata

Assignees

Labels

c/serverRelated to serverk/bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions