[HACKERS] Error while restoring database

2001-10-19 Thread Johann Zuschlag
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]

Re: [HACKERS] Error while restoring database

2001-10-22 Thread Johann Zuschlag
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

Re: [HACKERS] Error while restoring database

2001-10-22 Thread Johann Zuschlag
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

Re: [HACKERS] Error while restoring database

2001-10-22 Thread Johann Zuschlag
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=