pgai secrets exfiltration via `pull_request_target`

Vulnerability Description

pgai is a Python library that transforms PostgreSQL into a retrieval engine for RAG and Agentic applications. Prior to commit 8eb3567, the pgai repository was vulnerable to an attack allowing the exfiltration of all secrets used in one workflow. In particular, the GITHUB_TOKEN with write permissions for the repository, allowing an attacker to tamper with all aspects of the repository, including pushing arbitrary code and releases. This issue has been patched in commit 8eb3567.

References

• https://github.com/timescale/pgai/security/advisories/GHSA-89qq-hgvp-x37m
• https://github.com/timescale/pgai/pull/742
• https://github.com/timescale/pgai/commit/8eb356729c33560ce54b88b9a956960ad1e3ede8