#31 DDL scripts for relations

[Anonymous]

The clause "IF EXISTS" needs to be added to the DDL script for creating FK relationships. Currently, the "DROP CONSTRAINT" line is present, but without the "IF EXISTS" clause, PostgreSql stops processing (this is on 9.x) the script with an error.

[Carlotto Luigi]

The clause "IF EXISTS" was introduced in the latest versions of PostgreSQL, and placed in pgDesigner the correct drivers. But it is not always valid for all objects.
And 'you're probably using a driver that does not include this clause, or that the object is not enabled this feature.