operator. But still, shouldn't pg_dump look after it?
Any ideas how to fix this?
regards
Johann Zuschlag
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
create operator <> (
leftarg=numeric,
rightarg=float8,
procedure=numeric_neq,
commutator='<>',
negator='',
restrict=eqsel,
join=eqjoinsel
);
regards
Johann Zuschlag
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
346 or 280347 ?
Yes, seems so. See the attachment. Again, the negator stuff
never worked for numeric.
regards
Johann Zuschlag
[EMAIL PROTECTED]
euro=> select * from pg_operator where oid = 280346;
oprname | oprowner | oprprec | oprkind | oprisleft | oprcanhash | oprleft | oprright
344;
>
>so we can see why pg_dump is producing the bogus output.
I'm sorry. I'm not so deep in the internals of postgreSQL. I'm just
doing some psqlodbc-supports and tests.
Attached you find the results of the above selects.
regards
Johann Zuschlag
[EMAIL PROTECTED]
euro=