Re: [RDBO] Rose::DB::Object and table inheritance

2007-02-13 Thread Randal L. Schwartz
> "Jonathan" == Jonathan Vanasco <[EMAIL PROTECTED]> writes: Jonathan> FWIW, i dropped using table inheritance in postgres. the way it was Jonathan> internally handled wasn't fast enough - no matter how i keyed and Jonathan> indexed the tables or tried to influence the optimizer, the inte

Re: [RDBO] Rose::DB::Object and table inheritance

2007-02-13 Thread Jonathan Vanasco
On Feb 13, 2007, at 10:29 AM, Pascal Damian wrote: > 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); > CREA

[RDBO] Rose::DB::Object and table inheritance

2007-02-13 Thread Pascal Damian
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 cou