On Sun, Oct 7, 2012 at 3:17 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Atri Sharma <atri.j...@gmail.com> writes: >> The issue I am trying to resolve is that if two scans are taking place >> on the same backend(due to the same query),then,the server is >> crashing. > > That sounds like an FDW bug ... which FDW are we talking about? > >> I think it is because I am not saving the state of the scan,so,if >> multiple scans a re running on the same backend,then,it is causing the >> crash. > > The FDW should certainly not assume that only one scan can happen at a > time. I would not think this would be a problem as long as you're using > reasonable coding techniques, like keeping scan-local state in > scan-local storage and not globally. > >> Any hints on how I can detect this condition please? > > If you are imagining that you'd do something differently depending on > whether the current query contains multiple ForeignScan nodes for your > FDW, that's still doomed to lose, because of nested queries. You really > need to manage storage in a way that doesn't make assumptions of this > sort. > > regards, tom lane
Hi Tom, Thanks for the reply. Does that mean that using (some) global storage is the cause of the problem? Atri -- Regards, Atri l'apprenant -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
