Thread: About the portal in postgres

<div dir="ltr">My doubt is when the query enters into a portal, does it stay in the portal till the final execution ?
i.e.Do the further function calls such as DefineRelation,create_heap_with_catalog etc. for Create query occur inside
theportal ?<br /></div> 

<div dir="ltr"><br /><div class="gmail_extra"><br /><br /><div class="gmail_quote">On Fri, Mar 14, 2014 at 12:29 PM,
TanmayDeshpande <span dir="ltr"><<a href="mailto:tp.deshpande07@gmail.com"
target="_blank">tp.deshpande07@gmail.com</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px#ccc solid;padding-left:1ex"><div dir="ltr">My doubt is when the query enters into a portal, does
itstay in the portal till the final execution ? i.e. Do the further function calls such as
DefineRelation,create_heap_with_catalogetc. for Create query occur inside the portal ?<br
/></div></blockquote></div><br/><br /></div><div class="gmail_extra">What do you mean by 'Portal' ?<br /><br
/></div><divclass="gmail_extra">Regards,<br /><br />Atri<br /></div></div> 

On Fri, Mar 14, 2014 at 12:29 PM, Tanmay Deshpande
<tp.deshpande07@gmail.com> wrote:
> My doubt is when the query enters into a portal, does it stay in the portal
> till the final execution ?

Yes, portal represents the execution state of query, after the
optimizer creates the
plan, portal is used in execution of query.


With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com