Hi,
On 2018-06-28 08:55:21 +0200, Laurenz Albe wrote:
> Rambabu V wrote:
> > While taking pgdump we are getting error message cache lookup failed for
> > function 7418447.
> > While trying select * from pg_proc where oid=7418447 returns zero rows.
> > Please help us on this.
>
> That means tha
Rambabu V wrote:
> While taking pgdump we are getting error message cache lookup failed for
> function 7418447.
> While trying select * from pg_proc where oid=7418447 returns zero rows.
> Please help us on this.
That means that some catalog data are corrupted.
If possible, restore from a backu
OID is a temp-var that is only consistent within a Query Execution.
https://www.postgresql.org/docs/current/static/datatype-oid.html
On Thu, Jun 28, 2018 at 12:50 AM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
>
>
> On Wed, Jun 27, 2018 at 8:31 AM Rambabu V wrote:
>
>> Hi Team,
>>
On Wed, Jun 27, 2018 at 8:31 AM Rambabu V wrote:
> Hi Team,
>
> While taking pgdump we are getting error message cache lookup failed for
> function 7418447. While trying select * from pg_proc where oid=7418447
> returns zero rows. Please help us on this.
>
Searching on that error messages yields
Hi Team,
While taking pgdump we are getting error message cache lookup failed for
function 7418447. While trying select * from pg_proc where oid=7418447
returns zero rows. Please help us on this.