How can we help you today? How can we help you today?

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

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.
chris_ford2020
0

Comments

2 comments

  • 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
    Sujay
    0
  • chris_ford2020
    I ran this and I got back:

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

Add comment

Please sign in to leave a comment.