Thread: 2024-02-08 release announcement draft

2024-02-08 release announcement draft

From
"Jonathan S. Katz"
Date:
Hi,

Attached is a draft of the 2024-02-08 release announcement. Please 
review for accuracy and notable omissions.

Please provide any feedback no later than 2024-02-08 12:00 UTC (and 
preferably sooner).

Thanks,

Jonathan

Attachment

Re: 2024-02-08 release announcement draft

From
jian he
Date:
On Tue, Feb 6, 2024 at 12:43 PM Jonathan S. Katz <jkatz@postgresql.org> wrote:
>
> Hi,
>
> Attached is a draft of the 2024-02-08 release announcement. Please
> review for accuracy and notable omissions.
>
> Please provide any feedback no later than 2024-02-08 12:00 UTC (and
> preferably sooner).
>

* In PL/pgSQL, support SQL commands that are `CREATE FUNCTION`/`CREATE
PROCEDURE`
with SQL-standard bodies.

https://git.postgresql.org/cgit/postgresql.git/commit/?id=57b440ec115f57ff6e6a3f0df26063822e3123d2
says only for plpgsql routine or DO block.

* Ensure initdb always uncomments `postgresql.conf` entries for the
`lc_` family of parameters.

maybe  `initdb`



Re: 2024-02-08 release announcement draft

From
"Jonathan S. Katz"
Date:
On 2/6/24 3:19 AM, jian he wrote:
> On Tue, Feb 6, 2024 at 12:43 PM Jonathan S. Katz <jkatz@postgresql.org> wrote:
>>
>> Hi,
>>
>> Attached is a draft of the 2024-02-08 release announcement. Please
>> review for accuracy and notable omissions.
>>
>> Please provide any feedback no later than 2024-02-08 12:00 UTC (and
>> preferably sooner).
>>
> 
> * In PL/pgSQL, support SQL commands that are `CREATE FUNCTION`/`CREATE
> PROCEDURE`
> with SQL-standard bodies.
> 
> https://git.postgresql.org/cgit/postgresql.git/commit/?id=57b440ec115f57ff6e6a3f0df26063822e3123d2
> says only for plpgsql routine or DO block.

I had some trouble wordsmithing this, but the commit title is pretty 
clear to me so I opted for that.

> * Ensure initdb always uncomments `postgresql.conf` entries for the
> `lc_` family of parameters.
> 
> maybe  `initdb`

I applied this change -- thanks!

Jonathan


Attachment

Re: 2024-02-08 release announcement draft

From
Tom Lane
Date:
"Jonathan S. Katz" <jkatz@postgresql.org> writes:
> On 2/6/24 3:19 AM, jian he wrote:
>> On Tue, Feb 6, 2024 at 12:43 PM Jonathan S. Katz <jkatz@postgresql.org> wrote:
>>> * In PL/pgSQL, support SQL commands that are `CREATE FUNCTION`/`CREATE
>>> PROCEDURE` with SQL-standard bodies.

>> https://git.postgresql.org/cgit/postgresql.git/commit/?id=57b440ec115f57ff6e6a3f0df26063822e3123d2
>> says only for plpgsql routine or DO block.

> I had some trouble wordsmithing this, but the commit title is pretty
> clear to me so I opted for that.

Your text seems fine to me.  I'm confused about the objection here:
exactly what uses of plpgsql aren't in a routine or DO block?

            regards, tom lane



Re: 2024-02-08 release announcement draft

From
jian he
Date:
On Thu, Feb 8, 2024 at 1:17 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "Jonathan S. Katz" <jkatz@postgresql.org> writes:
> > On 2/6/24 3:19 AM, jian he wrote:
> >> On Tue, Feb 6, 2024 at 12:43 PM Jonathan S. Katz <jkatz@postgresql.org> wrote:
> >>> * In PL/pgSQL, support SQL commands that are `CREATE FUNCTION`/`CREATE
> >>> PROCEDURE` with SQL-standard bodies.
>
> >> https://git.postgresql.org/cgit/postgresql.git/commit/?id=57b440ec115f57ff6e6a3f0df26063822e3123d2
> >> says only for plpgsql routine or DO block.
>
> > I had some trouble wordsmithing this, but the commit title is pretty
> > clear to me so I opted for that.
>
> Your text seems fine to me.  I'm confused about the objection here:
> exactly what uses of plpgsql aren't in a routine or DO block?
>
>                         regards, tom lane

I guess I was confused with cases like this
`
create function test1() returns int language plpgsql
begin atomic
select unique1 from tenk1 limit 1;
end ;
`
looking back, the original text seems fine.



Re: 2024-02-08 release announcement draft

From
Dagfinn Ilmari Mannsåker
Date:
jian he <jian.universality@gmail.com> writes:

> On Thu, Feb 8, 2024 at 1:17 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>
>> "Jonathan S. Katz" <jkatz@postgresql.org> writes:
>> > On 2/6/24 3:19 AM, jian he wrote:
>> >> On Tue, Feb 6, 2024 at 12:43 PM Jonathan S. Katz <jkatz@postgresql.org> wrote:
>> >>> * In PL/pgSQL, support SQL commands that are `CREATE FUNCTION`/`CREATE
>> >>> PROCEDURE` with SQL-standard bodies.
>>
>> >> https://git.postgresql.org/cgit/postgresql.git/commit/?id=57b440ec115f57ff6e6a3f0df26063822e3123d2
>> >> says only for plpgsql routine or DO block.
>>
>> > I had some trouble wordsmithing this, but the commit title is pretty
>> > clear to me so I opted for that.
>>
>> Your text seems fine to me.  I'm confused about the objection here:
>> exactly what uses of plpgsql aren't in a routine or DO block?
>>
>>                         regards, tom lane
>
> I guess I was confused with cases like this
> `
> create function test1() returns int language plpgsql
> begin atomic
> select unique1 from tenk1 limit 1;
> end ;
> `
> looking back, the original text seems fine.

The word "routine" is the SQL standard's common term for both functions
and procedures.

- ilmari