On 31.10.2010 14:46, Dimitri Fontaine wrote:
What we could do is offer extension's author a way to find their
operator or functions or whatever dynamically in SQL, so that writing
robust pure-SQL functions is possible. What comes to mind now would be a
way to call a function/operator/... by OID at the SQL level. Not pretty
but with the pg_extension_objects() SRF and maybe a layer atop that,
that would do the trick. Brain dumping still.
How about something like:
CREATE EXTENSION myextension ... SCHEMA myschema;
And in the .sql file in the extension you could have special markers for
the schema, something like:
CREATE FUNCTION otherfunction() AS ...;
CREATE FUNCTION foo() AS $$ SELECT 'foo', @extsch...@.otherfunction() $$;
@extschema@ would be search&replaced at CREATE EXTENSION time with the
schema specified by the user.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
