Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Fix typo in pg_dumpall role comments fix
authorDaniel Gustafsson <dgustafsson@postgresql.org>
Fri, 22 Mar 2024 00:01:30 +0000 (01:01 +0100)
committerDaniel Gustafsson <dgustafsson@postgresql.org>
Fri, 22 Mar 2024 00:01:30 +0000 (01:01 +0100)
Some last minute polish of the patch managed to break the SQL
query for extracting the role comments due to fat-fingering.

Per the buildfarm Xversion tests.

src/bin/pg_dump/pg_dumpall.c

index afda9a316026749201f37c8c9ebf940362313ec4..1cf8d20829e3ae667003570ba01e7e67dbc8ab5f 100644 (file)
@@ -786,7 +786,7 @@ dumpRoles(PGconn *conn)
                          "rolcanlogin, rolconnlimit, rolpassword, "
                          "rolvaliduntil, rolreplication, "
                          "false as rolbypassrls, "
-                         "pg_catalog.shobj_description(oid, pg_authid') as rolcomment, "
+                         "pg_catalog.shobj_description(oid, 'pg_authid') as rolcomment, "
                          "rolname = current_user AS is_current_user "
                          "FROM %s "
                          "ORDER BY 2", role_catalog);