On 11/23/2015 03:15 PM, Adrian wrote: > I attached a script that reproduces the problem. It actually only > happens if the metadata contains a schema, then the tablename in the > INHERITS() clause get quoted, which causes the problem.
anyway, there's no direct "postgresql_inherits_schema" feature as of yet, so yo can work around that you have to artificially place the schema name inside of the table name using direct quote control: from sqlalchemy.sql.elements import quoted_name child = Table( "child", metadata, Column("bar", String(4), nullable=False), postgresql_inherits=quoted_name(parent.fullname, quote=False), prefixes=["UNLOGGED"]) > > On Monday, November 23, 2015 at 7:13:27 PM UTC+1, Adrian wrote: > > I actually I just found the problem; the tables are in fact created > in the right order - the problem is that the DDL contains INHERITS ( > "parent" ). It gives the same error if I try to run the code in a > GUI with the inherited table name quoted, without (the quoting) > though it works. > > On Mon, Nov 23, 2015 at 6:55 PM Mike Bayer <mike...@zzzcomputing.com > <mailto:mike...@zzzcomputing.com>> wrote: > > > > On 11/23/2015 12:43 PM, Adrian wrote: > > Hello, > > > > I have the following problem - I recently upgraded to the 1.0+ > branch > > from 0.9 and now the PostgreSQL table inheritance does not > work properly > > any longer because the tables that inherit from the master > table are > > sometimes created before (random) the actual table they > inherit from, > > throwing (psycopg2.ProgrammingError) relation "<table>" does > not exist > > errors. With the 0.9+ branch a simple add_is_dependent_on was > working to > > solve this but it does not seem to be taken into account anymore. > > this is not the case, that API is still taken into account. I can > remove the code that does so and the test which exercises this > feature > then fails, so it is also tested. > > Can you please provide a full reproducing test case? It needs > to be > succinct, single file, and runnable by me, thanks. > > > > > Is > > there something that changed from 0.9 to 1.0 that needs to be > done to > > get it to work? metadata.sorted_tables returns the proper > table order > > (master table first, dependencies later) though but tables are not > > created in that order by metadata.create_all(). > > > > Thanks, > > > > Adrian > > > > -- > > You received this message because you are subscribed to the Google > > Groups "sqlalchemy" group. > > To unsubscribe from this group and stop receiving emails from > it, send > > an email to sqlalchemy+unsubscr...@googlegroups.com > <mailto:sqlalchemy%2bunsubscr...@googlegroups.com> > > <mailto:sqlalchemy+unsubscr...@googlegroups.com > <mailto:sqlalchemy%2bunsubscr...@googlegroups.com>>. > > To post to this group, send email to > sqlalchemy@googlegroups.com <mailto:sqlalchemy@googlegroups.com> > > <mailto:sqlalchemy@googlegroups.com > <mailto:sqlalchemy@googlegroups.com>>. > > Visit this group at http://groups.google.com/group/sqlalchemy > <http://groups.google.com/group/sqlalchemy>. > > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > -- > You received this message because you are subscribed to a topic > in the Google Groups "sqlalchemy" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/sqlalchemy/k4Lhj7i5sBM/unsubscribe > > <https://groups.google.com/d/topic/sqlalchemy/k4Lhj7i5sBM/unsubscribe>. > To unsubscribe from this group and all its topics, send an email > to sqlalchemy+unsubscr...@googlegroups.com > <mailto:sqlalchemy%2bunsubscr...@googlegroups.com>. > To post to this group, send email to sqlalchemy@googlegroups.com > <mailto:sqlalchemy@googlegroups.com>. > Visit this group at http://groups.google.com/group/sqlalchemy > <http://groups.google.com/group/sqlalchemy>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > -- > You received this message because you are subscribed to the Google > Groups "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to sqlalchemy+unsubscr...@googlegroups.com > <mailto:sqlalchemy+unsubscr...@googlegroups.com>. > To post to this group, send email to sqlalchemy@googlegroups.com > <mailto:sqlalchemy@googlegroups.com>. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.