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

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(dot)klaver(at)aklaver(dot)com>
wrote:

> 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
>