Commit0717f2f

committed

Fix ALTER COLLATION "default" REFRESH VERSION.

Issue a helpful error message rather than an internal error.Discussion:https://postgr.es/m/51fb77507cafd43fc1a2e733c23045873d93ae60.camel%40j-davis.comReviewed-by: Thomas Munro

1 parent10932ed commit0717f2fCopy full SHA for 0717f2f

File tree

-0

lines changed

-0

lines changed

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -366,6 +366,11 @@ AlterCollation(AlterCollationStmt *stmt)`
`366`	`366`	`rel=table_open(CollationRelationId,RowExclusiveLock);`
`367`	`367`	`collOid=get_collation_oid(stmt->collname, false);`
`368`	`368`
	`369`	`+if (collOid==DEFAULT_COLLATION_OID)`
	`370`	`+ereport(ERROR,`
	`371`	`+(errmsg("cannot refresh version of default collation"),`
	`372`	`+errhint("Use ALTER DATABASE ... REFRESH COLLATION VERSION instead.")));`
	`373`	`+`
`369`	`374`	`if (!pg_collation_ownercheck(collOid,GetUserId()))`
`370`	`375`	`aclcheck_error(ACLCHECK_NOT_OWNER,OBJECT_COLLATION,`
`371`	`376`	`NameListToString(stmt->collname));`

Comments

(0)