From 19956e0d5388b11a1cc3eaf2dbf628aa531ce331 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 23 Mar 2006 00:19:30 +0000 Subject: Add error location info to ResTarget parse nodes. Allows error cursor to be supplied for various mistakes involving INSERT and UPDATE target columns. --- src/test/regress/expected/alter_table.out | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) (limited to 'src/test') diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index 6655e8b6d1..b011f9e1ed 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -677,12 +677,16 @@ LINE 1: select * from atacc1 where "........pg.dropped.1........" = ... -- UPDATEs update atacc1 set a = 3; ERROR: column "a" of relation "atacc1" does not exist +LINE 1: update atacc1 set a = 3; + ^ update atacc1 set b = 2 where a = 3; ERROR: column "a" does not exist LINE 1: update atacc1 set b = 2 where a = 3; ^ update atacc1 set "........pg.dropped.1........" = 3; ERROR: column "........pg.dropped.1........" of relation "atacc1" does not exist +LINE 1: update atacc1 set "........pg.dropped.1........" = 3; + ^ update atacc1 set b = 2 where "........pg.dropped.1........" = 3; ERROR: column "........pg.dropped.1........" does not exist LINE 1: update atacc1 set b = 2 where "........pg.dropped.1........"... @@ -695,21 +699,37 @@ ERROR: INSERT has more expressions than target columns insert into atacc1 values (11, 12, 13); insert into atacc1 (a) values (10); ERROR: column "a" of relation "atacc1" does not exist +LINE 1: insert into atacc1 (a) values (10); + ^ insert into atacc1 (a) values (default); ERROR: column "a" of relation "atacc1" does not exist +LINE 1: insert into atacc1 (a) values (default); + ^ insert into atacc1 (a,b,c,d) values (10,11,12,13); ERROR: column "a" of relation "atacc1" does not exist +LINE 1: insert into atacc1 (a,b,c,d) values (10,11,12,13); + ^ insert into atacc1 (a,b,c,d) values (default,11,12,13); ERROR: column "a" of relation "atacc1" does not exist +LINE 1: insert into atacc1 (a,b,c,d) values (default,11,12,13); + ^ insert into atacc1 (b,c,d) values (11,12,13); insert into atacc1 ("........pg.dropped.1........") values (10); ERROR: column "........pg.dropped.1........" of relation "atacc1" does not exist +LINE 1: insert into atacc1 ("........pg.dropped.1........") values (... + ^ insert into atacc1 ("........pg.dropped.1........") values (default); ERROR: column "........pg.dropped.1........" of relation "atacc1" does not exist +LINE 1: insert into atacc1 ("........pg.dropped.1........") values (... + ^ insert into atacc1 ("........pg.dropped.1........",b,c,d) values (10,11,12,13); ERROR: column "........pg.dropped.1........" of relation "atacc1" does not exist +LINE 1: insert into atacc1 ("........pg.dropped.1........",b,c,d) va... + ^ insert into atacc1 ("........pg.dropped.1........",b,c,d) values (default,11,12,13); ERROR: column "........pg.dropped.1........" of relation "atacc1" does not exist +LINE 1: insert into atacc1 ("........pg.dropped.1........",b,c,d) va... + ^ -- DELETEs delete from atacc1 where a = 3; ERROR: column "a" does not exist -- cgit v1.2.1