[Bug]: create extension pgaudit is failed

[killerwzb]

What happened?

If I create the pgaudit plugin first, I cannot create the babelfish_tds plugin; and vice versa.

Version

BABEL_4_X_DEV (Default)

Extension

None

Which flavor of Linux are you using when you see the bug?

No response

Relevant log output

No response

Code of Conduct

• I agree to follow this project's Code of Conduct.

[tanscorpio7]

What is the error you are getting ?
I am able install pgaudit after install babelfish extensions on the tip of BABEL_4_X_DEV branch.

[rishabhtanwar29]

@killerwzb Can you please put down the exact steps you have tried so that we can reproduce this on our side, so far I am not able to reproduce this issue.

[killerwzb]

I am using Babelfish version 4.1 and need to use the pgAudit plugin. When I first execute create extension babelfishpg_tds cascade on port 5432 and successfully create the extension, I then try to execute create extension pgaudit, but it returns an error saying that the schema cannot be found. However, if I first execute create extension pgaudit, it succeeds, but if I try to execute create extension babelfishpg_tds afterward, it fails.

[tanscorpio7]

could you please try upgrading to babelfish v4.4 (postgres 16.6). There are several bug fixes related to pgaudit with babelfish in this version.