From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | PostgreSQL Admin <postgres(at)productivitymedia(dot)com> |
Cc: | Lista PG-PHP <pgsql-php(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [SQL] PL/pgSQL and PHP 5 |
Date: | 2006-08-10 03:40:57 |
Message-ID: | 9830.1155181257@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php pgsql-sql |
PostgreSQL Admin <postgres(at)productivitymedia(dot)com> writes:
> CREATE OR REPLACE FUNCTION insert_staff_b
> (insert_firstname varchar)
> RETURNS VOID AS
> ...
> Still I get this error:
> Warning: pg_query(): Query failed: ERROR: function
> insert_staff_b(character varying) does not exist
Sure looks like it oughta work. One possibility is that you created the
function in a schema that isn't part of the application's search path.
Other than that, look for *really* silly errors, like not creating the
function in the same database the application is connected to ...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | PostgreSQL Admin | 2006-08-10 03:42:34 | Re: PL/pgSQL and PHP 5 |
Previous Message | John DeSoi | 2006-08-10 03:24:48 | Re: PL/pgSQL and PHP 5 |
From | Date | Subject | |
---|---|---|---|
Next Message | PostgreSQL Admin | 2006-08-10 03:42:34 | Re: PL/pgSQL and PHP 5 |
Previous Message | John DeSoi | 2006-08-10 03:24:48 | Re: PL/pgSQL and PHP 5 |