Re: [sqlalchemy] sqlalchemy and inheritance in postgres

2011-07-22 Thread Michael Bayer
On Jul 22, 2011, at 8:49 AM, jasonmclose wrote: > > my desire is to emulate this with sqlalchemy, Ok "emulate", meaning, you no longer want to use Postgresql INHERITS and want SQLA to deal with the multiple tables ?Assuming I haven't forgotten how INHERITS works (I've not used it myself),

[sqlalchemy] sqlalchemy and inheritance in postgres

2011-07-22 Thread jasonmclose
i seemed to have stumped SO, so i am trying with a repost here. here is an example of what our postgres database does (obviously, this is simplified): CREATE TABLE system (system_id SERIAL PRIMARY KEY, system_name VARCHAR(24) NOT NULL); CREATE TABLE file_entry(file_entry_id S