Aurora Postgres Error: 39P02: table-function protocol for materialize mode was not followed

chris_ford2020

Has anyone got this error on Aurora Postgres 16.1 on RDS?

39P02: table-function protocol for materialize mode was not followed

I have followed the instructions, and I don't get why I'm getting this error.

Sujay

Hi Chris,

Thank you for reaching out.
We have observed this issue at times when the extension version of log_fdw was lower than 1.3

It would help to check if this is the case.
If so, the version of log_fdw can be updated using the below command:

ALTER EXTENSION log_fdw UPDATE;

Please let us know if this helps.

Regards,
Sujay

chris_ford2020

I ran this and I got back:

version "1.3" of extension "log_fdw" is already installed