On Thu, 2005-08-18 at 17:02 +0300, Andrus wrote:
> I created generic (for tables in different schemas) trigger function :
>
> CREATE OR REPLACE FUNCTION setlastchange() RETURNS "trigger"
> AS $$BEGIN
> UPDATE serverti SET lastchange='now' WHERE tablename=TG_RELNAME and
>schemaname=TG_SCHEMA;
On Thu, Aug 18, 2005 at 05:02:58PM +0300, Andrus wrote:
> How to determine schema name where table TG_RELNAME belongs in trigger
> function ?
You could use TG_RELID to query the system catalogs. See the
documentation for pg_class and pg_namespace.
--
Michael Fuhr
---(e
