Re: Error while restoring database - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Error while restoring database
Date
Msg-id 840.1003695505@sss.pgh.pa.us
Whole thread Raw
In response to Error while restoring database  ("Johann Zuschlag" <zuschlag@online.de>)
List pgsql-hackers
"Johann Zuschlag" <zuschlag@online.de> writes:
> create function numeric_neq(numeric,float8) returns bool as '
>     select $1 = $2::numeric;
> ' language 'sql';

> create operator <> (
>  leftarg=numeric,
>  rightarg=float8,
>  procedure=numeric_neq,
>  commutator='<>',
>  negator='',  ^^^^^^^^^^
>  restrict=eqsel,
>  join=eqjoinsel
>  );

Well, there's your problem...

For 7.2, I have added some error checking to the system that will
prevent it accepting invalid operator names in commutator/negator
parameters.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Rod Taylor"
Date:
Subject: Re: Package support for Postgres
Next
From: Christof Petig
Date:
Subject: HISTORY (ecpg enhancements not yet mentioned)