platform: PostgreSQL 7.3.4, RedHat 7.3, linux 2.4.18
I've recently tried to restore my database and get this:
pg_restore: [archiver (db)] could not execute query: ERROR: Function pftype_id_lookup(text) does not exist
Unable to identify a function that satisfies the given argument types
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Reece Hart <[EMAIL PROTECTED]> writes:
> > I have a hunch about why this happens and is rare. The pftype_id_lookup
> > function was created AFTER some of the tables using 'alter table set
> > default ...'. Thus, the function's OID is greater than the OID of t
Reece Hart <[EMAIL PROTECTED]> writes:
> I have a hunch about why this happens and is rare. The pftype_id_lookup
> function was created AFTER some of the tables using 'alter table set
> default ...'. Thus, the function's OID is greater than the OID of the
> tables which use them.
Yeah, this is a w
platform: PostgreSQL 7.3.4, RedHat 7.3, linux 2.4.18
I've recently tried to restore my database and get this:
pg_restore: [archiver (db)] could not execute query: ERROR: Function pftype_id_lookup(text) does not exist
Unable to identify a function that satisfies the given argument type
