pgsql: Reject invalid databases in pg_get_database_ddl()

From: Amit Langote <amitlan(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Reject invalid databases in pg_get_database_ddl()
Date: 2026-04-17 04:21:56
Message-ID: E1wDaiK-001M3A-0W@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Reject invalid databases in pg_get_database_ddl()

An invalid database has datconnlimit set to -2. pg_get_database_ddl()
emits this verbatim as CONNECTION LIMIT = -2, which ALTER DATABASE
rejects. Error out early instead.

Reported-by: Lakshmi N <lakshmin(dot)jhs(at)gmail(dot)com>
Author: Lakshmi N <lakshmin(dot)jhs(at)gmail(dot)com>
Reviewed-by: Amit Langote <amitlangote09(at)gmail(dot)com>
Reviewed-by: Euler Taveira <euler(at)eulerto(dot)com>
Reviewed-by: Hu Xunqi <huxunqi(dot)08(at)gmail(dot)com>
Discussion: https://postgr.es/m/CA+3i_M8m1k2gFch+tU0JmAQh9FRV+pFrfTXDrJo+BqmwsTmOhg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/cda0c4c5d6f581cddaa24cde02c583d1c8f5521d

Modified Files
--------------
src/backend/utils/adt/ddlutils.c | 10 ++++++++++
1 file changed, 10 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Fujii Masao 2026-04-17 05:31:50 pgsql: psql: Fix incorrect tab completion after CREATE PUBLICATION ...
Previous Message Bruce Momjian 2026-04-16 21:24:16 pgsql: doc PG 19 relnotes: change "free space map" to "visibility map"