Re: [HACKERS] Triggers and Schema's.

2002-10-14 Thread Steven Singer
On Sat, 12 Oct 2002, Tom Lane wrote: > Steven Singer <[EMAIL PROTECTED]> 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

Re: [HACKERS] Triggers and Schema's.

2002-10-12 Thread Tom Lane
Steven Singer <[EMAIL PROTECTED]> writes: > 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

[HACKERS] Triggers and Schema's.

2002-10-12 Thread Steven Singer
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 s