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 <ram.wis...@gmail.com> 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 a suggestion from Tom Lane to try > that select with enable_indexscan and enable_bitmapscan > turned off. > > This question is probably better asked in the "General" mailing list. Also > please include the OS and PostgreSQL version as well as any other > observations that may shed light on the issue. > > Cheers, > Steve > -- -Joseph Curtin http://www.jbcurtin.com <http://www.jbcurtin.com/>github <http://goo.gl/d5uPH> @jbcurtin
