postgres.git / summary / log / commit / refs

commit    58955c84f365ac629bc8a17931dc2ae45e35154c
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Sat Oct 16 19:02:55 2021 +0000
First released in: 15.0, 11.14, 12.9, 13.5, 14.1

    Avoid core dump in pg_dump when dumping from pre-8.3 server.
    
    Commit f0e21f2f6 missed adding a tgisinternal output column
    to getTriggers' query for pre-8.3 servers.  Back-patch to v11,
    like that commit.


 src/bin/pg_dump/pg_dump.c | 1 +
 1 file changed, 1 insertion(+)

diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c
index 975a16baf5d..542e8af4673 100644
--- a/src/bin/pg_dump/pg_dump.c
+++ b/src/bin/pg_dump/pg_dump.c
@@ -7673,6 +7673,7 @@ getTriggers(Archive *fout, TableInfo tblinfo[], int numTables)
 							  "SELECT tgname, "
 							  "tgfoid::pg_catalog.regproc AS tgfname, "
 							  "tgtype, tgnargs, tgargs, tgenabled, "
+							  "false as tgisinternal, "
 							  "tgisconstraint, tgconstrname, tgdeferrable, "
 							  "tgconstrrelid, tginitdeferred, tableoid, oid, "
 							  "tgconstrrelid::pg_catalog.regclass AS tgconstrrelname "


[parent: ca7a4ce5835a]