DBforge crashes using booleans in stored procedures

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
Post Reply
BIteam2022
Posts: 1
Joined: Wed 24 Aug 2022 11:52

DBforge crashes using booleans in stored procedures

Post by BIteam2022 » Wed 24 Aug 2022 12:04

Hi all,

I'm using Redshift - Postgres databases to compare schema's. DBForge stopped working due to some "boolean" functions (stored procedures) which are giving the error.

How did I found out?
Created two test databases to compare. Everything went fine until I added a specific stored procedure to the database, example:
CREATE OR REPLACE PROCEDURE test_procedure(_var_init bool)
declaring that bool type makes the compare crash (no idea why this is). Seems like DBforge can't handle those booleans like it should. Creating a dummy procedure with a varchar type works fine. 

I can reproduce this error and also did it in different schema's and with different functions. 

Error message that is created in DBForge:
Comparison failed.
Reason: The given key was not present in the dictionary.


Please help me out with this. Thanks in advance.
With kind regards

Post Reply