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.klaver@aklaver.com

Hi

Thank you for the answer, after a longer tracing, (go based and printing pg
queries to log, I realize that it happens on a different place that I
thought it does.

Ido

On Sat, Sep 15, 2018 at 12:13 AM Adrian Klaver <adrian.klaver@aklaver.com>
wrote: