attempting to add a default value to a column used by a view results in an error · hasura/graphql-engine#3224

(3 comments) (0 reactions) (1 assignee)TypeScript (31,371 stars) (2,787 forks)batch import

a/data/postgresc/consolee/easyhelp wantedk/bugp/high

説明

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';

コントリビューターガイド

技術スタック: typescriptpostgresqlgraphql
領域: backenddatabase
Issue 種別: bug
難度: 4
推定時間: half day
活動状況: blocked
明確さ: clear
前提条件: PostgreSQL basicsHasura console usageUnderstanding of database views
初心者向け度: 30
調査方針: Investigate the Hasura console's migration logic for altering column defaults. The error occurs because the console's SQL command attempts to alter the column type even when only adding a default value. Compare with the direct SQL that works. Look at the relevant code in the Hasura graphql engine repository, specifically in the console's migration or schema management modules.