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]