Re: Bug in PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxxxxx> wrote:


On Wed, Jun 27, 2018 at 8:31 AM Rambabu V <ram.wissen@xxxxxxxxx> 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
github
@jbcurtin

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux