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.brodz...@gmail.com> wrote:
> 2012/11/3 Craig Ringer <ring...@ringerc.id.au>:
> > On 11/01/2012 10:05 PM, Terry Khatri wrote:
> >
> > Somebody PLEASE HELP ! is Tome Lane around !
> >
> >
> > http://www.postgresql.org/support/professional_support/
>
> 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"
>
