On 2/10/16 11:33 AM, Pavel Stehule wrote:
I don't think that really makes sense. I would expect schema variables to be exposed to a function as variables or attributes, either in the global namespace for that PL, or as an attribute of some object (ie the plpy object in plpython). I don't know a python, and I don't know what is possible there and what I know. Set/Get function I can implement in any PL other than PLpgSQL. You have to do conversion from Postgres type to PL types and I can do it in function.
Requiring PLs to go through the native SPI to get to schema variables is just plain ugly and inefficient. Why wouldn't they be exposed natively?
Not designing these things through is how we ended up with the mess that is composite types and arrays in plpython and pltcl. I'm not saying any PLs besides plpgsql need to support this natively out of the box, but we better have an idea of how they would support it (and it'd be a good idea if at least one other PL did support it).
-- 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 (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers