no such column exists for PostgreSQL db in Hasura (Graphql) console when adding column via DBeaver

Question

I just tested modifying a table in my PostgreSQL db through DBeaver and it seems to have broken the db when looking at the data from the Hasura (Graphql) console. I simply added a column from Dbeaver. In Hasura I get an error "no such column exists". Anyone have any idea why or how I can fix this?

question from:https://stackoverflow.com/questions/65649383/no-such-column-exists-for-postgresql-db-in-hasura-graphql-console-when-adding

Answer 1

Hasura support helped me pinpoint it to the metadata stored in the Graphql console. Hope this helps someone else save a little time.

"If you make DDL changes to your database from outside Hasura, you must manually reload the Hasura metadata so that Hasura knows that something has changed and it adapts to those changes accordingly.You can reload the metadata by clicking on the settings icon on the top right in console."