diff options
author | Robert Haas <rhaas@postgresql.org> | 2017-03-07 11:24:51 -0500 |
---|---|---|
committer | Robert Haas <rhaas@postgresql.org> | 2017-03-07 11:27:21 -0500 |
commit | d88d06cd0783933b7103d42d3f101baa22b37292 (patch) | |
tree | bd7d165f9c9ba827f7e90de7e9f0ebcfe697a9e0 /src/test/regress/sql/vacuum.sql | |
parent | 508dabaf39e1f66cbe3fc54d2b66f010aa59c66b (diff) | |
download | postgresql-d88d06cd0783933b7103d42d3f101baa22b37292.tar.gz |
Fix relcache reference leak.
Reported by Kevin Grittner. Faulty commit identified by Tom Lane.
Patch by Amit Langote, reviewed by Michael Paquier.
Discussion: http://postgr.es/m/CACjxUsOHbH1=99u8mGxmLHfy5hov4ENEpvM6=3ARjos7wG7rtQ@mail.gmail.com
Diffstat (limited to 'src/test/regress/sql/vacuum.sql')
-rw-r--r-- | src/test/regress/sql/vacuum.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/src/test/regress/sql/vacuum.sql b/src/test/regress/sql/vacuum.sql index 7b819f654d..7c5fb04917 100644 --- a/src/test/regress/sql/vacuum.sql +++ b/src/test/regress/sql/vacuum.sql @@ -64,3 +64,13 @@ VACUUM (DISABLE_PAGE_SKIPPING) vaccluster; DROP TABLE vaccluster; DROP TABLE vactst; + +-- partitioned table +CREATE TABLE vacparted (a int, b char) PARTITION BY LIST (a); +CREATE TABLE vacparted1 PARTITION OF vacparted FOR VALUES IN (1); +INSERT INTO vacparted VALUES (1, 'a'); +UPDATE vacparted SET b = 'b'; +VACUUM (ANALYZE) vacparted; +VACUUM (FULL) vacparted; +VACUUM (FREEZE) vacparted; +DROP TABLE vacparted; |