Commit982b82d

committed

Add a regression test case for \d on an index.

Previous commit shows the need for this. The coverage isn't reallythorough, but it's better than nothing.

1 parente694cf2 commit982b82dCopy full SHA for 982b82d

File tree

+18

-0

lines changed

+18

-0

lines changed

Lines changed: 16 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -2383,6 +2383,14 @@ ALTER TABLE cwi_test ADD primary key USING INDEX cwi_uniq_idx;`
`2383`	`2383`	`Indexes:`
`2384`	`2384`	`"cwi_uniq_idx" PRIMARY KEY, btree (a, b)`
`2385`	`2385`
	`2386`	`+\d cwi_uniq_idx`
	`2387`	`+ Index "public.cwi_uniq_idx"`
	`2388`	`+ Column \| Type \| Definition`
	`2389`	`+--------+-----------------------+------------`
	`2390`	`+ a \| integer \| a`
	`2391`	`+ b \| character varying(10) \| b`
	`2392`	`+primary key, btree, for table "public.cwi_test"`
	`2393`	`+`
`2386`	`2394`	`CREATE UNIQUE INDEX cwi_uniq2_idx ON cwi_test(b , a);`
`2387`	`2395`	`ALTER TABLE cwi_test DROP CONSTRAINT cwi_uniq_idx,`
`2388`	`2396`	`ADD CONSTRAINT cwi_replaced_pkey PRIMARY KEY`
`@@ -2398,6 +2406,14 @@ NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "cwi_uniq2_i`
`2398`	`2406`	`Indexes:`
`2399`	`2407`	`"cwi_replaced_pkey" PRIMARY KEY, btree (b, a)`
`2400`	`2408`
	`2409`	`+\d cwi_replaced_pkey`
	`2410`	`+ Index "public.cwi_replaced_pkey"`
	`2411`	`+ Column \| Type \| Definition`
	`2412`	`+--------+-----------------------+------------`
	`2413`	`+ b \| character varying(10) \| b`
	`2414`	`+ a \| integer \| a`
	`2415`	`+primary key, btree, for table "public.cwi_test"`
	`2416`	`+`
`2401`	`2417`	`DROP INDEX cwi_replaced_pkey;-- Should fail; a constraint depends on it`
`2402`	`2418`	`ERROR: cannot drop index cwi_replaced_pkey because constraint cwi_replaced_pkey on table cwi_test requires it`
`2403`	`2419`	`HINT: You can drop constraint cwi_replaced_pkey on table cwi_test instead.`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -767,13 +767,15 @@ CREATE UNIQUE INDEX cwi_uniq_idx ON cwi_test(a , b);`
`767`	`767`	`ALTERTABLE cwi_test ADDprimary key USING INDEX cwi_uniq_idx;`
`768`	`768`
`769`	`769`	`\d cwi_test`
	`770`	`+\d cwi_uniq_idx`
`770`	`771`
`771`	`772`	`CREATEUNIQUE INDEXcwi_uniq2_idxON cwi_test(b , a);`
`772`	`773`	`ALTERTABLE cwi_test DROPCONSTRAINT cwi_uniq_idx,`
`773`	`774`	`ADDCONSTRAINT cwi_replaced_pkeyPRIMARY KEY`
`774`	`775`	`USING INDEX cwi_uniq2_idx;`
`775`	`776`
`776`	`777`	`\d cwi_test`
	`778`	`+\d cwi_replaced_pkey`
`777`	`779`
`778`	`780`	`DROPINDEX cwi_replaced_pkey;-- Should fail; a constraint depends on it`
`779`	`781`

Comments

(0)