postgres.git / summary / log / commit / refs

commit    09397f0ed6c4fd3b76658058e4e914b80a509237
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Fri Oct 19 04:50:17 2018 +0000
First released in: 12.0, 10.6, 11.1

    Add missing quote_identifier calls for CREATE TRIGGER ... REFERENCING.
    
    Mixed-case names for transition tables weren't dumped correctly.
    Oversight in commit 8c48375e5, per bug #15440 from Karl Czajkowski.
    
    In passing, I couldn't resist a bit of code beautification.
    
    Back-patch to v10 where this was introduced.
    
    Discussion: https://postgr.es/m/15440-02d1468e94d63d76@postgresql.org


 src/backend/utils/adt/ruleutils.c | 10 ++++++----
 1 file changed, 6 insertions(+), 4 deletions(-)

diff --git a/src/backend/utils/adt/ruleutils.c b/src/backend/utils/adt/ruleutils.c
index da07fbd7251..1264b966c63 100644
--- a/src/backend/utils/adt/ruleutils.c
+++ b/src/backend/utils/adt/ruleutils.c
@@ -952,22 +952,24 @@ pg_get_triggerdef_worker(Oid trigid, bool pretty)
 	value = fastgetattr(ht_trig, Anum_pg_trigger_tgoldtable,
 						tgrel->rd_att, &isnull);
 	if (!isnull)
-		tgoldtable = NameStr(*((NameData *) DatumGetPointer(value)));
+		tgoldtable = NameStr(*DatumGetName(value));
 	else
 		tgoldtable = NULL;
 	value = fastgetattr(ht_trig, Anum_pg_trigger_tgnewtable,
 						tgrel->rd_att, &isnull);
 	if (!isnull)
-		tgnewtable = NameStr(*((NameData *) DatumGetPointer(value)));
+		tgnewtable = NameStr(*DatumGetName(value));
 	else
 		tgnewtable = NULL;
 	if (tgoldtable != NULL || tgnewtable != NULL)
 	{
 		appendStringInfoString(&buf, "REFERENCING ");
 		if (tgoldtable != NULL)
-			appendStringInfo(&buf, "OLD TABLE AS %s ", tgoldtable);
+			appendStringInfo(&buf, "OLD TABLE AS %s ",
+							 quote_identifier(tgoldtable));
 		if (tgnewtable != NULL)
-			appendStringInfo(&buf, "NEW TABLE AS %s ", tgnewtable);
+			appendStringInfo(&buf, "NEW TABLE AS %s ",
+							 quote_identifier(tgnewtable));
 	}
 
 	if (TRIGGER_FOR_ROW(trigrec->tgtype))


[parent: 34f9944c207f]