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 [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 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
