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