Re: Bug in PostgreSQL

2018-06-28 Thread Andres Freund
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

Re: Bug in PostgreSQL

2018-06-27 Thread Laurenz Albe
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

Re: Bug in PostgreSQL

2018-06-27 Thread Joseph Curtin
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, >>

Re: Bug in PostgreSQL

2018-06-27 Thread Steve Crawford
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

Bug in PostgreSQL

2018-06-27 Thread Rambabu V
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.