function restore order

From: <terry(at)ashtonwoodshomes(dot)com>
To: "Postgres (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: function restore order
Date: 2003-08-26 11:33:55
Message-ID: 003c01c36bc6$342459c0$2766f30a@development.greatgulfhomes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am running 7.2.4

I have 2 functions:
get_deficiency_days_old()
and
get_deficiency_days_old_sub()

The former basically is just a wrapper for the latter.

The problem is that when I restored from a pg_dump script, the former was
recreated first, and so the function create command failed because the sub
was not created yet:
CREATE FUNCTION "get_deficiency_days_old" (integer) RETURNS integer
<snip...>
ERROR: Function 'get_deficiency_days_old_sub(date, timestamp, bpchar)' does
not
exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts

Is there a way to set dependencies or order for the function backups when
using pg_dump?

Thanks

Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
terry(at)greatgulfhomes(dot)com
Fax: (416) 441-9085

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Björklund 2003-08-26 11:34:48 Re: Index usage
Previous Message Pedro Alves 2003-08-26 11:32:23 Re: Index usage and wrong cost analisys