Re: Query act different when doing by hand and by using a driver in app

On 9/14/18 12:11 PM, ik wrote:
> Hello,
>
> Not sure that this is the right mailing list, so sorry from advance.
>
> I have a program that when it does a query I have one raw returns, but
> when I execute the same query with the same conditions, I get the right
> number of rows back.

The above is going to need more information to work out:

1) The query that returns one row is running in a Go program using the
Go driver below, correct?

2) The other query that returns correctly is being run where and how?

3) What is the actual query?

4) How is the query setup in the program?

5) Are you sure the incorrect and correct queries are running against
the same database?

>
> I'm using gonlang and https://github.com/jackc/pgx .
> The query inside is inside an already open cursor of another "select"
> query that I iterate over.
>
> Is there a way to debug just that inside pg-logs without having all
> possible queries logged in?

If it is a SELECT query then no.

>
> Thank you
> Ido

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com