Triggers and Schema's.

Поиск
Список
Период
Сортировка
От Steven Singer
Тема Triggers and Schema's.
Дата
Msg-id Pine.LNX.4.33.0210121925050.26039-100000@pcNavYkfAdm1.ykf.navtechinc.com
обсуждение исходный текст
Ответы Re: Triggers and Schema's.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I've been testing contrib/dbmirror with 7.3 and schema's and have come 
across a problem.

SPI_getrelname(tg_relation) can be used by a trigger to get the name of 
the table that the trigger was fired on.  But that just gives the 
tablename and not the schema that the table is in.  If you have a schema 
named "A" and a schema named "B" each with an employee table how can a 
trigger determine if it was fired on A.employee or B.employee.

Thanks

-- 
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 по дате отправления:

Предыдущее
От: Neophytos Demetriou
Дата:
Сообщение: 7.3b2 ?bug? bitfromint4 is not working
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 7.3b2 ?bug? bitfromint4 is not working