Re: [SQL] PL/pgSQL and PHP 5

[PostgreSQL Admin <postgres(at)productivitymedia(dot)com>]

Tom Lane wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>
>   
I never thought of that.  I look into it.

Thanks,
J