diff options
Diffstat (limited to 'src/test/regress/sql/alter_table.sql')
| -rw-r--r-- | src/test/regress/sql/alter_table.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql index 12fd7c2321b..2c21006615f 100644 --- a/src/test/regress/sql/alter_table.sql +++ b/src/test/regress/sql/alter_table.sql @@ -1254,6 +1254,12 @@ ALTER TABLE test_inh_check ALTER COLUMN a TYPE numeric; \d test_inh_check \d test_inh_check_child +-- Set a storage parameter with unit +CREATE TABLE test_param_unit (a text) WITH (autovacuum_vacuum_cost_delay = '80ms'); +ALTER TABLE test_param_unit SET (autovacuum_vacuum_cost_delay = '3min'); +ALTER TABLE test_param_unit SET (autovacuum_analyze_threshold = '3min'); -- fails +\d+ test_param_unit + -- -- lock levels -- |