On Sat, 20 Oct 2001 12:36:16 -0400, Tom Lane wrote:
>That's what you showed us already. What I'd like to see is the
>original database contents, particularly
>
> select * from pg_operator where oid = 280343;
> select * from pg_operator where oid = 280344;
>
>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
zuschlag@online.de
euro=> select * from pg_operator where oid = 280343;oprname | oprowner | oprprec | oprkind | oprisleft | oprcanhash |
oprleft| oprright | oprresult | oprcom | oprnegate | oprlsortop | oprrsortop | oprcode | oprrest | oprjoin
---------+----------+---------+---------+-----------+------------+---------+----------+-----------+--------+-----------+------------+------------+-------------+---------+-----------<>
| 27 | 0 | b | t | f | 1700 | 701 | 16 | 280346 | 280347 |
0 | 0 | numeric_neq | eqsel | eqjoinsel
(1 row)
euro=> select * from pg_operator where oid = 280344;oprname | oprowner | oprprec | oprkind | oprisleft | oprcanhash |
oprleft| oprright | oprresult | oprcom | oprnegate | oprlsortop | oprrsortop | oprcode | oprrest | oprjoin
---------+----------+---------+---------+-----------+------------+---------+----------+-----------+--------+-----------+------------+------------+------------+---------+-----------=
| 27 | 0 | b | t | f | 1700 | 701 | 16 | 280342 | 280343 |
0 | 0 | numeric_eq | eqsel | eqjoinsel
(1 row)