Postgres Pro
Downloads
Home   >   mailing lists

Thread: please help me. I can't pg_dumg DB

please help me. I can't pg_dumg DB

From
peeratat tungsungnern
Date:
 
My HDD has bad sector and i can change new HDD. I have a ploblem can't back up database and display massage is:
 
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  cache lookup failed for function 137832813
pg_dump: The command was: SELECT tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc FROM pg_catalog.pg_attrdef WHERE adrelid = '146944117'::pg_catalog.oid
 
please help me  and Thank you before.
 
                                                                  Mr.Peeeratat Tungsungnern

Hotmail: Powerful Free email with security by Microsoft. Get it now.

Re: please help me. I can't pg_dumg DB

From
Bill Moran
Date:
In response to peeratat tungsungnern <peeratat_4521347@hotmail.com>:
>
> My HDD has bad sector and i can change new HDD. I have a ploblem can't back up database and display massage is:
>
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR:  cache lookup failed for function 137832813
> pg_dump: The command was: SELECT tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc FROM
pg_catalog.pg_attrdefWHERE adrelid = '146944117'::pg_catalog.oid 

When asking for help, it's generally worthwhile to provide _at_least_ the
version of PostgreSQL that you're using.

However, on a guess, I'm guessing it's a slightly older version that has
that limitation where cached names don't get cleared when the objects are
deleted.  Try restarting PostgreSQL and see if that fixes the problem.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/