Re: [HACKERS] Accessing non catalog table in backend

2016-01-11 Thread Atri Sharma
On Mon, Jan 11, 2016 at 10:48 PM, Atri Sharma wrote: > Sorry, I missed this email. > > I was specifically targeting accessing tables inside Node evaluation hence > do not want to add new nodes. > > Thanks for your inputs! > > Regards, > > Atri > > On Tue, Jan 5, 2016 at 11:43 AM, Amit Langote < >

Re: [HACKERS] Accessing non catalog table in backend

2016-01-11 Thread Atri Sharma
On Tue, Jan 5, 2016 at 11:09 AM, Tom Lane wrote: > Atri Sharma writes: > > I fail to see the relevance of which node is getting evaluated (its a > Plan > > node BTW) for this question. The concern I had was around using SPI > inside > > executor and its fail safety. > > The code path executor ->

Re: [HACKERS] Accessing non catalog table in backend

2016-01-11 Thread Atri Sharma
Sorry, I missed this email. I was specifically targeting accessing tables inside Node evaluation hence do not want to add new nodes. Thanks for your inputs! Regards, Atri On Tue, Jan 5, 2016 at 11:43 AM, Amit Langote wrote: > On 2016/01/05 14:30, Atri Sharma wrote: > > On Tue, Jan 5, 2016 at

Re: [HACKERS] Accessing non catalog table in backend

2016-01-04 Thread Amit Langote
On 2016/01/05 14:30, Atri Sharma wrote: > On Tue, Jan 5, 2016 at 9:54 AM, Amit Langote >> On 2016/01/05 3:53, Atri Sharma wrote: >>> I was wary to use SPI inside the executor for node evaluation functions. >>> Does it seem safe? >> >> What is "node evaluation functions"? Is it "Plan" nodes or "Exp

Re: [HACKERS] Accessing non catalog table in backend

2016-01-04 Thread Tom Lane
Atri Sharma writes: > I fail to see the relevance of which node is getting evaluated (its a Plan > node BTW) for this question. The concern I had was around using SPI inside > executor and its fail safety. The code path executor -> PL function -> SPI certainly works, so presumably omitting the in

Re: [HACKERS] Accessing non catalog table in backend

2016-01-04 Thread Atri Sharma
On Tue, Jan 5, 2016 at 9:54 AM, Amit Langote wrote: > On 2016/01/05 3:53, Atri Sharma wrote: > > I was wary to use SPI inside the executor for node evaluation functions. > > Does it seem safe? > > What is "node evaluation functions"? Is it "Plan" nodes or "Expr" nodes > that you are talking about

Re: [HACKERS] Accessing non catalog table in backend

2016-01-04 Thread Amit Langote
On 2016/01/05 3:53, Atri Sharma wrote: > I was wary to use SPI inside the executor for node evaluation functions. > Does it seem safe? What is "node evaluation functions"? Is it "Plan" nodes or "Expr" nodes that you are talking about? I guess you'd know to use ExecProcNode() or ExecEvalExpr() for

Re: [HACKERS] Accessing non catalog table in backend

2016-01-04 Thread Jim Nasby
On 1/4/16 12:53 PM, Atri Sharma wrote: Please don't top-post. On 5 Jan 2016 12:20 am, "Jim Nasby" mailto:jim.na...@bluetreble.com>> wrote: On 1/4/16 12:07 PM, Atri Sharma wrote: Hi All, I wanted to check if it is possible to query a non catalog table in backend.

Re: [HACKERS] Accessing non catalog table in backend

2016-01-04 Thread Atri Sharma
Thanks! I was wary to use SPI inside the executor for node evaluation functions. Does it seem safe? Regards, Atri On 5 Jan 2016 12:20 am, "Jim Nasby" wrote: > On 1/4/16 12:07 PM, Atri Sharma wrote: > >> Hi All, >> >> I wanted to check if it is possible to query a non catalog table in >> backen

Re: [HACKERS] Accessing non catalog table in backend

2016-01-04 Thread Jim Nasby
On 1/4/16 12:07 PM, Atri Sharma wrote: Hi All, I wanted to check if it is possible to query a non catalog table in backend. I understand that cql interface is only for catalog querying hence it is not usable for this purpose per se. AFAIK it's possible to do it with low level routines, but I

[HACKERS] Accessing non catalog table in backend

2016-01-04 Thread Atri Sharma
Hi All, I wanted to check if it is possible to query a non catalog table in backend. I understand that cql interface is only for catalog querying hence it is not usable for this purpose per se. Please advice. Regards, Atri