VSI-AXPVMS-LIBPQ-V1100-0B-1-RELNOTE.PDF

This document describes the LIBPQ kit for OpenVMS Alpha, which provides the PostgreSQL 11.0 client API, ECPG embedded SQL pre-processor, and PSQL interactive query tool. A key improvement, provided by Sector7, addresses OpenVMS argument limit issues, enabling queries that return large numbers of columns and null-indicator values.

Key Information:

• Components: LIBPQ PostgreSQL client API, ECPG embedded SQL pre-processor, and PSQL interactive query tool, based on PostgreSQL 11.0.
• Requirements: OpenVMS V8.4-2L1 Alpha, HP TCP/IP Services V5.7 ECO 2 (MultiNet may also work), and VSI C V7.4-002 compiler. Users should be familiar with OpenVMS and PostgreSQL client API.
• Installation: Installed via an OpenVMS PCSI kit using PRODUCT INSTALL LIBPQ. Post-installation, specific commands must be added to SYS$MANAGER:SYSTARTUP_VMS.COM and SYSSMANAGER:SYSHUTDWN.COM for runtime startup/shutdown.
• Development & Linking: The kit defines logical names LIBPQ$ROOT and LIBPQ$SHR (for the shareable image LIBPQ$SHR.EXE). Developers must use the /NAMES=(AS_IS) compiler option for mixed-case symbols and ensure all linked code uses G_FLOAT floating-point format to avoid issues. Sample applications are provided.
• Resource Considerations: No special privileges are required, but a reasonably high BYTLM quota is recommended, along with other specified system quotas.
• Alternative Installation: Installation to a non-default location using /DESTINATION requires manually copying startup/shutdown procedures.
• Current/Future Scope: The current kit includes all supported C/C++ functionality; future releases may add wrapper APIs for other languages.
• Usage Tip: For ECPG and PSQL tools, set process parse style to "extended" or enclose command-line arguments in double quotes for correct parsing.