[GitHub] [incubator-superset] dpgaspar edited a comment on issue #8362: CTAS executed but resulting table not created

[GitBox <gi...@apache.org>]

dpgaspar edited a comment on issue #8362: CTAS executed but resulting table not created
URL: https://github.com/apache/incubator-superset/issues/8362#issuecomment-540099456
 
 
   May be that, I've checked and the correct query gets to `db_engine_specs.execute`, and (of course) also makes it to PG.
   
   I've added a `COMMIT` on the execute and it does work, :+1: @villebro. PG does complaining around it:
   ```
   2019-10-09 17:20:52.304 UTC [122] WARNING:  there is no transaction in progress
   ```
   Yes making it optional per datasource does seem like a good option
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org