diff options
| -rw-r--r-- | sql/dawn.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index a72b8f92..320c401c 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -372,7 +372,7 @@ CREATE OR REPLACE FUNCTION auto_dealid() DECLARE stub text; sqlstr text; BEGIN - sqlstr:= 'UPDATE '|| TG_TABLE_NAME ||' SET %s WHERE id = %L AND dealid is NULL'; + sqlstr:= format('UPDATE '|| TG_TABLE_SCHEMA ||'.' ||TG_TABLE_NAME || ' SET %s WHERE id = %L AND dealid is NULL'; IF (TG_TABLE_NAME = 'bonds') THEN stub := 'SC_'; |