From b1b8e28b27aea479064d4bad94dd85bd80a129a0 Mon Sep 17 00:00:00 2001 From: tgl Date: Tue, 7 Jul 2009 19:28:00 +0000 Subject: [PATCH] Query in SQL function still not schema-safe; add a couple more pg_catalog. qualifications. --- src/backend/catalog/information_schema.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql index 27a15c9c97..9b09937bcc 100644 --- a/src/backend/catalog/information_schema.sql +++ b/src/backend/catalog/information_schema.sql @@ -106,7 +106,8 @@ $$SELECT CASE WHEN $1 IN (25, 1042, 1043) /* text, char, varchar */ THEN CASE WHEN $2 = -1 /* default typmod */ THEN CAST(2^30 AS integer) - ELSE information_schema._pg_char_max_length($1, $2) * pg_catalog.pg_encoding_max_length((SELECT encoding FROM pg_database WHERE datname = current_database())) + ELSE information_schema._pg_char_max_length($1, $2) * + pg_catalog.pg_encoding_max_length((SELECT encoding FROM pg_catalog.pg_database WHERE datname = pg_catalog.current_database())) END ELSE null END$$; -- 2.11.4.GIT