hasura / hasura/graphql-engine

Saving column metadata on table with event triggers fails with database query error

Open
#8,418 1 comment 0 reactions 0 assignees View on GitHub
a/eventing/data-triggers k/bug
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

### Version Information

Server Version: 2.5.0
CLI Version (for CLI related issue): 2.5.0

### Environment

Docker image

### What is the expected behaviour?

Should be able to save column metadata, e.g. custom column names

This was working okay on 2.4.0, updating to 2.5.0 causes the issue in existing projects

### Keywords

custom column names, metadata

### What is the current behaviour?

When saving metadata for a column on a table that has an event trigger in the Hasura console, the action fails with:

```json
{
"exec_status": "FatalError",
"hint": null,
"message": "must be owner of relation {tableName}",
"status_code": "42501",
"description": null
}
```

### How to reproduce the issue?

1. Have a tracked table with an existing event trigger on it
2. In the console, modify tab, attempt to save a custom column name

### If the bug is confirmed, would you be willing to submit a PR?

Sure

Contributor guide

Open the contributing guide

Research direction

Reproduce the failure in the Hasura console using a tracked table with an existing event trigger, then modify a column and save a custom column name. Start with the database error showing that ownership of the relation is required. Done means metadata saves successfully on affected tables, including existing projects upgraded from 2.4.0.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgres
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.