hasura/graphql-engine
Ver no GitHubattempting to add a default value to a column used by a view results in an error
Open
#3.224 aberto em 24 de out. de 2019
a/data/postgresc/consolee/easyhelp wantedk/bugp/high
Métricas do repositório
- Stars
- (31.371 stars)
- Métricas de merge de PR
- (Nenhuma PRs mesclada em 30d)
Description
Via the console, attempting to add a default value to a column which is used by a postgres view results in the following error:
Modifying Column Failed:
postgres-error: cannot alter type of a column used by a view or rule
Note, we are not changing the column type, we are simply adding a default value. Performing the same operation directly on the database works as expected.
i.e.
alter table "UserProfilePermissions" alter column "emailAddresses" set default 'false';