February 25th, 2013, 11:13 AM
Join Date: Feb 2013
Time spent in forums: 2 h 17 m 50 sec
Reputation Power: 0
Restore pg_dump errors
I am getting the following errors while trying to restore a dump -
ERROR: function echo_update_to_ser() does not exist
ERROR: function echo_insert_to_ser() does not exist
The strange part is that I see the function being created prior to the trigger calling the function -
CREATE FUNCTION echo_insert_to_ser() RETURNS "trigger"
CREATE TRIGGER echo_insert_bank_to_ser
AFTER INSERT ON tb_bank
FOR EACH ROW
EXECUTE PROCEDURE echo_insert_to_ser();
The pg_dump was taken from pgsql version 8.1, OS - Linux. And I attempted to restore on pgsql version 8.4, OS - Linux.
Any help would be appreciated. I am quite the beginner when it comes to postgres.