Re: Using CDBI with an ORDBMS

[prev] [thread] [next] [Date index for 2005/04/30]

On Fri, Apr 29, 2005 at 08:36:27PM -0700, Randal L. Schwartz wrote:
> I don't think CDBI does this inherently, at least not in anything I've
> seen.

It doesn't.

> Given a row returned from a Pg query, you can map it to its table
> name with:
> SELECT relname
> FROM pg_class
> WHERE relfilenode = (SELECT tableoid FROM $yourrow)
> So, if you can include tableoid as a return value, you can do the
> mapping and reblessing as needed.

You should be able to set up a fairly straightforward select trigger to
do this automagically, and rebless accordingly.

Tony