pgsql: Add isolation tests for DROP INDEX CONCURRENTLY.

Started by Simon Riggsalmost 14 years ago4 messagescomitters
Jump to latest
#1Simon Riggs
simon@2ndQuadrant.com

Add isolation tests for DROP INDEX CONCURRENTLY.
Backpatch to 9.2 to ensure bugs are fixed.

Abhijit Menon-Sen

Branch
------
REL9_2_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/d4412fa0e543fa1608c3bb9b6651d247ce59983f

Modified Files
--------------
.../expected/drop-index-concurrently-1.out | 36 ++++++++++++++++++++
.../expected/drop-index-concurrently-2.out | 24 +++++++++++++
src/test/isolation/isolation_schedule | 2 +
.../isolation/specs/drop-index-concurrently-1.spec | 33 ++++++++++++++++++
.../isolation/specs/drop-index-concurrently-2.spec | 21 +++++++++++
5 files changed, 116 insertions(+), 0 deletions(-)

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Simon Riggs (#1)
Re: pgsql: Add isolation tests for DROP INDEX CONCURRENTLY.

Simon Riggs <simon@2ndQuadrant.com> writes:

Add isolation tests for DROP INDEX CONCURRENTLY.

WTF? You just turned the whole buildfarm red. Didn't you read
Abhijit's statement that the code fails these tests currently?
Didn't you run the test before committing?

Please revert, until we have patches in place that make these
tests pass.

regards, tom lane

#3Simon Riggs
simon@2ndQuadrant.com
In reply to: Tom Lane (#2)
Re: pgsql: Add isolation tests for DROP INDEX CONCURRENTLY.

On 18 October 2012 14:49, Tom Lane <tgl@sss.pgh.pa.us> wrote:

Simon Riggs <simon@2ndQuadrant.com> writes:

Add isolation tests for DROP INDEX CONCURRENTLY.

WTF? You just turned the whole buildfarm red. Didn't you read
Abhijit's statement that the code fails these tests currently?
Didn't you run the test before committing?

Yes, but I was expecting it to fail.

Please revert, until we have patches in place that make these
tests pass.

This was supposed to be two patches in quick succession, one to show
the bug and one to fix it, but another problem delayed the second
commit.

At your request, I will revert and do this in one.

--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

#4Tom Lane
tgl@sss.pgh.pa.us
In reply to: Simon Riggs (#3)
Re: pgsql: Add isolation tests for DROP INDEX CONCURRENTLY.

Simon Riggs <simon@2ndQuadrant.com> writes:

On 18 October 2012 14:49, Tom Lane <tgl@sss.pgh.pa.us> wrote:

Please revert, until we have patches in place that make these
tests pass.

This was supposed to be two patches in quick succession, one to show
the bug and one to fix it, but another problem delayed the second
commit.

FWIW, a reasonable way to handle that would have been to make two
(or more) commits locally, but not push until the final state was good.
Pushing known-broken code is an extremely unfriendly thing to do.

regards, tom lane