Re: Triggers and Schema's.

Поиск
Список
Период
Сортировка
От Steven Singer
Тема Re: Triggers and Schema's.
Дата
Msg-id Pine.LNX.4.33.0210150136500.32116-100000@pcNavYkfAdm1.ykf.navtechinc.com
обсуждение исходный текст
Ответ на Re: Triggers and Schema's.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sat, 12 Oct 2002, Tom Lane wrote:

> Steven Singer <ssinger@navtechinc.com> 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                                       ssinger@navtechinc.com
Aircraft Performance Systems                Phone:  519-747-1170 ext 282
Navtech Systems Support Inc.                AFTN:   CYYZXNSX SITA: YYZNSCR
Waterloo, Ontario                           ARINC:  YKFNSCR



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: interesting side effect of autocommit = off
Следующее
От: Joe Conway
Дата:
Сообщение: Re: interesting side effect of autocommit = off