Re: Drop followed by generation of Foreign Keys

2015-09-21 16:13 GMT-07:00 Mike Bayer : > > Are you sure you don't have any in-application event handlers or similar > manipulating search_path? Can you put this in your env.py and tell me > what it says? > > with connectable.connect() as connection: > >

Re: Drop followed by generation of Foreign Keys

On 9/21/15 6:09 PM, Sergi Pons Freixes wrote: 2015-09-21 14:18 GMT-07:00 Mike Bayer >: OK, I'm still not able to reproduce (see attached), as long as include_schemas=True. However, in your env.py, you have this:

Re: Drop followed by generation of Foreign Keys

On 9/21/15 8:14 PM, Sergi Pons Freixes wrote: 2015-09-21 16:55 GMT-07:00 Mike Bayer >: Can you run the above with logging enabled? That is the [alembic] logger turned on as in the default alembic.ini. Sure thing, this

Re: Drop followed by generation of Foreign Keys

On 9/21/15 7:32 PM, Sergi Pons Freixes wrote: 2015-09-21 16:13 GMT-07:00 Mike Bayer >: Are you sure you don't have any in-application event handlers or similar manipulating search_path? Can you put this in your env.py

Re: Drop followed by generation of Foreign Keys

2015-09-21 16:55 GMT-07:00 Mike Bayer : > Can you run the above with logging enabled? That is the [alembic] logger > turned on as in the default alembic.ini. > Sure thing, this was the output: $ alembic -c development.ini revision -m "upgrade" --autogenerate

Re: Drop followed by generation of Foreign Keys

2015-09-21 14:18 GMT-07:00 Mike Bayer : > > > > OK, I'm still not able to reproduce (see attached), as long as > include_schemas=True. However, in your env.py, you have this: > > def include_symbol(tablename, schema): > return schema == table_args['schema'] > >

Re: alter table with sequence

On 9/21/15 10:18 AM, Ofir Herzas wrote: rename_table operation does not rename sequences if they exist. This causes a problem that the renamed table is unusable since the sequence is missing. In Oracle, a simple rename works well (RENAME old_seq_name TO new_seq_name;) although it says

alter table with sequence

rename_table operation does not rename sequences if they exist. This causes a problem that the renamed table is unusable since the sequence is missing. In Oracle, a simple rename works well (RENAME old_seq_name TO new_seq_name;) although it says "table renamed". Is there a sequence rename