Would this SPI function be useful? - Mailing list pgsql-hackers

From Jeff Davis
Subject Would this SPI function be useful?
Date
Msg-id 1169517086.20694.40.camel@dogma.v10.wvs
Whole thread Raw
List pgsql-hackers
Would it be useful to have an SPI function that returns the OID and
namespace of the function being executed?

The reason I bring this up is due to a discussion on the PostGIS lists
about making the installation able to work in any namespace from one
generic SQL script.

The problem they have is that, because the functions don't know what
schema they reside in, they don't know how to call out to other
functions in the same namespace.

It might be useful to have a few basic functions that allow developers
of add-ons to access information like that. What come to my mind are:

SPI_get_my_oid();
SPI_get_my_nspname();

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: Re: Strange file in snapshot tarball
Next
From: Jeff Davis
Date:
Subject: Re: 10 weeks to feature freeze (Pending Work)