From: NosyMan <nosyman@gmail.com>
To: pgsql-sql@postgresql.org
Subject: PREPARED STATEMENT
Date: Sat, 11 Dec 2004 12:47:09 +0000
Message-ID: <200412111247.09108.nosyman@gmail.com> (raw)
Hi there,
I want to know that is a posibillity to test if a statement is prepared in
PL/PgSQL.
I have create a function:
.........
PREPARE PSTAT_SAVE_record(INTEGER, INTEGER, DATE, VARCHAR) AS INSERT INTO
table VALUES($1, $2, $3, $4);
.........
When I try to execute it second time I got an error: prepared statement
'PSTAT_SAVE_record' already exists. How can I avoid this error? is there a
posibillity to test if a statement was prepared before?
Thanks,
Nosy
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: nosyman@gmail.com
Subject: Re: PREPARED STATEMENT
In-Reply-To: <200412111247.09108.nosyman@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox