Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitf563afd

Browse files
Alter test results to comply with new ALTER TABLE behaviour.
1 parent2c3d9db commitf563afd

File tree

2 files changed

+35
-39
lines changed

2 files changed

+35
-39
lines changed

‎src/test/regress/expected/alter_table.out

Lines changed: 35 additions & 37 deletions
Original file line numberDiff line numberDiff line change
@@ -1669,90 +1669,88 @@ and c.relname != 'my_locks'
16691669
group by c.relname;
16701670
create table alterlock (f1 int primary key, f2 text);
16711671
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "alterlock_pkey" for table "alterlock"
1672-
-- share update exclusive
16731672
begin; alter table alterlock alter column f2 set statistics 150;
16741673
select * from my_locks order by 1;
1675-
relname |max_lockmode
1676-
-----------+--------------------------
1677-
alterlock |ShareUpdateExclusiveLock
1674+
relname | max_lockmode
1675+
-----------+---------------------
1676+
alterlock |AccessExclusiveLock
16781677
(1 row)
16791678

16801679
rollback;
16811680
begin; alter table alterlock cluster on alterlock_pkey;
16821681
select * from my_locks order by 1;
1683-
relname |max_lockmode
1684-
----------------+--------------------------
1685-
alterlock |ShareUpdateExclusiveLock
1686-
alterlock_pkey |ShareUpdateExclusiveLock
1682+
relname | max_lockmode
1683+
----------------+---------------------
1684+
alterlock |AccessExclusiveLock
1685+
alterlock_pkey |AccessExclusiveLock
16871686
(2 rows)
16881687

16891688
commit;
16901689
begin; alter table alterlock set without cluster;
16911690
select * from my_locks order by 1;
1692-
relname |max_lockmode
1693-
-----------+--------------------------
1694-
alterlock |ShareUpdateExclusiveLock
1691+
relname | max_lockmode
1692+
-----------+---------------------
1693+
alterlock |AccessExclusiveLock
16951694
(1 row)
16961695

16971696
commit;
16981697
begin; alter table alterlock set (fillfactor = 100);
16991698
select * from my_locks order by 1;
1700-
relname |max_lockmode
1701-
-----------+--------------------------
1702-
alterlock |ShareUpdateExclusiveLock
1703-
pg_toast |ShareUpdateExclusiveLock
1699+
relname | max_lockmode
1700+
-----------+---------------------
1701+
alterlock |AccessExclusiveLock
1702+
pg_toast |AccessExclusiveLock
17041703
(2 rows)
17051704

17061705
commit;
17071706
begin; alter table alterlock reset (fillfactor);
17081707
select * from my_locks order by 1;
1709-
relname |max_lockmode
1710-
-----------+--------------------------
1711-
alterlock |ShareUpdateExclusiveLock
1712-
pg_toast |ShareUpdateExclusiveLock
1708+
relname | max_lockmode
1709+
-----------+---------------------
1710+
alterlock |AccessExclusiveLock
1711+
pg_toast |AccessExclusiveLock
17131712
(2 rows)
17141713

17151714
commit;
17161715
begin; alter table alterlock set (toast.autovacuum_enabled = off);
17171716
select * from my_locks order by 1;
1718-
relname |max_lockmode
1719-
-----------+--------------------------
1720-
alterlock |ShareUpdateExclusiveLock
1721-
pg_toast |ShareUpdateExclusiveLock
1717+
relname | max_lockmode
1718+
-----------+---------------------
1719+
alterlock |AccessExclusiveLock
1720+
pg_toast |AccessExclusiveLock
17221721
(2 rows)
17231722

17241723
commit;
17251724
begin; alter table alterlock set (autovacuum_enabled = off);
17261725
select * from my_locks order by 1;
1727-
relname |max_lockmode
1728-
-----------+--------------------------
1729-
alterlock |ShareUpdateExclusiveLock
1730-
pg_toast |ShareUpdateExclusiveLock
1726+
relname | max_lockmode
1727+
-----------+---------------------
1728+
alterlock |AccessExclusiveLock
1729+
pg_toast |AccessExclusiveLock
17311730
(2 rows)
17321731

17331732
commit;
17341733
begin; alter table alterlock alter column f2 set (n_distinct = 1);
17351734
select * from my_locks order by 1;
1736-
relname |max_lockmode
1737-
-----------+--------------------------
1738-
alterlock |ShareUpdateExclusiveLock
1735+
relname | max_lockmode
1736+
-----------+---------------------
1737+
alterlock |AccessExclusiveLock
17391738
(1 row)
17401739

17411740
rollback;
17421741
begin; alter table alterlock alter column f2 set storage extended;
17431742
select * from my_locks order by 1;
1744-
relname |max_lockmode
1745-
-----------+--------------------------
1746-
alterlock |ShareUpdateExclusiveLock
1743+
relname | max_lockmode
1744+
-----------+---------------------
1745+
alterlock |AccessExclusiveLock
17471746
(1 row)
17481747

17491748
rollback;
1750-
-- share row exclusive
17511749
begin; alter table alterlock alter column f2 set default 'x';
17521750
select * from my_locks order by 1;
1753-
relname |max_lockmode
1754-
-----------+-----------------------
1755-
alterlock |ShareRowExclusiveLock
1751+
relname | max_lockmode
1752+
-----------+---------------------
1753+
alterlock |AccessExclusiveLock
17561754
(1 row)
17571755

17581756
rollback;

‎src/test/regress/sql/alter_table.sql

Lines changed: 0 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1221,7 +1221,6 @@ group by c.relname;
12211221

12221222
createtablealterlock (f1intprimary key, f2text);
12231223

1224-
-- share update exclusive
12251224
begin; alter table alterlock alter column f2set statistics150;
12261225
select*from my_locksorder by1;
12271226
rollback;
@@ -1258,7 +1257,6 @@ begin; alter table alterlock alter column f2 set storage extended;
12581257
select*from my_locksorder by1;
12591258
rollback;
12601259

1261-
-- share row exclusive
12621260
begin; alter table alterlock alter column f2set default'x';
12631261
select*from my_locksorder by1;
12641262
rollback;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp