diff options
| author | Fujii Masao | 2014-08-28 20:10:47 +0000 |
|---|---|---|
| committer | Fujii Masao | 2014-08-28 20:10:47 +0000 |
| commit | 9df492664a74a948c87232f523eea637920a516b (patch) | |
| tree | 09d29661892eee5cb01b401f5d4cfce13a12c929 /src/test | |
| parent | 11a020eb6e4023a1570a2788ba22dd6aafbd02dc (diff) | |
Revert "Allow units to be specified in relation option setting value."
This reverts commit e23014f3d40f7d2c23bc97207fd28efbe5ba102b.
As the side effect of the reverted commit, when the unit is
specified, the reloption was stored in the catalog with the unit.
This broke pg_dump (specifically, it prevented pg_dump from
outputting restorable backup regarding the reloption) and
turned the buildfarm red. Revert the commit until the fixed
version is ready.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/alter_table.out | 14 | ||||
| -rw-r--r-- | src/test/regress/sql/alter_table.sql | 6 |
2 files changed, 0 insertions, 20 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index 1d31b81456..10f45f25a5 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -1811,20 +1811,6 @@ Check constraints: "test_inh_check_a_check" CHECK (a::double precision > 10.2::double precision) Inherits: test_inh_check --- 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'); -ERROR: value 3min out of bounds for option "autovacuum_vacuum_cost_delay" -DETAIL: Valid values are between "0" and "100". -ALTER TABLE test_param_unit SET (autovacuum_analyze_threshold = '3min'); -- fails -ERROR: invalid value for integer option "autovacuum_analyze_threshold": 3min -\d+ test_param_unit - Table "public.test_param_unit" - Column | Type | Modifiers | Storage | Stats target | Description ---------+------+-----------+----------+--------------+------------- - a | text | | extended | | -Options: autovacuum_vacuum_cost_delay=80ms - -- -- lock levels -- diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql index 2c21006615..12fd7c2321 100644 --- a/src/test/regress/sql/alter_table.sql +++ b/src/test/regress/sql/alter_table.sql @@ -1254,12 +1254,6 @@ 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 -- |