Hi all,

Has anyone worked with Rose::DB::Object and PostgreSQL's table inheritance?
For example:

CREATE TABLE party (id INT PRIMARY KEY, birthday DATE);
CREATE TABLE person INHERITS party (firstname TEXT, lastname TEXT);
CREATE TABLE organization INHERITS party (name TEXT);

There are also a couple of triggers to make sure that id's are unique across
the whole hierarchy (because PostgreSQL currently doesn't automatically
enforce it).

So what is the best way to front this in Rose::DB::Object, also using
inheritance?

Regards,
Pascal
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object

Reply via email to