diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2017-10-19 14:14:18 +0200 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2017-10-19 14:22:05 +0200 |
| commit | 4b95cc1dc36c9d1971f757e9b519fcc442833f0e (patch) | |
| tree | cf9504c4b963151d33e8b5c0e2b00682b0e389f3 /contrib/bloom/sql | |
| parent | 752871b6de9b4c7d2c685a059adb55887e169201 (diff) | |
Add more tests for reloptions
This is preparation for a future patch to extensively change how
reloptions work.
Author: Nikolay Shaplov
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/2615372.orqtEn8VGB@x200m
Diffstat (limited to 'contrib/bloom/sql')
| -rw-r--r-- | contrib/bloom/sql/bloom.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/contrib/bloom/sql/bloom.sql b/contrib/bloom/sql/bloom.sql index 22274609f20..32755f2b1a5 100644 --- a/contrib/bloom/sql/bloom.sql +++ b/contrib/bloom/sql/bloom.sql @@ -81,3 +81,14 @@ SELECT opcname, amvalidate(opc.oid) FROM pg_opclass opc JOIN pg_am am ON am.oid = opcmethod WHERE amname = 'bloom' ORDER BY 1; + +-- +-- relation options +-- +DROP INDEX bloomidx; +CREATE INDEX bloomidx ON tst USING bloom (i, t) WITH (length=7, col1=4); +SELECT reloptions FROM pg_class WHERE oid = 'bloomidx'::regclass; +-- check for min and max values +\set VERBOSITY terse +CREATE INDEX bloomidx2 ON tst USING bloom (i, t) WITH (length=0); +CREATE INDEX bloomidx2 ON tst USING bloom (i, t) WITH (col1=0); |