diff options
| author | Tom Lane | 2006-03-23 00:19:30 +0000 |
|---|---|---|
| committer | Tom Lane | 2006-03-23 00:19:30 +0000 |
| commit | 19956e0d5388b11a1cc3eaf2dbf628aa531ce331 (patch) | |
| tree | f2c7071f4daee4588d4c004d809bd327baa4adde /src/test | |
| parent | a3f0b3d68f9a5357a3f72b40a45bcc714a9e0649 (diff) | |
Add error location info to ResTarget parse nodes. Allows error cursor to be supplied
for various mistakes involving INSERT and UPDATE target columns.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/alter_table.out | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index 6655e8b6d11..b011f9e1eda 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 |