From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sebastien Flaesch <sebastien.flaesch@4js.com>
cc: pgsql-general <pgsql-general@lists.postgresql.org>
Subject: Re: prepared statement "cu1" already exists (but it does not)
In-reply-to: <AM9P191MB1286CCAAF4328B0F5F72109AB0072@AM9P191MB1286.EURP191.PROD.OUTLOOK.COM>
References: <AM9P191MB1286DAAE95E27A8FB79376D5B0002@AM9P191MB1286.EURP191.PROD.OUTLOOK.COM> <AM9P191MB1286601145DE06E7B0D3DA57B0002@AM9P191MB1286.EURP191.PROD.OUTLOOK.COM> <3298762.1712597811@sss.pgh.pa.us> <AM9P191MB1286CCAAF4328B0F5F72109AB0072@AM9P191MB1286.EURP191.PROD.OUTLOOK.COM>
Comments: In-reply-to Sebastien Flaesch <sebastien.flaesch@4js.com>
	message dated "Tue, 09 Apr 2024 14:44:18 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3751332.1712680610.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 09 Apr 2024 12:36:50 -0400
Message-ID: <3751333.1712680610@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/3751333.1712680610%40sss.pgh.pa.us>
Precedence: bulk

Sebastien Flaesch <sebastien.flaesch@4js.com> writes:
>>> Is it an issue if I use the same name for a prepared statement and the=
 server cursor? I mean:

>> From memory, I think those share the same "portal" namespace.

> Can you please elaborate?

> Is it supported to do:
>    PQprepare(pgConn, "cu1", "declare cu1 cursor for ... ", ... )
>    PQexecPrepared(pgConn, "cu1", ... )
> ?

> So far this has always worked.

Ah, sorry, what I should have said is that the SQL PREPARE command
works with the same namespace as PQprepare (which is a thin wrapper
over the wire-protocol Parse command).  There is a different namespace
for cursors.  Cursors do share that namespace with the wire-protocol
"portal" concept, but libpq doesn't directly expose portals.

			regards, tom lane