| From: | brian <brian(at)zijn-digital(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: missing cache data for cache id 27 |
| Date: | 2007-01-24 17:27:04 |
| Message-ID: | 45B796E8.9060501@zijn-digital.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Richard Huxton wrote:
> brian wrote:
>
>> I'm getting the above error when i try to replace a function of mine.
>> It seems i have two problems: the latest dump (through phpPGAdmin)
>> works fine, except that a function that should return a record was
>> replaced without the column definition list, so calls on it are failing.
>>
>> from pg_dump:
>> CREATE OR REPLACE FUNCTION getserviceprovidertotalsbytype() RETURNS
>> SETOF record AS $$
>>
>> should be:
>> CREATE OR REPLACE FUNCTION getserviceprovidertotalsbytype(OUT name
>> text, OUT id INT4, OUT total INT4) RETURNS SETOF record AS $$
>
>
> What version of PostgreSQL and what version of pg_dump are we talking
> about here?
>
Ach! 8.1.4, sorry.
b
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-01-24 17:33:14 | Re: missing cache data for cache id 27 |
| Previous Message | Markus Schiltknecht | 2007-01-24 17:10:19 | Re: STOP all user access except for admin for a few minutes? |