Re: Fwd: Errors on pg_dumpall

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(dot)brodziak(at)gmail(dot)com> wrote:

> 2012/11/3 Craig Ringer <ringerc(at)ringerc(dot)id(dot)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"
>