From: | PostgreSQL Admin <postgres(at)productivitymedia(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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:52:35 |
Message-ID: | 44DAAD83.3060604@productivitymedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | PostgreSQL Admin | 2006-08-10 04:01:32 | Re: [SQL] PL/pgSQL and PHP 5 - thanks |
Previous Message | PostgreSQL Admin | 2006-08-10 03:42:34 | Re: PL/pgSQL and PHP 5 |
From | Date | Subject | |
---|---|---|---|
Next Message | PostgreSQL Admin | 2006-08-10 04:01:32 | Re: [SQL] PL/pgSQL and PHP 5 - thanks |
Previous Message | PostgreSQL Admin | 2006-08-10 03:42:34 | Re: PL/pgSQL and PHP 5 |