Re: query

Ya, I'm with Tom on this. While there may be bugs in the driver there is
nothing this simple

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

On 29 April 2017 at 12:45, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Chuck Davis <cjgunzel(at)gmail(dot)com> writes:
> > If I execute the select statement in psql it works as expected:
> > ...
> > If I execute the statement in my program (and this has been working for
> > years on DB2) I get the following exception:
> > org.postgresql.util.PSQLException: ERROR: relation "infosys.company"
> does
> > not exist
>
> I'd lay pretty long odds that that means the program is connecting to a
> different database than you're connecting to in psql. Double-check the
> connection URL it's using.
>
> (A common variant of that is "program is using a different search_path",
> but since you're failing on a schema-qualified relation name, search
> path doesn't enter into it.)
>
> regards, tom lane
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>