aws / aws/pgactive

How can user update an extension to a different version when BDR is active on a node?

Open
#109 1 comment 0 reactions 1 assignee Claimed by @sharmay View on GitHub
Dominant language
C
Stars
1.1k
Forks
38
Avg merge
2d 21h
Merged PRs (30d)
4

Description

## Describe the problem

How can user update an extension to a different version when BDR is active on a node?

```
panda=# CREATE EXTENSION pg_buffercache WITH version '1.2';
CREATE EXTENSION
panda=# ALTER EXTENSION pg_buffercache UPDATE TO '1.3';
ERROR: ALTER EXTENSION is not supported when bdr is active
```

* What are you trying to solve?

On a BDR enabled node, blocking extension updates isn't a good idea IMO. At least, BDR must support ALTER EXTENSION name UPDATE [ TO new_version ], if not others like ALTER EXTENSION .... DROP FUNCTION ...;

```
case T_AlterExtensionStmt:
/* XXX: we could support some of these */
error_unsupported_command(GetCommandTagName(CreateCommandTag(parsetree)));
break;
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.