Bug report

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
Post Reply
pkExec
Posts: 2
Joined: Fri 28 Jan 2022 12:25

Bug report

Post by pkExec » Fri 28 Jan 2022 12:29

Thanks for the great product. Some bugs I found.

Comparing done between:
PostgreSQL version 11 and PostgreSQL version 13
dbForge Schema Compare version: 1.2.182 (Windows)

Bugs found:
- Sequences are not compared at all.
- Foreign keys are not detected as "different" if their only difference is at the action level ("ON DELETE CASCADE" for example).

pkExec
Posts: 2
Joined: Fri 28 Jan 2022 12:25

Re: Bug report

Post by pkExec » Fri 28 Jan 2022 14:54

#3 - If the Foreign Keys are missing in the second database, then the script generated has "ON DELETE NO ACTION ON UPDATE NO ACTION", even if the original is not set this way (e.g. it's ON DELETE CASCADE)

alexa

Re: Bug report

Post by alexa » Mon 31 Jan 2022 11:51

This is to be implemented in one of the next product versions.

wardrose2
Posts: 1
Joined: Mon 25 Jul 2022 04:24

Re: Bug report

Post by wardrose2 » Tue 09 Aug 2022 09:08

I also look forward to the next products . Hopefully it will have new breakthroughs.

Post Reply