On Nov 1, 2012, at 12:15 PM, junepeach wrote:
> When I removed all of op.execute('drop view xxx') and op.execute('create view
> xxx as ...') scripts, all of commands work fine even in Postgresql. I think
> this is because I have put clear relationship in table class in my schema
> module:
>
> class Mytable(Base):
> __tablename__ = 'tbl_mytable
> id = Column(String(15), primary_key = True)
> name = Column(String(25))
> ...
> children = relationship('Yourtable')
er no, relationship() has nothing to do with the structures that are created in
your database. The error you are getting clearly states that you've emitted a
"CREATE VIEW" that depends upon another VIEW in your postgresql schema, so that
dependee-view cannot be dropped without dropping the dependent view.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
