Re: org.postgresql.util.PSQLException - column does not exist

On 22 Jul 2013, at 3:11 PM, Luca Ferrari <fluca1978(at)infinito(dot)it> wrote:

> On Mon, Jul 22, 2013 at 10:50 AM, Wayne Oliver <wayn0(dot)ml(at)gmail(dot)com> wrote:
>> ERROR 2013-07-18 14:48:43,251 [main] : org.postgresql.util.PSQLException:
>> ERROR: column "mdn" does not exist
>> Position: 39
>
> What driver version are you using? It appears to me the error message
> has changed in recent versions, so I suggest an upgrade of the driver.
> What if you try to add an alias to the column?
>

I believe it's the latest one, postgresql-9.2-1003.jdbc4.jar

Waynes-MacBook:~ wayne$ java -version
java version "1.6.0_51"
Java(TM) SE Runtime Environment (build 1.6.0_51-b11-456-11M4508)
Java HotSpot(TM) 64-Bit Server VM (build 20.51-b01-456, mixed mode)

tried using an alias and still nothing. (SELECT AS)

Really don't know where to turn :-s

Thanks for the input.

--
Wayne