Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u7p3q-007KE8-Nu for pgsql-general@arkaria.postgresql.org; Thu, 24 Apr 2025 05:23:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u7p3n-00DC33-Or for pgsql-general@arkaria.postgresql.org; Thu, 24 Apr 2025 05:23:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u7p3n-00DC2h-D6 for pgsql-general@lists.postgresql.org; Thu, 24 Apr 2025 05:23:44 +0000 Received: from mail-oo1-xc2d.google.com ([2607:f8b0:4864:20::c2d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u7p3m-001eb3-0U for pgsql-general@lists.postgresql.org; Thu, 24 Apr 2025 05:23:43 +0000 Received: by mail-oo1-xc2d.google.com with SMTP id 006d021491bc7-601ad30bc0cso1194506eaf.0 for ; Wed, 23 Apr 2025 22:23:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745472221; x=1746077021; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=7hTrdESXG5quiA+Y0qishJ0PMR6i2rrKJvJXbbZ5Yas=; b=Np0gjPJQg+t9U0mBe3XCVcKle06gX1W/YXDHZk9So6IJLGpXaE7C5z5ZjMmKz18oI2 MKk/cjhUoUuR9YblBVchyWE4kCi+cOMO6KpQq90C/phhWBbA10HeDyGYeIA4Iy0ZMrqx SDnb9uE1VVYUGQQLg4C0fkhCESYQWMPF6IubiZYe3eKokIJvAiFwgcmiQCKiBcloj3jj kNmx5cWoskZ6LZ0EmK2nm3ARN39yz68kvJpxPdp93XUhung8b9C274g2KhxmZtqfAKpK RrOYALwGr/pfHhtM8Z4KunzobuH10wzJuXDXORRxsCWEaJ/wgVEncDqmqeHVN42DT2JF UGyA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745472221; x=1746077021; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=7hTrdESXG5quiA+Y0qishJ0PMR6i2rrKJvJXbbZ5Yas=; b=Tmz1DTvmJR0hSeTO+noM4n2AYBP7KAWZNhIjiRRM9nXEJyKDNeOMJRbwurfp3Sp3/u lkv5tMdFpdvoFINURPaUOYmukTKq5Wza0rGen7yvGJc7TaHrFa9KFFgDf88kouRykEI9 nw6weIQ2zPwvOekE2iSU8zsIeZ98Tmz3gmgzFq0fdSNNLYD7xr52yoqPfCflZIQKxoSK J0VqLYhPcnmHoxek723RTch+vmGJ6wMcO8pQFBTPOjVKlMhgmv/7VlfaOESiPnwKnz7S G10QFLzUhcpw/f6Xjgdk7LSRMilSJaQszFqMtUvRg9NG1Fqzq3gon4S8BDx9kV53Iw2e qEig== X-Forwarded-Encrypted: i=1; AJvYcCX5V12r5s8meRnROpLGOzXLHhc+exNDVjSqAOYOI/KtdpoxWB12RRAPjnib9SCsbI4y8XfYgYVHxhRozV+V@lists.postgresql.org X-Gm-Message-State: AOJu0Yzm1a0+wWSaRclf2J4twzkNe1tMwS5/VMf2r3of94XjPUESwCO2 W4jBj2q0XcoIKm4tZSbXS16ma5qvsV+I7HKrPDImtYXLQIueDBxyhtNyYzJaW2++yLHUnqLg/qN NNlbJvfM0kC0zeON6cshjblaRT1A= X-Gm-Gg: ASbGnctcGolXtOEXFglyidq/Ulqdv+N5UmJsSzcQcqldB1Cd9mau7Qn7uJftAqNoBj5 WVHPRA40nhUSStzPEGXj8oE4w46fmhp6MM/WA+C2+vFelcAON1avAH2kgACQ8L03AeP8A7Nf0ai FTZhoFsJMKyEouS3VRm5aZ X-Google-Smtp-Source: AGHT+IFSGR63q2Bo5rfR61407yAthy/K+V4ThWCoh//gp1wE/h5meUHhgW20k/AO6jsoHRCh0mt/OM8Yjm96cmF+MSw= X-Received: by 2002:a05:6871:3304:b0:2d5:2360:4e7d with SMTP id 586e51a60fabf-2d9731fe227mr443848fac.8.1745472221484; Wed, 23 Apr 2025 22:23:41 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:7383:0:b0:589:13f9:e937 with HTTP; Wed, 23 Apr 2025 22:23:39 -0700 (PDT) In-Reply-To: References: <03763b6b43cfd8a7194c2fb06452178db4256494.camel@cybertec.at> <4B9E0CAC-FB06-4F35-8C77-33AEA7F741B7@yesql.se> <1430373.1745432896@sss.pgh.pa.us> <1431982.1745433654@sss.pgh.pa.us> From: "David G. Johnston" Date: Wed, 23 Apr 2025 22:23:39 -0700 X-Gm-Features: ATxdqUFPJl2jQ6ABKzSSbpHoSL0LpliPcZd6kkQTpP9jr5_8zDJwhhF9IU4EHx0 Message-ID: Subject: Re: Another documentation issue To: Igor Korot Cc: Tom Lane , Daniel Gustafsson , Laurenz Albe , "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000ba1d5e06337f6bf5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ba1d5e06337f6bf5 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, April 23, 2025, Igor Korot wrote: > > How do you handle sch situation from the client POV? > Get the current value. If it=E2=80=99s non-zero the system definitely supp= orts it. If it=E2=80=99s zero it probably doesn=E2=80=99t. But give the user a= n option to specify a value anyway just in case. If they try and it errors, it doesn= =E2=80=99t support it. David J. --000000000000ba1d5e06337f6bf5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, April 23, 2025, Igor Korot <ikorot01@gmail.com> wrote:

How do you handle sch situation from the client POV?

Get the current value.=C2=A0 If it=E2=80= =99s non-zero the system definitely supports it.=C2=A0 If it=E2=80=99s zero= it probably doesn=E2=80=99t.=C2=A0 But give the user an option to specify = a value anyway just in case.=C2=A0 If they try and it errors, it doesn=E2= =80=99t support it.

David J.=C2=A0
--000000000000ba1d5e06337f6bf5--