Null records in pg_operator

Поиск
Список
Период
Сортировка
От Sandeep Agarwal
Тема Null records in pg_operator
Дата
Msg-id 7e507c800709182248m5ee59b8ase41ac3f11a834c8f@mail.gmail.com
обсуждение исходный текст
Ответы Re: Null records in pg_operator  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
hello list,

i am facing problem while dumping a database. Here the error i am getting
# /usr/local/pgsql/bin/pg_dump -U postgres ihm  > ihm.sql
pg_dump: schema with OID 0 does not exist
#

i also tried dumping data-only but same error.

After googlging about the issue and checking the pg_catalogs i found
that pg_operator is having two null records

# /usr/local/pgsql/bin/psql -U postgres  -d ihm
ihm=# select * from pg_operator where oprnamespace is null;
 oprname | oprnamespace | oprowner | oprkind | oprcanhash | oprleft |
oprright | oprresult | oprcom | oprnegate | oprlsortop | oprrsortop |
oprltcmpop | oprgtcmpop | oprcode | oprrest | oprjoin

---------+--------------+----------+---------+------------+---------+----------+-----------+--------+-----------+------------+------------+------------+------------+---------+---------+---------
         |              |          |         |            |         |
        |           |        |           |            |            |
         |            |         |         |
         |              |          |         |            |         |
        |           |        |           |            |            |
         |            |         |         |
(2 rows)

ihm=#

i think this is the cause of the problem or is it normal to have null
rows in pg_operator. I tired deleting them but when i try to do so the
connection is terminated.

ihm=# delete from pg_operator where oprnamespace is null;
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>

i also tried removing these rows by starting postgres in single user mode.

Am i correct in my approach to the problem or i am headed in wrong direction ?

If i am correct how can i delete these null records, i dont have any
idea how they get in there because table structure of pg_operator says
that all the fields are not null.

postgres version 8.1.0

please let me know if more information is required.


thanks

Sandeep

В списке pgsql-novice по дате отправления:

Предыдущее
От: Mija Lee
Дата:
Сообщение: copy commands and linefeeds
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: copy commands and linefeeds