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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
