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
[EMAIL PROTECTED]
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)
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
