| From: | Igor Korot <ikorot01(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(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-05 15:40:51 |
| Message-ID: | CA+FnnTwt=DfOH=HggP9tw1hj++eBymBeD4Rp2-w5JxeFjh5pDg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi, David,
On Tue, Jul 3, 2018 at 1:46 PM, David G. Johnston
<david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> 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.
Why do I need to re-create a function with exactly the same name and body?
Can't I just check if such function exists?
Thank you.
>
> David J.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melvin Davidson | 2018-07-05 16:14:40 | Re: How to watch for schema changes |
| Previous Message | Andreas Kretschmer | 2018-07-05 15:39:26 | Re: Split daterange into sub periods |