NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit10f1f70

committed

[ Previous patch reversed.]

Please use this patch instead of my previously submitted one.It is just remerged against HEAD for new alter_table.out stuff.Another reason this patch is useful for _interactive_ users: imagine aview based on a many way join. Imagine creating a complicated insertrule that inserts into all the joined tables and when you insert you geta check failure, but you need to know which actual table the constraintwas on that failed!Christopher Kings-Lynne

1 parent6b64704 commit10f1f70Copy full SHA for 10f1f70

File tree

1 file changed

-6

lines changed

src/test/regress/expected
- alter_table.out

1 file changed

-6

lines changed

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

Lines changed: 6 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -409,7 +409,7 @@ create table atacc1 ( test int );`
`409`	`409`	`alter table atacc1 add constraint atacc_test1 check (test>3);`
`410`	`410`	`-- should fail`
`411`	`411`	`insert into atacc1 (test) values (2);`
`412`		`-ERROR: ExecInsert: rejected due to CHECK constraint atacc_test1`
	`412`	`+ERROR: ExecInsert: rejected due to CHECK constraint"atacc_test1" on "atacc1"`
`413`	`413`	`-- should succeed`
`414`	`414`	`insert into atacc1 (test) values (4);`
`415`	`415`	`drop table atacc1;`
`@@ -434,7 +434,7 @@ create table atacc1 ( test int, test2 int, test3 int);`
`434`	`434`	`alter table atacc1 add constraint atacc_test1 check (test+test2<test3*4);`
`435`	`435`	`-- should fail`
`436`	`436`	`insert into atacc1 (test,test2,test3) values (4,4,2);`
`437`		`-ERROR: ExecInsert: rejected due to CHECK constraint atacc_test1`
	`437`	`+ERROR: ExecInsert: rejected due to CHECK constraint"atacc_test1" on "atacc1"`
`438`	`438`	`-- should succeed`
`439`	`439`	`insert into atacc1 (test,test2,test3) values (4,4,5);`
`440`	`440`	`drop table atacc1;`
`@@ -443,7 +443,7 @@ create table atacc1 (test int check (test>3), test2 int);`
`443`	`443`	`alter table atacc1 add check (test2>test);`
`444`	`444`	`-- should fail for $2`
`445`	`445`	`insert into atacc1 (test2, test) values (3, 4);`
`446`		`-ERROR: ExecInsert: rejected due to CHECK constraint$1`
	`446`	`+ERROR: ExecInsert: rejected due to CHECK constraint"$1" on "atacc1"`
`447`	`447`	`drop table atacc1;`
`448`	`448`	`-- inheritance related tests`
`449`	`449`	`create table atacc1 (test int);`
`@@ -452,11 +452,11 @@ create table atacc3 (test3 int) inherits (atacc1, atacc2);`
`452`	`452`	`alter table atacc2 add constraint foo check (test2>0);`
`453`	`453`	`-- fail and then succeed on atacc2`
`454`	`454`	`insert into atacc2 (test2) values (-3);`
`455`		`-ERROR: ExecInsert: rejected due to CHECK constraint foo`
	`455`	`+ERROR: ExecInsert: rejected due to CHECK constraint"foo" on "atacc2"`
`456`	`456`	`insert into atacc2 (test2) values (3);`
`457`	`457`	`-- fail and then succeed on atacc3`
`458`	`458`	`insert into atacc3 (test2) values (-3);`
`459`		`-ERROR: ExecInsert: rejected due to CHECK constraint foo`
	`459`	`+ERROR: ExecInsert: rejected due to CHECK constraint"foo" on "atacc3"`
`460`	`460`	`insert into atacc3 (test2) values (3);`
`461`	`461`	`drop table atacc3;`
`462`	`462`	`drop table atacc2;`
`@@ -468,7 +468,7 @@ create table atacc3 (test3 int) inherits (atacc1, atacc2);`
`468`	`468`	`alter table only atacc2 add constraint foo check (test2>0);`
`469`	`469`	`-- fail and then succeed on atacc2`
`470`	`470`	`insert into atacc2 (test2) values (-3);`
`471`		`-ERROR: ExecInsert: rejected due to CHECK constraint foo`
	`471`	`+ERROR: ExecInsert: rejected due to CHECK constraint"foo" on "atacc2"`
`472`	`472`	`insert into atacc2 (test2) values (3);`
`473`	`473`	`-- both succeed on atacc3`
`474`	`474`	`insert into atacc3 (test2) values (-3);`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit10f1f70

File tree

1 file changed

1 file changed

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

0 commit comments