From: thhal at mailblocks.com (Thomas Hallgren)
Date: Wed, 25 May 2005 09:50:26 +0200
Subject: [Pljava-dev] the relation ID of the table on which the trigger
	occured.
In-Reply-To: <d71a0u$lbt$1@sea.gmane.org>
References: <d71a0u$lbt$1@sea.gmane.org> <42942E42.9090005@mailblocks.com>
	<thhal-0xMZvA9X0zTYdkH7uFjvrCJvJ6lNMHk@mailblocks.com>
Message-ID: <thhal-0xcZvA9f0zTYJXwu2y5ljtHShqmiCii@mailblocks.com>

Marek Lewczuk wrote:

> Hi,
> I think that TriggerData class is missing getRelationID method - this 
> should return  OID of the table on which the trigger fired. Can I get 
> table's OID which fired the trigger in other way ?

The TriggerData.getTableName() will give you the name of the relation. 
The TriggerData interface is designed to be as database agnostic as 
possible (to allow other vendors to use the same interface) and the 
relation OID is very PostgreSQL specific.

We might add a method on the Oid class in the future. Something like:

    public static Oid forRelationName(String relationName)

but at present you must use SQL to obtain the OID.

Regards,
Thomas Hallgren