Hi
Okay, I have found a reference to that oid in pg_type as under :
select * from pg_type where typnamespace=74363 ;
-[ RECORD 1 ]--+-----------------
typname | city
typnamespace | 74363
typowner | 10
typlen | -1
typbyval | f
typtype | c
typcategory | C
typispreferred | f
typisdefined | t
typdelim | ,
typrelid | 74364
typelem | 0
typarray | 74365
typinput | record_in
typoutput | record_out
typreceive | record_recv
typsend | record_send
typmodin | -
typmodout | -
typanalyze | -
typalign | d
typstorage | x
typnotnull | f
typbasetype | 0
typtypmod | -1
typndims | 0
typcollation | 0
typdefaultbin |
typdefault |
typacl |
-[ RECORD 2 ]--+-----------------
typname | _city
typnamespace | 74363
typowner | 10
typlen | -1
typbyval | f
typtype | b
typcategory | A
typispreferred | f
typisdefined | t
typdelim | ,
typrelid | 0
typelem | 74366
typarray | 0
typinput | array_in
typoutput | array_out
typreceive | array_recv
typsend | array_send
typmodin | -
typmodout | -
typanalyze | array_typanalyze
typalign | d
typstorage | x
typnotnull | f
typbasetype | 0
typtypmod | -1
typndims | 0
typcollation | 0
typdefaultbin |
typdefault |
typacl |
Here is what I have in pg_namespace :
oid | nspname | nspowner | nspacl
-------+--------------------+----------+----------------------------
99 | pg_toast | 10 |
11194 | pg_temp_1 | 10 |
11195 | pg_toast_temp_1 | 10 |
11 | pg_catalog | 10 | {sns84=UC/sns84,=U/sns84}
2200 | public | 10 | {sns84=UC/sns84,=UC/sns84}
11459 | information_schema | 10 | {sns84=UC/sns84,=U/sns84}
82537 | world | 10 |
(7 rows)
What I should do next ?
Please help
Thanks
T
On 5 November 2012 14:09, Lukasz Brodziak
<lukasz.brodziak@gmail.com> wrote:
2012/11/3 Craig Ringer <ringerc@ringerc.id.au>:
Hi,
Run the following SELECT on the database: select oid,* from
pg_namespace this will bring up all the schemas in the db along with
the OIDs. Check what schema name is under the OID given in error then
try to delete all the referrences to this schema name from db and run
pg_dumpall again.
Of course before doing so stop the PostgreSQL server and make a copy
of the data folder just in case.
Regards
--
Łukasz Brodziak
"Do you bury me when I'm gone
Do you teach me while I'm here
Just as soon I belong
Then it's time I disappear"