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.