Camilo Herrera

Results 8 comments of Camilo Herrera

What would be steps to debug real issue with this ? My issue was closed but no solution is given/ no alternative and no root cause.

![image](https://user-images.githubusercontent.com/90866191/179051186-422d20b4-b67a-4b22-8d82-5250cb41f774.png) ![image](https://user-images.githubusercontent.com/90866191/179060028-34da8267-d5bf-47c8-897a-46c49f317830.png) ![image](https://user-images.githubusercontent.com/90866191/179060190-3f9ecada-8dd5-42ea-a737-0a8132ab1280.png) ![image](https://user-images.githubusercontent.com/90866191/179061033-594f4d7f-b85d-44a5-b02d-837c78f059af.png) This is an example of some of the issues I have had (Possibly) due to having multiple databases distributed on a postgresql instance, however I have...

In that case I would suggest adding a warning against performing "create database with as template" to avoid creating those issues.

This is another example of inconsistent behaviour, possibly caused due to using the template create database option : ![image](https://user-images.githubusercontent.com/90866191/180335305-24f2e8c7-4996-445d-82cf-4c4a40ec88de.png)

Another example, the database cant find one of the shards of a distributed table when dumping the database. ![image](https://user-images.githubusercontent.com/90866191/180337853-a3031776-693d-45f4-adcf-c0123bdc5bf0.png)

![image](https://user-images.githubusercontent.com/90866191/180338503-ebc1c388-b2b0-45b7-be99-87487f8cc930.png) This is the output of the previous commands then logging remote commands

![image](https://user-images.githubusercontent.com/90866191/180339124-b2fbbede-7343-4b66-8829-ce4f7e930805.png) The consequence of using a select * from the table previously throwing errors in schema ota when making a dump.

![image](https://user-images.githubusercontent.com/90866191/180339600-3dd00cd9-ce20-450d-85f5-5c1ed2cc863b.png) However using the drop table command does work, i assume its becuase it internally uses the command drop table if exists.