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
DBforge crashes using booleans in stored procedures
Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
-
- 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
Return to “dbForge for PostgreSQL”
Jump to
- General Forums
- ↳ Announcements
- Database Tools
- ↳ dbForge for MySQL
- ↳ dbForge for Oracle
- ↳ dbForge for PostgreSQL
- ↳ dbForge for SQL Server
- ADO.NET Data Providers
- ↳ Entity Framework support
- ↳ LinqConnect (LINQ to SQL support)
- ↳ dotConnect for Oracle
- ↳ dotConnect for MySQL
- ↳ dotConnect for PostgreSQL
- ↳ dotConnect for SQLite
- ↳ dotConnect for DB2
- ↳ dotConnect for SQL Server
- ↳ dotConnect for Cloud Applications
- ↳ dotConnect Universal
- ↳ Entity Developer
- Delphi Data Access Components
- ↳ EntityDAC
- ↳ Universal Data Access Components
- ↳ Oracle Data Access Components
- ↳ SQL Server Data Access Components
- ↳ MySQL Data Access Components
- ↳ InterBase Data Access Components
- ↳ PostgreSQL Data Access Components
- ↳ SQLite Data Access Components
- ↳ VirtualDAC
- dbExpress Drivers
- ↳ dbExpress driver for Oracle
- ↳ dbExpress driver for SQL Server
- ↳ dbExpress driver for MySQL
- ↳ dbExpress driver for InterBase & Firebird
- ↳ dbExpress driver for PostgreSQL
- ↳ dbExpress driver for SQLite
- ODBC Drivers
- ↳ ODBC Drivers
- Network Security
- ↳ SecureBridge
- Developer Tools
- ↳ Code Compare
- ↳ Review Assistant
- ↳ LINQ Insight
- ↳ SSIS Data Flow Components
- ↳ Excel Add-ins