MIME-Version: 1.0
References: <CA+FnnTyWEsYi=_QTeSXoGXd7Fkd8C7_AnCc5=hho-DZF9_iunQ@mail.gmail.com>
 <90741d5f-5cda-4c4a-84f4-c470129732f4@aklaver.com> <CA+FnnTz9-cjBDf3mC9fx_FCtZGDTneF9=w8LpTRdwCfxHN86yw@mail.gmail.com>
 <CAKFQuwZGjMYbP0nWYb2+-D1a_dNg6b-mDhDC96Am-c2MZOYTNw@mail.gmail.com>
 <CA+FnnTy2Lk+K8t2uKwc1cAnCm6+RTb72eVRxt9+Y8y+C=sUeyA@mail.gmail.com>
 <473602.1742698901@sss.pgh.pa.us> <CA+FnnTztyXpMxEiKTZhxMtcQ8Nm6D+M1jbfJFfkJYU9dyvTeLg@mail.gmail.com>
 <CAKFQuwZ3-wmpyUEdHUaL7H9RHp-FTxUJjVL3L5A0jqA2bbHXYw@mail.gmail.com> <CAKFQuwb6vf1L2O8X_6Qu2VNq9iUhCjbXTc=51702h7yo4dH=8w@mail.gmail.com>
In-Reply-To: <CAKFQuwb6vf1L2O8X_6Qu2VNq9iUhCjbXTc=51702h7yo4dH=8w@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sun, 23 Mar 2025 18:52:22 -0500
Message-ID: <CA+FnnTx5n=yCw4+qcRuv-c7ECf=K=tao7j_k=dDp5nPUMJ7t_A@mail.gmail.com>
Subject: Re: Determine server version from psql script
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Adrian Klaver <adrian.klaver@aklaver.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTx5n%3DyCw4%2BqcRuv-c7ECf%3DK%3Dtao7j_k%3DdDp5nPUMJ7t_A%40mail.gmail.com>
Precedence: bulk

Hi,

[code]
SELECT current_setting('server_version_num')::int > 130000 as v13
\gset
\if :v13
   CREATE OR REPLACE TRIGGER playersinleague_insert AFTER INSERT ON
playersinleague WHEN new.current_rank IS NULL
   BEGIN
           UPDATE playersinleague SET current_rank =3D 1 + (SELECT
coalesce( max( current_rank ), 0 ) FROM playersinleague WHERE id =3D
new.id) WHERE rowid =3D new.rowid;
psql:draft_pg.sql:44265: ERROR:  syntax error at or near "TRIGGER"
LINE 1: CREATE OR REPLACE TRIGGER playersinleague_insert AFTER INSER...
                         ^
[/code]

What am I doing wrong?

Thank you.


On Sun, Mar 23, 2025 at 12:53=E2=80=AFPM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> On Sunday, March 23, 2025, David G. Johnston <david.g.johnston@gmail.com>=
 wrote:
>>
>> 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 ver=
sion?
>>
>>
>> No.  You have to drop the trigger if it does exist and then create the n=
ew one.
>
>
> Well, you can always query the catalogs directly to answer the question =
=E2=80=9Cdoes this trigger exist=E2=80=9D.
>
> David J.
>