Problem solved and another one

[prev] [thread] [next] [Date index for 2004/12/14]

Hi,
I solved the problem raised in my last question using the patch for
DBD::Pg mentioned in [1]. However, now I have another.
Postgresql is object-oriented, and, as such, allows stuff like this:
--
create table nota (
	nota_texto text,
	nota_fecha timestamp
);

create table nota_persona (
	persona_id integer references persona on delete cascade
) inherits (nota);
--

How can this reflected in a CDBI class structure? Obviously, Nota.pm
would reflect 'nota', but what about 'nota_persona'? It adds a column
to 'nota', but, as far as I have seen, there's no way to inherit and
change the number of columns, not even a low-level one. There seems to
be no support for this feature in CDBI::Pg, either.
Of course, different classes with no inheritance can be created, but
that would not be cool (TM).

I'd be grateful for any help

JJ


[1]http://gborg.postgresql.org/pipermail/dbdpg-general/2004-June/001007.html