Return
-
Title
Postgresql reverse engineering error -
Description
When reverse engineering Postgresql one may see the error:Source: Toad Data Modeler - Internal errorScript: REDataMigratorDBPGDescription: current transaction is aborted, commands ignored until and of transaction blockRow: 1829Column: 7Callctack:"REDataMigratorDBPG93" from package "Object RE Database for PostgreSQL 9.3""REDataMigratorDBPG93" from package "Object RE Database for PostgreSQL 9.3"PLEASE NOTE: If the SEQUENCES are un-checked (not included), the reverse engineering finishes just fine. -
Cause
To load SEQUENCES, one must have permissions to read data from the tables of the user that created the sequence. The message "Permissions denied..." means that there's no permission to read data from postgreSQL realtion "public"."poc_poc_seq", in which there is info about the loaded sequence "poc_poc_seq". -
Resolution
WORKAROUND:
Attached there's a package that helps to handle the error message, "OREDBPG_user.txg", this allows the reverse engineering to finish despite the error.
The package should be placed in the same location as "My Package.txg":
C:\Users\USER_NAME\Documents\Toad Data Modeler\Standard_Installation_PATH\Packages\{DCB5CB9B-CF65-4350-86B5-285D246FC5AC}
STATUS:
Issue fixed in version 6.3. The latest version of Toad Data Modeler can be downloaded here
-
Defect ID
TDM-3520 -
Attachments