Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
pg_dump: Fix typo in query
authorPeter Eisentraut <peter_e@gmx.net>
Fri, 17 Feb 2017 20:06:28 +0000 (15:06 -0500)
committerPeter Eisentraut <peter_e@gmx.net>
Fri, 17 Feb 2017 20:06:28 +0000 (15:06 -0500)
This could lead to incorrect dumping of language privileges in some
cases, which is probably a rare situation.

src/bin/pg_dump/pg_dump.c

index 7364a12c25e09b97e40a7810589ef2cb97b1221e..746b7f8e8b657ba4b5b0c226ef927eb48b0bc48e 100644 (file)
@@ -7160,7 +7160,7 @@ getProcLangs(Archive *fout, int *numProcLangs)
                          "FROM pg_language l "
                          "LEFT JOIN pg_init_privs pip ON "
                          "(l.oid = pip.objoid "
-                         "AND pip.classoid = 'pg_type'::regclass "
+                         "AND pip.classoid = 'pg_language'::regclass "
                          "AND pip.objsubid = 0) "
                          "WHERE l.lanispl "
                          "ORDER BY l.oid",