diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2018-03-03 12:50:51 -0500 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2018-03-03 12:51:56 -0500 |
| commit | 39314efa4dd9101c18ef37067c3e114968a600a4 (patch) | |
| tree | a35217fd9d967d269db24ebacb0a2b4f894a750a /src | |
| parent | 8d90b4d01a6120aeaf61ede22dbdda0dd714b7dd (diff) | |
| download | postgresql-39314efa4dd9101c18ef37067c3e114968a600a4.tar.gz postgresql-39314efa4dd9101c18ef37067c3e114968a600a4.zip | |
Minor fixes for reloptions tests
Follow-up to 4b95cc1dc36c9d1971f757e9b519fcc442833f0e
Author: Nikolay Shaplov <dhyan@nataraj.su>
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/reloptions.out | 4 | ||||
| -rw-r--r-- | src/test/regress/sql/reloptions.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/src/test/regress/expected/reloptions.out b/src/test/regress/expected/reloptions.out index c4107d5ca1a..df3c99d1eb1 100644 --- a/src/test/regress/expected/reloptions.out +++ b/src/test/regress/expected/reloptions.out @@ -77,7 +77,7 @@ SELECT reloptions FROM pg_class WHERE oid = 'reloptions_test'::regclass; ALTER TABLE reloptions_test RESET (autovacuum_enabled, autovacuum_analyze_scale_factor); SELECT reloptions FROM pg_class WHERE oid = 'reloptions_test'::regclass AND -reloptions IS NULL; + reloptions IS NULL; reloptions ------------ @@ -86,7 +86,7 @@ reloptions IS NULL; -- RESET fails if a value is specified ALTER TABLE reloptions_test RESET (fillfactor=12); ERROR: RESET must not include values for parameters --- The OIDS option is not stored +-- The OIDS option is not stored as reloption DROP TABLE reloptions_test; CREATE TABLE reloptions_test(i INT) WITH (fillfactor=20, oids=true); SELECT reloptions, relhasoids FROM pg_class WHERE oid = 'reloptions_test'::regclass; diff --git a/src/test/regress/sql/reloptions.sql b/src/test/regress/sql/reloptions.sql index c9119fd8634..37fbf41f7d5 100644 --- a/src/test/regress/sql/reloptions.sql +++ b/src/test/regress/sql/reloptions.sql @@ -47,12 +47,12 @@ SELECT reloptions FROM pg_class WHERE oid = 'reloptions_test'::regclass; ALTER TABLE reloptions_test RESET (autovacuum_enabled, autovacuum_analyze_scale_factor); SELECT reloptions FROM pg_class WHERE oid = 'reloptions_test'::regclass AND -reloptions IS NULL; + reloptions IS NULL; -- RESET fails if a value is specified ALTER TABLE reloptions_test RESET (fillfactor=12); --- The OIDS option is not stored +-- The OIDS option is not stored as reloption DROP TABLE reloptions_test; CREATE TABLE reloptions_test(i INT) WITH (fillfactor=20, oids=true); SELECT reloptions, relhasoids FROM pg_class WHERE oid = 'reloptions_test'::regclass; |