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?
--
Richard Huxton
Archonet Ltd