| 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 18:14:05 |
| Message-ID: | 28834.1003688045@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:
>> Okay ... are there any rows in pg_operator with OID 280346 or 280347 ?
> Yes, seems so. See the attachment. Again, the negator stuff
> never worked for numeric.
Looks like these are "shell" operator definitions left over from
commutator or negator forward references that were never satisfied.
pg_dump did the right thing to not dump them. I'd say that the backend
should never have accepted a shell operator def with an empty name,
though, which is what you seem to have at OID 280347.
Do you happen to have the exact command that you gave to create
operator 280343 (numeric_neq)? I think what this really boils down
to is insufficient error checking somewhere in CREATE OPERATOR.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Serguei Mokhov | 2001-10-21 18:40:45 | Re: namespaces |
| Previous Message | Johann Zuschlag | 2001-10-21 17:54:03 | Re: Error while restoring database |