[Pljava-dev] Re: the relation ID of the table on which the trigger occured.

From: thhal at mailblocks(dot)com (Thomas Hallgren)
To:
Subject: [Pljava-dev] Re: the relation ID of the table on which the trigger occured.
Date: 2005-05-25 09:15:36
Message-ID: thhal-0utpvA/H0zTYRP8VB2BsoxS0/nuwSqQ@mailblocks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

Marek Lewczuk wrote:

> Thomas Hallgren napisa?(a):
>
>> The TriggerData.getTableName() will give you the name of the relation.
>
> True, but it returns only table's name, without schema name - table's
> name can't be used as a true identifier of given table (because table
> e.g. "pljavaexample" can exists in many schemas) and because of that
> relation ID is needed.

That's a bug in that case. The table must of course be qualified.

>> 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.
>
> I understand, however that can lead to many other losts on the pljava's
> functionality - PostgreSQL is very complex and it contains many unique
> features, which are not available in other RDBMS.

No, there will be no functionality loss. Just a clear separation of
concern. The idea is that if you want to write portable code, then stick
with the public interfaces. If you want to do PostgreSQL specific stuff,
use pljava.internal stuff.

Regards,
Thomas Hallgren

In response to

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Marek Lewczuk 2005-05-25 09:43:55 [Pljava-dev] Re: the relation ID of the table on which the trigger occured.
Previous Message Marek Lewczuk 2005-05-25 08:32:59 [Pljava-dev] Re: the relation ID of the table on which the trigger occured.