RE: AIX support

Hi Team, (Peter/Heikki)

I have implemented the requested modifications in the latest patch. Below are the key technical updates:

• Meson Build Configuration: Adjusted below meson.build scripts to incorporate the suggested changes, ensuring proper dependency resolution and improved build consistency.

Removed the AIX changes in the below from the previous patch.

src/backend/jit/llvm/meson.build
src/backend/replication/libpqwalreceiver/meson.build
src/backend/replication/pgoutput/meson.build
src/backend/snowball/meson.build
src/backend/utils/mb/conversion_procs/meson.build

Added the static_library() changes.

> Regarding the archiving of shared and static libraries, the latest version of
> Meson raises a conflict as both targets have the same name. This issue
> arises because, on AIX, both shared and static libraries are named as same
> archive, which leads to naming collisions during the build process. We
> would still need the below changes.

src/interfaces/ecpg/compatlib/meson.build
src/interfaces/ecpg/ecpglib/meson.build
src/interfaces/ecpg/pgtypeslib/meson.build
src/interfaces/libpq/meson.build

• CFLAGS Optimization Removal: Removed high-level optimization flags from CFLAGS to prevent unpredictable behaviour and maintain stability during compilation.

I would greatly appreciate it if you could review the patch and share your feedback or any additional recommendations.

Apologies for the delayed response; I was occupied with other tasks.

Your insights are greatly appreciated and will help enhance the patch.

Warm regards,
-Sriram.