Horton

Reject invalid databases in pg_get_database_ddl()

Amit Langote <amitlan@postgresql.org>

View on postgr.es
Commit: cda0c4c5d6f581cddaa24cde02c583d1c8f5521d
Author: Amit Langote <amitlan@postgresql.org>
Date: 2026-04-17T04:19:56Z
Releases: 19 (unreleased) 
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.jhs@gmail.com>
Author: Lakshmi N <lakshmin.jhs@gmail.com>
Reviewed-by: Amit Langote <amitlangote09@gmail.com>
Reviewed-by: Euler Taveira <euler@eulerto.com>
Reviewed-by: Hu Xunqi <huxunqi.08@gmail.com>
Discussion: https://postgr.es/m/CA+3i_M8m1k2gFch+tU0JmAQh9FRV+pFrfTXDrJo+BqmwsTmOhg@mail.gmail.com

Files

PathChange+/−
src/backend/utils/adt/ddlutils.c modified +10 −0

Discussion