errors while restoring data.

Pritesh Shah <pritesh.krish@xxxxxxxxx> · Thu, 3 Feb 2005 15:20:21 -0700

hi,

I'm trying to restore some databases from the plain text format dumps.
To restore I'm using:

psql -e -f nmayande.sql template1 

I captured a small part while restoring the database which has an error, 

CREATE OPERATOR >= (
    PROCEDURE = daterange_greater_than_equals,
    LEFTARG = daterange,
    RIGHTARG = daterange,
    NEGATOR = <,
    RESTRICT = scalargtsel,
    JOIN = scalargtjoinsel
);
psql:/var/tmp/backup/pgsql/20050202/nmayande.sql:1272: ERROR: 
function daterange_greater_than_equals(daterange, daterange) does not
exist

These are some of the lines from the *.sql plain text dump file:

......
......

CREATE OPERATOR >= (
    PROCEDURE = daterange_greater_than_equals,
    LEFTARG = daterange,
    RIGHTARG = daterange,
    NEGATOR = <,
    RESTRICT = scalargtsel,
    JOIN = scalargtjoinsel
);

.......
.......

CREATE FUNCTION daterange_greater_than_equals(daterange,
daterange)RETURNS boolean
     AS '$libdir/daterange.so', 'daterange_greater_than_equals'
    LANGUAGE c;

.......
.......

I know that the CREATE FUNCTION part should come before using it in
CREATE OPERATOR. If it was one or two databases i would have edited
the plain text dump file by hand appropriately. But the problem is
this error spreads to lot of other database's plain text dump files
that i'm trying to restore. Please help me out so that i do not have
to do all this editing manually.

Thanks,
Pritesh

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx