pg_repack.git / summary / log / commit / refs

commit    bc20ace32bfa17b06339db1fb0355663149625a3
Author:   Josh Kupershmidt <schmiddy@gmail.com>
Commit:   Daniele Varrazzo <daniele.varrazzo@gmail.com>
Date:     Wed Sep 19 03:13:21 2012 +0000

    Use quote_identifier() to properly escape column names in UPDATE statement, per report from Dimitrije Radojevic.


lib/pg_reorg.sql.in | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/pg_reorg.sql.in b/lib/pg_reorg.sql.in index b836130..97146ac 100755 --- a/lib/pg_reorg.sql.in +++ b/lib/pg_reorg.sql.in @@ -80,7 +80,7 @@ LANGUAGE sql STABLE STRICT; CREATE FUNCTION reorg.get_assign(oid, text) RETURNS text AS $$ - SELECT '(' || array_to_string(reorg.array_accum(attname), ', ') || + SELECT '(' || array_to_string(reorg.array_accum(quote_ident(attname)), ', ') || ') = (' || $2 || '.' || array_to_string(reorg.array_accum(quote_ident(attname)), ', ' || $2 || '.') || ')' FROM (SELECT attname FROM pg_attribute [parent: 612495ecd662]