Re: bad error message

On Oct 12, 2006, at 7:39 PM, Tom Lane wrote:

> That's not necessarily all that much help, if you've got so many FK
> constraints in your command that you don't know exactly where to look.
> I think what you're really wishing for is an error cursor position.
> 8.2 has the infrastructure for this, eg
>
> regression=# create table foo (a int, b int, c int);
> CREATE TABLE
> regression=# select a, b, q from foo;
> ERROR:  column "q" does not exist
> LINE 1: select a, b, q from foo;
>                      ^
> regression=#
>
> but unfortunately the facility hasn't been extended to foreign key
> constraint clauses in particular :-(.  Maybe next time


I'll be glad  if  it makes it into a future release.  It would be a
GREAT feature.

Thats for the info on the cursor position.  thats a nice update in
the .2 branch.