Toad World® Forums

Lost CREATE OR REPLACE generation after Postgres 10 to 11 Conversion

We converted our Postgres 10 data model to Postgres 11. Now, when we generate DDL (Model -> Generate DDL Script -> Run), the generated code functions have CREATE FUNCTION statements. In our Postgres 10 model, it generated CREATE OR REPLACE FUNCTION.

I have been unable to find any setting for this in the documentation or menu structure, but I suspect there is a fix.

Does anyone know how to make the Generate DDL generate CREATE OR REPLACE FUNCTION statements?

Thank you.

Found the solution. There is an unidentified drop down on the "What to Generate" tab of the DDL Script Generation window that allows users to select the Create or Replace plus other options.

This object should have a label identifying its purpose.