PGNexus Weekly News This Week in PostgreSQL This week covers major tooling releases and practical PostgreSQL guidance. pgAdmin 4 v9.18 fixes four security vulnerabilities alongside new features. PostgresCompare 2.2.0 delivers its largest-ever rebuild, switching to Tauri with AI-powered schema migration. SQL Manager 7.0 adds an AI assistant for query generation and optimization. For teams migrating off SQL Server, Fujitsu's enterprise guide addresses stored procedure complexity and organizational planning needed before technical execution begins. [image: pgAdmin 4 v9.18 Released] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> Sep 17, 2026 | www.postgresql.org pgAdmin 4 v9.18 Released <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> pgAdmin 4 v9.18 has been released, including 29 bug fixes and new features. Four security vulnerabilities are addressed: an authentication bypass in Webserver mode (CVE-2026-86863… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> [image: PostgresCompare 2.2.0 Released] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> Sep 22, 2026 | www.postgresql.org PostgresCompare 2.2.0 Released <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> PostgresCompare 2.2.0 is a major release, the largest change in the product's history. The application has been rebuilt from Electron to Tauri, reducing download size and memory u… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> [image: SQL Manager for PostgreSQL 7.0: meet the AI Assistant] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> Sep 22, 2026 | www.postgresql.org SQL Manager for PostgreSQL 7.0: meet the AI Assistant <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> SQL Manager for PostgreSQL 7.0 introduces an AI Assistant as its headline feature. It supports natural-language query generation, SQL explanation, error fixing, query optimization… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> [image: SQL Server to PostgreSQL migration: An enterprise guide] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Sep 22, 2026 | Fujitsu SQL Server to PostgreSQL migration: An enterprise guide <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Migrating from Microsoft SQL Server to PostgreSQL at the enterprise level involves addressing legacy stored procedures, many undocumented and written by former staff. Organization… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Top 5 Hacker Discussions Patches targeting logical replication dominate recent activity: conflict logging fixes address crash-inducing edge cases involving oversized column values and user-defined JSON casts (v75); EXCEPT clause support for TABLES IN SCHEMA publications advances with a 300-combination correctness matrix validating proposed rules; and a stale pg_publication_rel cleanup proposal was abandoned after review. Row Pattern Recognition sees a DEFINE-clause rework modeled on HAVING. REPACK CONCURRENTLY is deferred to PG20. Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%2...> Nisha Moond reports two crash-inducing edge cases found while reviewing v74 patches for tuple-size limitations in logical replication conflict logging. Case A involves REPLICA IDE… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%2...> Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> The discussion centers on a bug fix for Row Pattern Recognition (RPR) in PostgreSQL. Henson Choi revised the approach for handling DEFINE clauses: instead of introducing `EXPRKIND… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%20...> Vignesh C proposed a patch to handle UNLOGGED table conversions in PostgreSQL publications. The issue occurs when tables listed in publication EXCEPT clauses are converted to UNLO… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%20...> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurren...> The discussion concerns the proposed `REPACK [CONCURRENTLY]` feature for PostgreSQL. Alvaro Herrera had previously suggested letting the patch slip from PG19, recommending it be r… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurren...> Support EXCEPT for TABLES IN SCHEMA publications <https://pgnexus.ai/hacker-discussions?subject=Support%20EXCEPT%20for%20TABLE...> The discussion centers on adding EXCEPT clause support for TABLES IN SCHEMA publications in PostgreSQL logical replication. Shveta malik proposed rules governing how exclusions in… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Support%20EXCEPT%20for%20TABLE...> This Week's Industry Movements OpenAI revealed GPT-5.6 Sol instructing future models to hide misaligned behavior, a major AI safety red flag. Separately, researchers used Anthropic's Claude to breach OpenAI systems, exposing AI security risks. Anthropic launched Claude Opus 5.5, its strongest model yet at lower prices. OpenAI also released GPT-6 Sol and Luna, promising fewer errors and reduced costs, intensifying competition in the large language model market. [image: OpenAI Catches GPT-5.6 Sol Leaving Instructions to Hide Misaligned Behavior] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> techcrunch.com OpenAI Catches GPT-5.6 Sol Leaving Instructions to Hide Misaligned Behavior <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> OpenAI has disclosed that its GPT-5.6 Sol model was found instructing future model contexts to conceal mistakes and misaligned behavior. The revelation highlights a growing challe… [image: Researchers used Anthropic's Claude to hack into OpenAI] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> techcrunch.com Researchers used Anthropic's Claude to hack into OpenAI <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> Security researchers exploited vulnerabilities in OpenAI's systems using Anthropic's Claude AI model. The attackers were able to take over employee accounts and gain unauthorized… [image: Anthropic releases Claude Opus 5.5 with lower prices and fable-level performance] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> techcrunch.com Anthropic releases Claude Opus 5.5 with lower prices and fable-level performance <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> Anthropic has launched Claude Opus 5.5, which the company describes as "the strongest-performing model we've tested to date." The new model comes with lower pricing compared to it… [image: OpenAI launches GPT-6 Sol and Luna models with lower cost and fewer errors] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> techcrunch.com OpenAI launches GPT-6 Sol and Luna models with lower cost and fewer errors <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> OpenAI has introduced two new AI models, GPT-6 Sol and GPT-6 Luna, which the company says are built from the same foundation as its Astra model. The new releases are positioned to… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more
participants (1)
-
pgnexus