Re: How to watch for schema changes

[David G. Johnston]

On Tue, Jul 3, 2018 at 11:41 AM, Igor Korot <ikoro...@gmail.com> wrote:

> ​​
>
> I presume threre is a query which check for the function/trigger
> existence? Something like:
>
> IF NOT EXIST(SELECT * FROM ) CREATE OR REPLACE FUNCTION....;
>

​CREATE OR REPLACE is how you re-create a function that (whose
name/signature) might already exist​; CREATE already assumes one doesn't
exist.

David J.