MIME-Version: 1.0
From: Igor Korot <ikorot01@gmail.com>
Date: Sat, 16 May 2026 01:40:32 -0500
Message-ID: 
 <CA+FnnTycS2E-Bb7Wm+-mmTXwRQ-t4Wyfg=S2Upysf-zF0ty_2w@mail.gmail.com>
Subject: Double prepare
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BFnnTycS2E-Bb7Wm%2B-mmTXwRQ-t4Wyfg%3DS2Upysf-zF0ty_2w%40mail.gmail.com>
Precedence: bulk

Hi, ALL,
Is there a way to see if the query has been prepared already (in libpq)?

Trying to avoid a following scenario (pseudo-code):

[code]
int main()
{
    test();
    test();
}

void test()
{
    PGresult *res = PQprepare( conn, "my query", "SELECT * FROM
my_table", /* rest of params */ );
    PQclear( res );
}
[/code]

I presume there is a penalty for that even if the code succeeds.

Or is it better to run PQprepare for all known parameterized queries
in the very beginning of the program and just execute them when needed?

Thank you.