aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMichael Paquier <michael@paquier.xyz>2021-11-18 12:53:06 +0900
committerMichael Paquier <michael@paquier.xyz>2021-11-18 12:53:06 +0900
commit82bb97ed63cb206e8ecc0fe0d8bc3b8d2d336144 (patch)
tree635e801cd9392f5e51604b1252832cdd9502c130
parenta9993416f80f5d952cc392333011e4f7d399ec49 (diff)
downloadpostgresql-82bb97ed63cb206e8ecc0fe0d8bc3b8d2d336144.tar.gz
postgresql-82bb97ed63cb206e8ecc0fe0d8bc3b8d2d336144.zip
Fix quoting of ACL item in table for upgrade binary compatibility checks
Per buildfarm member prion, that runs the regression tests under a role name that uses a hyphen. Issue introduced by 835bcba. Discussion: https://postgr.es/m/YZW4MvzCZ+hQ34vw@paquier.xyz Backpatch-through: 12
-rw-r--r--src/test/regress/expected/type_sanity.out2
-rw-r--r--src/test/regress/sql/type_sanity.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/type_sanity.out b/src/test/regress/expected/type_sanity.out
index a7cc59c8b22..12764b52be8 100644
--- a/src/test/regress/expected/type_sanity.out
+++ b/src/test/regress/expected/type_sanity.out
@@ -668,7 +668,7 @@ CREATE TABLE tab_core_types AS SELECT
'abc'::refcursor,
'1 2'::int2vector,
'1 2'::oidvector,
- format('%s=UC/%s', USER, USER)::aclitem,
+ format('%I=UC/%I', USER, USER)::aclitem AS aclitem,
'a fat cat sat on a mat and ate a fat rat'::tsvector,
'fat & rat'::tsquery,
'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11'::uuid,
diff --git a/src/test/regress/sql/type_sanity.sql b/src/test/regress/sql/type_sanity.sql
index 1ffb7b4269b..a7d7a66ec0e 100644
--- a/src/test/regress/sql/type_sanity.sql
+++ b/src/test/regress/sql/type_sanity.sql
@@ -505,7 +505,7 @@ CREATE TABLE tab_core_types AS SELECT
'abc'::refcursor,
'1 2'::int2vector,
'1 2'::oidvector,
- format('%s=UC/%s', USER, USER)::aclitem,
+ format('%I=UC/%I', USER, USER)::aclitem AS aclitem,
'a fat cat sat on a mat and ate a fat rat'::tsvector,
'fat & rat'::tsquery,
'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11'::uuid,