On 1/4/16 12:53 PM, Atri Sharma wrote:
Please don't top-post.
On 5 Jan 2016 12:20 am, "Jim Nasby" <jim.na...@bluetreble.com
<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.

        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 think
    unless you have a really good reason to go that route you're much
    better off just using SPI. If it's good enough for plpgsql... :)

> I was wary to use SPI inside the executor for node evaluation functions.
> Does it seem safe?

Oh, inside the executor? Yeah, I doubt attempting SPI there would end well...

What exactly are you trying to do?
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to