Re: How to watch for schema changes

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to watch for schema changes
Date: 2018-07-03 18:46:49
Message-ID: CAKFQuwZsZvOj-XH8APjzfteD+-7XHE+tVunLLvqXgd76W0fu2w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 3, 2018 at 11:41 AM, Igor Korot <ikorot01(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-07-03 18:47:42 Re: How to watch for schema changes
Previous Message Igor Korot 2018-07-03 18:41:41 Re: How to watch for schema changes