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

chris_ford2020chris_ford2020 Posts: 9 Bronze 1
in Redgate Monitor
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.
Tagged:
· Share on Twitter

Answers

  • SujaySujay Posts: 53 Bronze 3
    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 Diwan| Product Support Engineer | Redgate Software
    · Share on Twitter
  • chris_ford2020chris_ford2020 Posts: 9 Bronze 1
    I ran this and I got back:

    version "1.3" of extension "log_fdw" is already installed
    · Share on Twitter
Sign In or Register to comment.