[Postgres-xl-general] PLPGSQL, temp tables and inserts

Aaron Jackson ajackson at revionics.com
Tue Dec 9 13:37:37 PST 2014


Hard to be 100% confident, but this patch appears to have alleviated the problem.  Thank you.

Aaron
________________________________
From: Pavan Deolasee [pavan.deolasee at gmail.com]
Sent: Friday, December 05, 2014 6:17 AM
To: Aaron Jackson
Cc: postgres-xl-general at lists.sourceforge.net
Subject: Re: [Postgres-xl-general] PLPGSQL, temp tables and inserts



On Wed, Dec 3, 2014 at 2:04 PM, Pavan Deolasee <pavan.deolasee at gmail.com<mailto:pavan.deolasee at gmail.com>> wrote:


On Wed, Dec 3, 2014 at 12:46 PM, Pavan Deolasee <pavan.deolasee at gmail.com<mailto:pavan.deolasee at gmail.com>> wrote:


On Wed, Dec 3, 2014 at 11:34 AM, Aaron Jackson <ajackson at revionics.com<mailto:ajackson at revionics.com>> wrote:


 Re-ran the test case above and still see failure with "could not open relation with OID 0".  What little bit of investigation I've been able to uncover shows that the PlannedStmt (and I believe the QueryDesc) were submitted with an OID of 0 - hence the failure.
Hmm. That's surprising. This commit is supposed to handle exactly that case:


FWIW I've been able to reproduce this issue again. For some strange reason, it now happens from a new session on invokation of the same function. Will look into it.


Hi Aaron,

I've now pushed a fix for another instance of "could not open relation with OID 0" error. Would appreciate if you update your sources and retry. TBH I think the command ID management needs some refactoring to avoid such corner cases and I'm already on my way to do that, but thought an early fix specific to your test case may help you get further with your tests. So I decided to push this anyways.

Please let me know if this helps.

Thanks,
Pavan

--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20141209/689db285/attachment.htm>


More information about the postgres-xl-general mailing list