Postgres Pro
Downloads
Home   >   mailing lists

Re: Determine server version from psql script - Mailing list pgsql-general

From David G. Johnston
Subject Re: Determine server version from psql script
Date
Msg-id CAKFQuwZ3-wmpyUEdHUaL7H9RHp-FTxUJjVL3L5A0jqA2bbHXYw@mail.gmail.com
Whole thread Raw
In response to Re: Determine server version from psql script  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Determine server version from psql script
List pgsql-general
Tree view
On Sunday, March 23, 2025, Igor Korot <ikorot01@gmail.com> wrote:

2. Is there a way to do CREATE TRIGGER IF NOT EXIST for the earlier version?

No.  You have to drop the trigger if it does exist and then create the new one.

David J.
 

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Determine server version from psql script
Next
From: Adrian Klaver
Date:
Subject: Re: Determine server version from psql script