| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Johann Zuschlag" <zuschlag(at)online(dot)de> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Error while restoring database |
| Date: | 2001-10-21 20:18:25 |
| Message-ID: | 840.1003695505@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Johann Zuschlag" <zuschlag(at)online(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aasmund Midttun Godal | 2001-10-21 22:26:03 | Re: CREATE RULE ON UPDATE/DELETE |
| Previous Message | Johann Zuschlag | 2001-10-21 20:03:52 | Re: Error while restoring database |