Re: BUG #6727: Column does not exist exception has no error code - Mailing list pgsql-bugs

From Patrick Tucker
Subject Re: BUG #6727: Column does not exist exception has no error code
Date
Msg-id CAOmDbN7Yw4qndPzk-nxmdcQmHtO9fgpxTdPcOkEeGcRNzYUpVw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #6727: Column does not exist exception has no error code  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Interesting, the test case that I ran was performing a simple SQL statement
like the following: select "a" from table

I wonder if the version of the driver I am using needs to be updated or
even the database?
Thanks,
Pat
On Wed, Jul 11, 2012 at 1:43 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> tuckerpmt@gmail.com writes:
> > The SQLException that is thrown when performing a query that has a column
> > name that is not valid, does not exist, does not contain an error
> > code.
>
> Could you provide a specific example?  When I try this I see an error
> code, 42703:
>
> regression=# \set VERBOSITY verbose
> regression=# select nosuchcol from int8_tbl;
> ERROR:  42703: column "nosuchcol" does not exist
> LINE 1: select nosuchcol from int8_tbl;
>                ^
> LOCATION:  transformColumnRef, parse_expr.c:766
>
> There may indeed be someplace where the errcode was forgotten, but
> without a concrete example it's hard to find where.
>
>                         regards, tom lane
>

pgsql-bugs by date:

Previous
From: dmg@uvic.ca
Date:
Subject: BUG #6728: revoke grant cascade behaviour
Next
From: Craig Ringer
Date:
Subject: Re: BUG #6727: Column does not exist exception has no error code