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