Обсуждение: how to test a PL/pgSQL function using pgAdmin III ?
Hi,
I created a plpgsql function in pgAdmin III and it will insert a record into a table. I am not ready to test it with my App. Can I test it first with pgAdmin III Query window? What would be the syntax to test it?
My function is myuser_insert(varchar, varchar)
I tried
Execute myuser_insert('mylogin_id', 'mypassword');
But not working. ERROR: prepared statement "myuser_insert" does not exist
Thanks for any help.
Yahoo! FareChase - Search multiple travel sites in one click.
On 11/23/05, Charles Bai <charlesbaiusa@yahoo.com> wrote: > Hi, > > I created a plpgsql function in pgAdmin III and it will insert a record into > a table. I am not ready to test it with my App. Can I test it first with > pgAdmin III Query window? What would be the syntax to test it? > > My function is myuser_insert(varchar, varchar) > > I tried > > Execute myuser_insert('mylogin_id', 'mypassword'); > > But not working. ERROR: prepared statement "myuser_insert" does not exist > > Thanks for any help. > use "select myuser_insert('mylogin_id', 'mypassword');" instead -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;)
Works like a charm, thank you, Jaime.
Charles
Jaime Casanova <systemguards@gmail.com> wrote:
Jaime Casanova <systemguards@gmail.com> wrote:
On 11/23/05, Charles Bai wrote:
> Hi,
>
> I created a plpgsql function in pgAdmin III and it will insert a record into
> a table. I am not ready to test it with my App. Can I test it first with
> pgAdmin III Query window? What would be the syntax to test it?
>
> My function is myuser_insert(varchar, varchar)
>
> I tried
>
> Execute myuser_insert('mylogin_id', 'mypassword');
>
> But not working. ERROR: prepared statement "myuser_insert" does not exist
>
> Thanks for any help.
>
use "select myuser_insert('mylogin_id', 'mypassword');" instead
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
Yahoo! FareChase - Search multiple travel sites in one click.