Re: Trouble with FETCH_COUNT and combined queries in psql - Mailing list pgsql-hackers

From Daniel Verite
Subject Re: Trouble with FETCH_COUNT and combined queries in psql
Date
Msg-id 1f69bc35-7680-49fa-b392-e9382b95af4f@manitou-mail.org
Whole thread Raw
In response to Re: Trouble with FETCH_COUNT and combined queries in psql  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: Trouble with FETCH_COUNT and combined queries in psql
List pgsql-hackers
    Fabien COELHO wrote:

> I added some stuff to extract embedded "\;" for pgbench "\cset", which has
> been removed though, but it is easy to add back a detection of "\;", and
> also to detect select. If the position of the last select is known, the
> cursor can be declared in the right place, which would also solve the
> problem.

Thanks, I'll extract the necessary bits from your patch.
I don't plan to go as far as injecting a DECLARE CURSOR inside
the query, but rather just forbid the use of the cursor in
the combined-queries case.


Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite



pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Regression test PANICs with master-standby setup on samemachine
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Regression test PANICs with master-standby setup on samemachine