From 6ba621aaeb88f301a752e8813e4af8964f346829 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Tue, 17 Apr 2012 18:04:45 -0400 Subject: [PATCH] Don't use variable names when a column name already exists - some versions of plpgsql will get confused. --- bucardo.schema | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/bucardo.schema b/bucardo.schema index 2e6245dc6..ff9ad8248 100644 --- a/bucardo.schema +++ b/bucardo.schema @@ -1532,26 +1532,26 @@ END; SECURITY DEFINER AS \$clone\$ DECLARE - tname TEXT; + tablename TEXT; myst TEXT; BEGIN INSERT INTO bucardo.bucardo_truncate_trigger(tablename,sname,tname,sync) VALUES (TG_RELID, TG_TABLE_SCHEMA, TG_TABLE_NAME, TG_ARGV[0]); - SELECT INTO tname + SELECT INTO tablename bucardo.bucardo_tablename_maker(TG_TABLE_SCHEMA || '.' || TG_TABLE_NAME, 'delta_'); - myst = 'TRUNCATE TABLE bucardo.' || tname; + myst = 'TRUNCATE TABLE bucardo.' || tablename; EXECUTE myst; - SELECT INTO tname + SELECT INTO tablename bucardo.bucardo_tablename_maker(TG_TABLE_SCHEMA || '.' || TG_TABLE_NAME, 'track_'); - myst = 'TRUNCATE TABLE bucardo.' || tname; + myst = 'TRUNCATE TABLE bucardo.' || tablename; EXECUTE myst; -- Not strictly necessary, but nice to have a clean slate - SELECT INTO tname + SELECT INTO tablename bucardo.bucardo_tablename_maker(TG_TABLE_SCHEMA || '.' || TG_TABLE_NAME, 'stage_'); - myst = 'TRUNCATE TABLE bucardo.' || tname; + myst = 'TRUNCATE TABLE bucardo.' || tablename; EXECUTE myst; RETURN NEW; -- 2.39.5