Hello,
I'm using SQLAlchemy 0.1.6. I was working my way through
the documentation (taking a couple of side trips on the way ;-).
Anyway I performed this sequence:
from sqlalchemy import *
engine = create_engine('postgres://database=sat&user=wkv')
departments = Table('departments', engine,
Column('department_id', Integer, primary_key=True),
Column('department_name', String(40), nullable=False))
employees = Table('employees', engine,
Column('employee_id', Integer, primary_key=True),
Column('employee_name', String(60), nullable=False, key='name'),
Column('employee_dept', Integer,
ForeignKey("departments.department_id"))
)
departments.create()
employees.create()
engine.commit()
employees.drop()
employees.create()
employees.insert().execute(name='fred')
exit python
-- Worked fine however:
from sqlalchemy import *
engine = create_engine('postgres://database=sat&user=wkv')
employees = Table('employees', engine, autoload=True)
employees.drop()
employees.create()
employees.insert().execute(employee_name='fred')
Returned the error:
SQLError: (ProgrammingError) ERROR: relation
"public.employees_employee_id_seq" does not exist
select nextval('public.employees_employee_id_seq'::text) "select
nextval('public.employees_employee_id_seq'::text)" {}
psql (PostgreSQL) 8.0.7.
Admittedly one of those thorny special case problems.
If you use create sequence followed by create table then the two
exist independently. Using create table with serial gives you a
dependent object that gets dropped when the table is dropped.
Tracking back on pg_depends might look like:
select relname from pg_class
where relfilenode in (select objid from pg_depend
where refobjid=(select relfilenode from pg_class
where relname='employees'));
will return the name of the sequence if it's dependent
on the table.
HTH,
William.
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
