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:

Reply via email to