Thread: Query act different when doing by hand and by using a driver in app
Hello,
Not sure that this is the right mailing list, so sorry from advance.
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?
Thank you
Ido
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:
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