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 View on GitHub

@sharmay is already working on this.

Since Oct 29, 2025.

Assessment

This issue has not been assessed yet.

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;
Dominant language
C
Stars
1.1k
Forks
38
Avg merge
4d 14h
Merged PRs (30d)
1

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from aws/pgactive

All issues in aws/pgactive

Similar issues

More C issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.