> "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
On Feb 13, 2007, at 1:55 PM, Jonathan Vanasco wrote:
> i need to :
> delete from person_2_place where person_id = ?
>
> can this only be done as a manager method with a raw query?
Manager::delete_objects seems to be the answer. nevermind. i was
looking in the wrong class.
// Jonath
I can't seem to figure this out - its simple.
I have a m2m mapping table:
person_2_place :
person_id references person(id)
place_id references place(id)
both are indexes.
i need to :
delete from person_2_place where person_id = ?
can this only b
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
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
On 2/13/07, Graham Barr <[EMAIL PROTECTED]> wrote:
> This could be done by adding a column_exists method to RDBO which would
> only return true if the named column had been loaded from the DB or set
> by calling the accessor method. And have ->load use column_exists instead
> of defined when passed
