On Sat, 12 Oct 2002, Tom Lane wrote:

> Steven Singer <[EMAIL PROTECTED]> writes:

>       get_namespace_name(RelationGetNamespace(tg_relation))
> Is this sufficiently useful to justify adding an SPI_getrelnamespace()
> function?  I'm not very clear on the uses for SPI_getrelname().  Most
> of the examples we have in contrib/ are using it for error messages,

Thanks that function does the job.

I have no problem using that function(or other backend functions) from 
triggers to do the job.  If the idea behind SPI is that functions are only 
supposed to access backend functions through SPI and not call the backend 
directly  then it probably should be added at some point for completeness 
sake but I suspect other functions would fall into this category as well. 



-- 
Steven Singer                                       [EMAIL PROTECTED]
Aircraft Performance Systems                Phone:  519-747-1170 ext 282
Navtech Systems Support Inc.                AFTN:   CYYZXNSX SITA: YYZNSCR
Waterloo, Ontario                           ARINC:  YKFNSCR


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Reply via email to