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),
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