Re: Bug in PostgreSQL

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 <
scrawford(at)pinpointresearch(dot)com> wrote:

>
>
> On Wed, Jun 27, 2018 at 8:31 AM Rambabu V <ram(dot)wissen(at)gmail(dot)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