From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Couple of issues with prepared FETCH commands |
Date: | 2017-01-11 20:08:11 |
Message-ID: | CA+TgmoaycdO+5StVFz4E+BiT1pzML3r=_V=VMBQvfQkTQzwjrw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Jan 10, 2017 at 5:38 PM, Andrew Gierth
<andrew(at)tao11(dot)riddles(dot)org(dot)uk> wrote:
> But the problem that actually came up is this: if you do the PQprepare
> before the named cursor has actually been opened, then everything works
> _up until_ the first event, such as a change to search_path, that forces
> a revalidation; and at that point it fails with the "must not change
> result type" error _even if_ the cursor always has exactly the same
> result type. This happens because the initial prepare actually stored
> NULL for plansource->resultDesc, since the cursor name wasn't found,
> while on the revalidate, when the cursor obviously does exist, it gets
> the actual result type.
>
> It seems a bit of a "gotcha" to have it fail in this case when the
> result type isn't actually being checked in other cases.
To me, that sounds like a bug.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2017-01-11 20:08:58 | Re: Packages: Again |
Previous Message | Pavel Stehule | 2017-01-11 20:07:06 | Re: merging some features from plpgsql2 project |