Re: Cleaning up perl code

2024-05-20 Thread Dagfinn Ilmari Mannsåker
Alexander Lakhin writes: > Hello hackers, > > Please look at a bunch of unused variables and a couple of other defects > I found in the perl code, maybe you'll find them worth fixing: Nice cleanup! Did you use some static analysis tool, or did look for them manually? If I add

Re: Improving information_schema._pg_expandarray()

2024-05-13 Thread Dagfinn Ilmari Mannsåker
[ I got distracted while writing this follow-up and only just found it in my list of unsent Gnus buffers, and now it's probably too late to make it for 17, but here it is anyway while I remember. ] Tom Lane writes: > I happened to notice that information_schema._pg_expandarray(), > which

Re: Allowing additional commas between columns, and at the end of the SELECT clause

2024-05-13 Thread Dagfinn Ilmari Mannsåker
Tom Lane writes: > =?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= writes: >> Matthias van de Meent writes: >>> Single trailing commas are a feature that's more and more common in >>> languages, yes, but arbitrary excess commas is new to me. Could you >>> provide some examples of popular languages

Re: Allowing additional commas between columns, and at the end of the SELECT clause

2024-05-13 Thread Dagfinn Ilmari Mannsåker
Matthias van de Meent writes: > On Mon, 13 May 2024 at 10:42, Artur Formella > wrote: >> Motivation: >> Commas of this type are allowed in many programming languages, in some >> it is even recommended to use them at the ends of lists or objects. > > Single trailing commas are a feature that's

Re: Is there an undocumented Syntax Check in Meson?

2024-05-09 Thread Dagfinn Ilmari Mannsåker
Andres Freund writes: > Hi, > > On 2024-05-09 20:53:27 +0100, Dagfinn Ilmari Mannsåker wrote: >> Andres Freund writes: >> > On 2024-05-09 20:12:38 +0100, Dagfinn Ilmari Mannsåker wrote: >> >> Attached is a patch which adds a check-docs target for meson,

Re: Is there an undocumented Syntax Check in Meson?

2024-05-09 Thread Dagfinn Ilmari Mannsåker
Andres Freund writes: > Hi, > > On 2024-05-09 20:12:38 +0100, Dagfinn Ilmari Mannsåker wrote: >> Attached is a patch which adds a check-docs target for meson, which >> takes 0.3s on my laptop. > > Nice. > > >> +checkdocs = custom_target('check-docs', >

Re: open items

2024-05-09 Thread Dagfinn Ilmari Mannsåker
Robert Haas writes: > * Register ALPN protocol id with IANA. From the mailing list thread, > it is abundantly clear that IANA is in no hurry to finish dealing with > what seems to be a completely pro forma request from our end. I think > we just have to be patient. This appears to have been

Re: Is there an undocumented Syntax Check in Meson?

2024-05-09 Thread Dagfinn Ilmari Mannsåker
"David G. Johnston" writes: > $subject > > Make has one: > https://www.postgresql.org/docs/current/docguide-build.html#DOCGUIDE-BUILD-SYNTAX-CHECK > > This needs updating: > https://www.postgresql.org/docs/current/docguide-build-meson.html > > I've been using "ninja html" which isn't shown here.

Re: Is there an undocumented Syntax Check in Meson?

2024-05-09 Thread Dagfinn Ilmari Mannsåker
"David G. Johnston" writes: > $subject > > Make has one: > https://www.postgresql.org/docs/current/docguide-build.html#DOCGUIDE-BUILD-SYNTAX-CHECK > > This needs updating: > https://www.postgresql.org/docs/current/docguide-build-meson.html > > I've been using "ninja html" which isn't shown here.

Re: First draft of PG 17 release notes

2024-05-09 Thread Dagfinn Ilmari Mannsåker
Dagfinn Ilmari Mannsåker writes: > Bruce Momjian writes: > >> I have committed the first draft of the PG 17 release notes; you can >> see the results here: >> >> https://momjian.us/pgsql_docs/release-17.html > > My name is listed twice in the "Im

Re: First draft of PG 17 release notes

2024-05-09 Thread Dagfinn Ilmari Mannsåker
Bruce Momjian writes: > I have committed the first draft of the PG 17 release notes; you can > see the results here: > > https://momjian.us/pgsql_docs/release-17.html My name is listed twice in the "Improve psql tab completion" item. - ilmari

Re: Expand applicability of aggregate's sortop optimization

2024-05-08 Thread Dagfinn Ilmari Mannsåker
Matthias van de Meent writes: > PFA the small patch that implements this. I don't have enough knowledge to have an opinion on most of the patch other than it looks okay at a glance, but the list API usage could be updated to more modern variants: > diff --git

Re: Doc anchors for COPY formats

2024-04-25 Thread Dagfinn Ilmari Mannsåker
Daniel Gustafsson writes: >> On 25 Apr 2024, at 13:23, Dagfinn Ilmari Mannsåker wrote: > >> An IRC conversation just now made me notice that it would be handy to >> have stable links for the descrpitions of the various COPY formats, per >> the attached patch. &g

Doc anchors for COPY formats

2024-04-25 Thread Dagfinn Ilmari Mannsåker
Hi hackers, An IRC conversation just now made me notice that it would be handy to have stable links for the descrpitions of the various COPY formats, per the attached patch. - ilmari >From 5e59273370a39cd46627b89145a7c06dd6f00f7d Mon Sep 17 00:00:00 2001 From:

Re: Idea Feedback: psql \h misses -> Offers Links?

2024-04-18 Thread Dagfinn Ilmari Mannsåker
Kirk Wolak writes: > On Thu, Apr 18, 2024 at 2:37 PM Peter Eisentraut > wrote: > >> On 17.04.24 19:47, Kirk Wolak wrote: >> > *Example:* >> > \h current_setting >> > No help available for "current_setting". >> > Try \h with no arguments to see available help. >> > >> >

Re: documentation structure

2024-04-18 Thread Dagfinn Ilmari Mannsåker
Corey Huinker writes: >> >> I havent dealt with variadic yet, since the two styles are visually >> different, not just markup (... renders as [...]). >> >> The two styles for variadic are the what I call caller-style: >> >>concat ( val1 "any" [, val2 "any" [, ...] ] ) >>format(formatstr

Re: Add SPLIT PARTITION/MERGE PARTITIONS commands

2024-04-18 Thread Dagfinn Ilmari Mannsåker
Alexander Lakhin writes: > Hi Alexander, > > 18.04.2024 13:35, Alexander Korotkov wrote: >> >> The revised patchset is attached. >> 1) I've split the fix for the CommandCounterIncrement() issue and the >> fix for relation persistence issue into a separate patch. >> 2) I've validated that the

Re: documentation structure

2024-04-17 Thread Dagfinn Ilmari Mannsåker
Andres Freund writes: > Hi, > > On 2024-04-17 12:07:24 +0100, Dagfinn Ilmari Mannsåker wrote: >> Andres Freund writes: >> > I think the manual work for writing signatures in sgml is not >> > insignificant, >> > nor is the volume of sgml for them. Manua

Re: documentation structure

2024-04-17 Thread Dagfinn Ilmari Mannsåker
Andres Freund writes: > Definitely shouldn't be the same in all cases, but I think there's a decent > number of cases where they can be the same. The differences between the two is > often minimal today. > > Entirely randomly chosen example: > > { oid => '2825', > descr => 'slope of the

Re: IPC::Run::time[r|out] vs our TAP tests

2024-04-05 Thread Dagfinn Ilmari Mannsåker
Tom Lane writes: > Erik Wienhold writes: >> Libedit 20191025-3.1 is the first version where ":{?VERB" works as >> expected. The previous release 20190324-3.1 still produces the escaped >> output that Michael found. That narrows down the changes to everything >> between [1] (changed on

Re: Using the %m printf format more

2024-04-04 Thread Dagfinn Ilmari Mannsåker
On Thu, 4 Apr 2024, at 03:35, Michael Paquier wrote: > On Fri, Mar 22, 2024 at 01:58:24PM +0000, Dagfinn Ilmari Mannsåker wrote: >> Here's an updated patch that adds such a comment. I'll add it to the >> commitfest later today unless someone commits it before then. > > I

Re: Using the %m printf format more

2024-03-22 Thread Dagfinn Ilmari Mannsåker
Dagfinn Ilmari Mannsåker writes: > Michael Paquier writes: > >> On Wed, Mar 13, 2024 at 02:33:52PM +0100, Peter Eisentraut wrote: >>> The 0002 patch looks sensible. It would be good to fix that, otherwise it >>> could have some confusing outcomes in the futu

Re: What about Perl autodie?

2024-03-18 Thread Dagfinn Ilmari Mannsåker
Daniel Gustafsson writes: >> On 18 Mar 2024, at 07:27, Peter Eisentraut wrote: > >> After some pondering, I figured the exclude list is better. > > Agreed. > >> So here is a squashed patch, also with a complete commit message. > > Looks good from a read-through. It would have been nice to

Re: Using the %m printf format more

2024-03-14 Thread Dagfinn Ilmari Mannsåker
Michael Paquier writes: > On Wed, Mar 13, 2024 at 02:33:52PM +0100, Peter Eisentraut wrote: >> The 0002 patch looks sensible. It would be good to fix that, otherwise it >> could have some confusing outcomes in the future. > > You mean if we begin to use %m in future callers of >

Re: Using the %m printf format more

2024-03-13 Thread Dagfinn Ilmari Mannsåker
Michael Paquier writes: > On Mon, Mar 11, 2024 at 11:19:16AM +0000, Dagfinn Ilmari Mannsåker wrote: >> On closer look, fprintf() is actually the only errno-clobbering function >> it calls, I was just hedging my bets in that statement. > > This makes the whole simpler, so I'

Re: Using the %m printf format more

2024-03-11 Thread Dagfinn Ilmari Mannsåker
Michael Paquier writes: > On Wed, Mar 06, 2024 at 07:11:19PM +0000, Dagfinn Ilmari Mannsåker wrote: > >> The attached patch does so everywhere appropriate. One place where it's >> not appropriate is the TAP-emitting functions in pg_regress, since those >> call fprin

Using the %m printf format more

2024-03-06 Thread Dagfinn Ilmari Mannsåker
Hi hackers, I just noticed that commit d93627bc added a bunch of pg_fatal() calls using %s and strerror(errno), which could be written more concisely as %m. I'm assuming this was done because the surrounding code also uses this pattern, and hadn't been changed to use %m when support for that was

Re: What about Perl autodie?

2024-02-08 Thread Dagfinn Ilmari Mannsåker
Daniel Gustafsson writes: >> On 8 Feb 2024, at 16:53, Tom Lane wrote: > >> 2. Don't wait, migrate them all now. This would mean requiring >> Perl 5.10.1 or later to run the TAP tests, even in back branches. >> >> I think #2 might not be all that radical. We have nothing older >> than 5.14.0

Re: 2024-02-08 release announcement draft

2024-02-08 Thread Dagfinn Ilmari Mannsåker
jian he writes: > On Thu, Feb 8, 2024 at 1:17 PM Tom Lane wrote: >> >> "Jonathan S. Katz" writes: >> > On 2/6/24 3:19 AM, jian he wrote: >> >> On Tue, Feb 6, 2024 at 12:43 PM Jonathan S. Katz >> >> wrote: >> >>> * In PL/pgSQL, support SQL commands that are `CREATE FUNCTION`/`CREATE >> >>>

Re: doc patch: Spell I/O consistently

2024-02-06 Thread Dagfinn Ilmari Mannsåker
Michael Paquier writes: > On Mon, Feb 05, 2024 at 03:59:27PM +0000, Dagfinn Ilmari Mannsåker wrote: >> I just noticed that a couple of places in the docs spell I/O as IO or >> even io when not referring to literal table/view/column names or values >> therein. Here'

doc patch: Spell I/O consistently

2024-02-05 Thread Dagfinn Ilmari Mannsåker
Hi Hackers, I just noticed that a couple of places in the docs spell I/O as IO or even io when not referring to literal table/view/column names or values therein. Here's a patch to fix them. - ilmari >From ed5f9ce738dd6356d5d68e4cfed95d8d98d2cde5 Mon Sep 17 00:00:00 2001 From:

Re: Patch: Add parse_type Function

2024-02-05 Thread Dagfinn Ilmari Mannsåker
Jim Jones writes: > 1) The function causes a crash when called with a NULL parameter: > > SELECT * FROM parse_type(NULL); > server closed the connection unexpectedly >     This probably means the server terminated abnormally >     before or while processing the request. > The connection

Re: Bytea PL/Perl transform

2024-01-30 Thread Dagfinn Ilmari Mannsåker
Pavel Stehule writes: > út 30. 1. 2024 v 17:46 odesílatel Dagfinn Ilmari Mannsåker < > ilm...@ilmari.org> napsal: > >> Pavel Stehule writes: >> >> > út 30. 1. 2024 v 17:18 odesílatel Dagfinn Ilmari Mannsåker < >> > ilm...@ilmari.org> napsal: &g

Re: Bytea PL/Perl transform

2024-01-30 Thread Dagfinn Ilmari Mannsåker
Pavel Stehule writes: > út 30. 1. 2024 v 17:18 odesílatel Dagfinn Ilmari Mannsåker < > ilm...@ilmari.org> napsal: > >> Pavel Stehule writes: >> >> > út 30. 1. 2024 v 16:43 odesílatel Dagfinn Ilmari Mannsåker < >> > ilm...@ilmari.org> napsal

Re: Bytea PL/Perl transform

2024-01-30 Thread Dagfinn Ilmari Mannsåker
Pavel Stehule writes: > út 30. 1. 2024 v 16:43 odesílatel Dagfinn Ilmari Mannsåker < > ilm...@ilmari.org> napsal: > >> Pavel Stehule writes: >> >> > I inserted perl reference support - hstore_plperl and json_plperl does >> it. >>

Re: Bytea PL/Perl transform

2024-01-30 Thread Dagfinn Ilmari Mannsåker
Pavel Stehule writes: > I inserted perl reference support - hstore_plperl and json_plperl does it. > > +<->/* Dereference references recursively. */ > +<->while (SvROK(in)) > +<-><-->in = SvRV(in); That code in hstore_plperl and json_plperl is only relevant because they deal with non-scalar

Re: System username in pg_stat_activity

2024-01-10 Thread Dagfinn Ilmari Mannsåker
Magnus Hagander writes: > On Wed, Jan 10, 2024 at 1:44 PM Aleksander Alekseev > wrote: >> >> It hurts my sense of beauty that usename and authname are of different >> types. But if I'm the only one, maybe we can close our eyes on this. >> Also I suspect that placing usename and authname in a

Re: Adding a pg_get_owned_sequence function?

2024-01-09 Thread Dagfinn Ilmari Mannsåker
Tom Lane writes: > Peter Eisentraut writes: >> Would it work to change the signature of pg_get_serial_sequence to >> pg_get_serial_sequence(table anyelement, column text) -> anyelement >> and then check inside the function code whether text or regclass was passed? > > Probably not very

Re: Adding a pg_get_owned_sequence function?

2024-01-08 Thread Dagfinn Ilmari Mannsåker
vignesh C writes: > On Tue, 24 Oct 2023 at 22:00, Nathan Bossart wrote: >> >> On Tue, Sep 12, 2023 at 03:53:28PM +0100, Dagfinn Ilmari Mannsåker wrote: >> > Tom Lane writes: >> >> It's possible that we could get away with just summarily changing >>

Re: Assorted typo fixes

2024-01-03 Thread Dagfinn Ilmari Mannsåker
Robert Haas writes: > On Mon, Jan 1, 2024 at 6:05 PM Dagfinn Ilmari Mannsåker > wrote: >> Thanks. I've fixed the commit message (and elaborated it a bit more why >> I think it's a valid and safe fix). > > Regarding 0001: > > - AIUI, check_decls.m4 is copied from a

Re: Assorted typo fixes

2024-01-01 Thread Dagfinn Ilmari Mannsåker
Shubham Khanna writes: > I was reviewing the Patch and came across a minor issue that the Patch > does not apply on the current Head. Please provide the updated version > of the patch. Thanks for the heads-up. Commit 5ccb3bb13dcbedc30d015fc06d306d5106701e16 removed one of the instances of "data

Assorted typo fixes

2023-12-27 Thread Dagfinn Ilmari Mannsåker
Hi folks, I was playing around with the `typos` tool (https://github.com/crate-ci/typos), and thought I'd run it on the posgres repo for fun. After a bit of tweaking to get rid of most false positives (see separately attached .typos.toml file), it came up with a useful set of suggestions, some

Re: On non-Windows, hard depend on uselocale(3)

2023-11-15 Thread Dagfinn Ilmari Mannsåker
Tom Lane writes: > "Tristan Partin" writes: >> I would like to propose removing HAVE_USELOCALE, and just have WIN32, >> which means that Postgres would require uselocale(3) on anything that >> isn't WIN32. > > You would need to do some research and try to prove that that won't > be a problem

Re: retire MemoryContextResetAndDeleteChildren backwards compatibility macro

2023-11-14 Thread Dagfinn Ilmari Mannsåker
Alvaro Herrera writes: > On 2023-Nov-13, Nathan Bossart wrote: > >> Shall we retire this backwards compatibility macro at this point? A search >> of https://codesearch.debian.net/ does reveal a few external uses, so we >> could alternatively leave it around and just update Postgres to stop

Re: Query execution in Perl TAP tests needs work

2023-10-18 Thread Dagfinn Ilmari Mannsåker
Tom Lane writes: > Robert Haas writes: >> On Sat, Sep 2, 2023 at 2:42 PM Andrew Dunstan wrote: How much burden is it? Would anyone actually mind? > >> ... At the same time, fallbacks can be a problem too, >> because then you can end up with things that work one way on one >> developer's

Re: Tab completion for AT TIME ZONE

2023-10-12 Thread Dagfinn Ilmari Mannsåker
Michael Paquier writes: > On Fri, Apr 14, 2023 at 12:05:25PM +0200, Jim Jones wrote: >> The patch applies cleanly and it does what it is proposing. - and it's IMHO >> a very nice addition. >> >> I've marked the CF entry as "Ready for Committer". > > +/* ... AT TIME ZONE ... */ > + else if

Re: typo in couple of places

2023-10-06 Thread Dagfinn Ilmari Mannsåker
vignesh C writes: > Hi, > > I noticed a couple of typos in code. "the the" should have been "the", > attached patch has the changes for the same. This made me curious about other duplicate word occurrences, and after a few minutes of increasingly-elaborate regexing to exclude false postives, I

Re: Allow deleting enumerated values from an existing enumerated data type

2023-10-02 Thread Dagfinn Ilmari Mannsåker
Vik Fearing writes: > On 9/29/23 03:17, Tom Lane wrote: >> Vik Fearing writes: >>> On 9/28/23 20:46, Tom Lane wrote: We went through all these points years ago when the enum feature was first developed, as I recall. Nobody thought that the ability to remove an enum value was

Re: Replace (stat())[7] in TAP tests with -s

2023-10-02 Thread Dagfinn Ilmari Mannsåker
"Drouvot, Bertrand" writes: > Hi hackers, > > Please find attached a tiny patch to $SUBJECT. > > It: > > - provides more consistency to the way we get files size in TAP tests > - seems more elegant that relying on a hardcoded result position I approve of removing use of the list form of stat,

Re: Adding a pg_get_owned_sequence function?

2023-09-12 Thread Dagfinn Ilmari Mannsåker
Tom Lane writes: > Peter Eisentraut writes: >> Would it work to just overload pg_get_serial_sequence with regclass >> argument types? > > Probably not; the parser would have no principled way to resolve > pg_get_serial_sequence('foo', 'bar') as one or the other. I'm > not sure offhand if it

Re: Replace some cstring_to_text to cstring_to_text_with_len

2023-08-31 Thread Dagfinn Ilmari Mannsåker
Peter Eisentraut writes: > On 31.08.23 16:10, Ranier Vilela wrote: >> Em qui., 31 de ago. de 2023 às 09:51, Andrew Dunstan >> mailto:and...@dunslane.net>> escreveu: >> >> On 2023-08-31 Th 07:41, John Naylor wrote: >>> >>> On Thu, Aug 31, 2023 at 6:07 PM Ranier Vilela >>

Re: Replace some cstring_to_text to cstring_to_text_with_len

2023-08-31 Thread Dagfinn Ilmari Mannsåker
Ranier Vilela writes: > Em qui., 31 de ago. de 2023 às 12:12, Dagfinn Ilmari Mannsåker < > ilm...@ilmari.org> escreveu: > >> Ranier Vilela writes: >> >> > Em qui., 31 de ago. de 2023 às 10:12, Dagfinn Ilmari Mannsåker < >> > ilm...@ilmari.

Re: Replace some cstring_to_text to cstring_to_text_with_len

2023-08-31 Thread Dagfinn Ilmari Mannsåker
Ranier Vilela writes: > Em qui., 31 de ago. de 2023 às 10:12, Dagfinn Ilmari Mannsåker < > ilm...@ilmari.org> escreveu: > >> Andrew Dunstan writes: >> >> > On 2023-08-31 Th 07:41, John Naylor wrote: >> >> >> >> On Thu, Aug 31, 2023 at

Re: Adding a pg_get_owned_sequence function?

2023-08-31 Thread Dagfinn Ilmari Mannsåker
On Fri, 9 Jun 2023, at 20:19, Dagfinn Ilmari Mannsåker wrote: > Hi hackers, > > I've always been annoyed by the fact that pg_get_serial_sequence takes > the table and returns the sequence as strings rather than regclass. And > since identity columns were added, the name is mis

Re: Replace some cstring_to_text to cstring_to_text_with_len

2023-08-31 Thread Dagfinn Ilmari Mannsåker
Andrew Dunstan writes: > On 2023-08-31 Th 07:41, John Naylor wrote: >> >> On Thu, Aug 31, 2023 at 6:07 PM Ranier Vilela wrote: >> > >> > Em qui., 31 de ago. de 2023 às 00:22, Michael Paquier >> escreveu: >> >> >> >> On Wed, Aug 30, 2023 at 03:00:13PM -0300, Ranier Vilela wrote: >> >> >

Re: Make all Perl warnings fatal

2023-08-25 Thread Dagfinn Ilmari Mannsåker
Alvaro Herrera writes: > On 2023-Aug-10, Peter Eisentraut wrote: > >> I wanted to figure put if we can catch these more reliably, in the style of >> -Werror. AFAICT, there is no way to automatically turn all warnings into >> fatal errors. But there is a way to do it per script, by replacing >>

Re: Adding argument names to aggregate functions

2023-08-24 Thread Dagfinn Ilmari Mannsåker
On Thu, 24 Aug 2023, at 11:05, Daniel Gustafsson wrote: >> On 4 Aug 2023, at 01:36, Nathan Bossart wrote: >> >> On Wed, Jul 19, 2023 at 09:38:12PM +0200, Daniel Gustafsson wrote: >>> Great, thanks! I had a quick look at this while rebasing (as well as your >>> updated patch) and it seems like a

Re: Ignore 2PC transaction GIDs in query jumbling

2023-08-18 Thread Dagfinn Ilmari Mannsåker
Michael Paquier writes: > On Tue, Aug 15, 2023 at 08:49:37AM +0900, Michael Paquier wrote: >> Hmm. One issue with the patch is that we finish by considering >> DEALLOCATE ALL and DEALLOCATE $1 as the same things, compiling the >> same query IDs. The difference is made in the Nodes by assigning

Re: Ignore 2PC transaction GIDs in query jumbling

2023-08-14 Thread Dagfinn Ilmari Mannsåker
Michael Paquier writes: > On Sun, Aug 13, 2023 at 02:48:22PM +0800, Julien Rouhaud wrote: >> On Sun, Aug 13, 2023 at 03:25:33PM +0900, Michael Paquier wrote: >>> Perhaps not as much, actually, because I was just reminded that >>> DEALLOCATE is something that pg_stat_statements ignores. So this

Obsolete reference to pg_relation in comment

2023-07-26 Thread Dagfinn Ilmari Mannsåker
Hi hackers, Triggered by a discussion on IRC, I noticed that there's a stray reference to pg_relation in a comment that was added long after it was renamed to pg_class. Here's a patch to bring that up to speed. - ilmari >From e395f8cb293f674f45eb3847534de07c7124e738 Mon Sep 17 00:00:00 2001

Re: [PATCH] Check more invariants during syscache initialization

2023-07-26 Thread Dagfinn Ilmari Mannsåker
Aleksander Alekseev writes: > Hi Zhang, > >> That remind me to have a look other codes, and a grep search `oid != 0` show >> there are several files using old != 0. >> >> ``` >> .//src/bin/pg_resetwal/pg_resetwal.c: if (set_oid != 0) >> .//src/bin/pg_resetwal/pg_resetwal.c: if (set_oid != 0) >>

Re: Adding argument names to aggregate functions

2023-07-19 Thread Dagfinn Ilmari Mannsåker
Daniel Gustafsson writes: > This patch no longer applied but had a fairly trivial conflict so I've > attached > a rebased v3 addressing the conflict in the hopes of getting this further. Thanks for the heads-up! Turns out the conflict was due to the new json(b)_object_agg(_unique)(_strict)

Re: [PATCH] Using named captures in Catalog::ParseHeader()

2023-06-30 Thread Dagfinn Ilmari Mannsåker
Michael Paquier writes: > On Wed, Jun 14, 2023 at 10:30:23AM +0100, Dagfinn Ilmari Mannsåker wrote: >> Thanks for the review! > > v17 is now open, so applied this one. Thanks for committing! - ilmari

Re: Tab completion for CREATE SCHEMAAUTHORIZATION

2023-06-30 Thread Dagfinn Ilmari Mannsåker
Michael Paquier writes: > On Tue, May 09, 2023 at 12:26:16PM +0900, Michael Paquier wrote: >> That looks pretty much OK to me. One tiny comment I have is that this >> lacks brackets for the inner blocks, so I have added some in the v4 >> attached. > > The indentation was a bit wrong, so fixed

Re: [PATCH] Honor PG_TEST_NOCLEAN for tempdirs

2023-06-27 Thread Dagfinn Ilmari Mannsåker
Andrew Dunstan writes: > On 2023-06-26 Mo 19:55, Jacob Champion wrote: >> Hello, >> >> I was running the test_pg_dump extension suite, and I got annoyed that >> I couldn't keep it from deleting its dump artifacts after a successful >> run. Here's a patch to make use of PG_TEST_NOCLEAN (which

Re: Bytea PL/Perl transform

2023-06-23 Thread Dagfinn Ilmari Mannsåker
Andrew Dunstan writes: > On 2023-06-22 Th 16:56, Greg Sabino Mullane wrote: >> >> * Do all of these transforms need to be their own contrib modules? So >> much duplicated code across contrib/*_plperl already (and *plpython >> too for that matter) ... >> >> > > Yeah, that's a bit of a mess. Not

Re: [PATCH] Extend ALTER OPERATOR to support adding commutator, negator, hashes, and merges

2023-06-22 Thread Dagfinn Ilmari Mannsåker
Tom Lane writes: > Tommy Pavlicek writes: > >> Additionally, I wasn't sure whether it was preferred to fail or succeed on >> ALTERs that have no effect, such as adding hashes on an operator that >> already allows them or disabling hashes on one that does not. I chose to >> raise an error when

Re: pgindent vs. pgperltidy command-line arguments

2023-06-20 Thread Dagfinn Ilmari Mannsåker
Andrew Dunstan writes: > I'm intending to add some of the new pgindent features to > pgperltidy. Preparatory to that here's a rewrite of pgperltidy in perl - > no new features yet but it does remove the hardcoded path, and requires > you to pass in one or more files / directories as arguments.

Re: [PATCH] Missing dep on Catalog.pm in meson rules

2023-06-16 Thread Dagfinn Ilmari Mannsåker
Andres Freund writes: > Hi, > > On 2023-06-16 16:20:14 -0400, Andrew Dunstan wrote: >> Unless I'm misunderstanding, this doesn't look terribly feasible to me. You >> can only get at %INC by loading the module, which in many cases will have >> side effects. > > I was envisioning using %INC after

Re: [PATCH] Using named captures in Catalog::ParseHeader()

2023-06-14 Thread Dagfinn Ilmari Mannsåker
Michael Paquier writes: > On Thu, Jun 01, 2023 at 01:12:22PM +0100, Dagfinn Ilmari Mannsåker wrote: >> While I was rewriting the regexes I noticed that they were inconsistent >> about whether they accepted whitespace in the parameter lists, so I took >> the liberty to m

Re: [PATCH] Using named captures in Catalog::ParseHeader()

2023-06-13 Thread Dagfinn Ilmari Mannsåker
Dagfinn Ilmari Mannsåker writes: > However, now that we require Perl 5.14, we can use the named capture > feature (introduced in Perl 5.10) to make that a lot clearer, as in the > attached patch. Added to the open commitfest: https://commitfest.postgresql.org/43/4361/ - ilmari

Adding a pg_get_owned_sequence function?

2023-06-09 Thread Dagfinn Ilmari Mannsåker
Hi hackers, I've always been annoyed by the fact that pg_get_serial_sequence takes the table and returns the sequence as strings rather than regclass. And since identity columns were added, the name is misleading as well (which is even acknowledged in the docs, together with a suggestion for a

Re: Error in calculating length of encoded base64 string

2023-06-09 Thread Dagfinn Ilmari Mannsåker
Tom Lane writes: > Gurjeet Singh writes: >> On Thu, Jun 8, 2023 at 7:35 AM Tom Lane wrote: >>> This bug is very ancient, dating to commit 79d78bb26 which >>> added encode.c. (The other instances were presumably copied >>> from there.) Still, it doesn't quite seem worth back-patching. > >> Is

Re: [PATCH] Missing dep on Catalog.pm in meson rules

2023-06-01 Thread Dagfinn Ilmari Mannsåker
On Thu, 1 Jun 2023, at 22:16, Tristan Partin wrote: > Could you create a variable for the file instead of calling files() 3 > times? > >> catalog_pm = files('path/to/Catalog.pm') Sure, but which meson.build file should it go in? I know nothing about meson variable scoping. > -- > Tristan

[PATCH] Missing dep on Catalog.pm in meson rules

2023-06-01 Thread Dagfinn Ilmari Mannsåker
Hi Hackers, While hacking on Catalog.pm (over in https://postgr.es/m/87y1l3s7o9.fsf%40wibble.ilmari.org) I noticed that ninja wouldn't rebuild postgres.bki on changes to the module. Here's a patch that adds it to depend_files for the targets I culd find that invoke scripts that use it. - ilmari

[PATCH] Using named captures in Catalog::ParseHeader()

2023-06-01 Thread Dagfinn Ilmari Mannsåker
Hi Hackers, Peter's patch set for autogenerating syscache info (https://postgr.es/m/75ae5875-3abc-dafc-8aec-73247ed41cde%40eisentraut.org) touched on one of my least favourite parts of Catalog.pm: the parenthesis-counting nightmare that is the parsing of catalog header directives. However, now

Re: generate syscache info automatically

2023-05-31 Thread Dagfinn Ilmari Mannsåker
Peter Eisentraut writes: > The idea was mentioned in [0]. genbki.pl already knows everything about > system catalog indexes. If we add a "please also make a syscache for > this one" flag to the catalog metadata, we can have genbki.pl produce > the tables in syscache.c and syscache.h

Re: PG 16 draft release notes ready

2023-05-30 Thread Dagfinn Ilmari Mannsåker
tion thereof). That was just the only way to test it when it was >> > written, because psql's \bind command exist yet then. >> >> I see your point. How is this? >> >> Allow auto_explain to log query parameters used by parameterized >> statements (D

Re: PG 16 draft release notes ready

2023-05-25 Thread Dagfinn Ilmari Mannsåker
it about auto_explain and query parameters says: > Allow auto_explain to log query parameters used in executing prepared > statements (Dagfinn Ilmari Mannsåker) > > This is controlled by auto_explain.log_parameter_max_length, and by > default query parameters will be logged with no lengt

Re: Implement generalized sub routine find_in_log for tap test

2023-05-25 Thread Dagfinn Ilmari Mannsåker
vignesh C writes: > Hi, > > The recovery tap test has 4 implementations of find_in_log sub routine > for various uses, I felt we can generalize these and have a single > function for the same. The attached patch is an attempt to have a > generalized sub routine find_in_log which can be used by

Re: Large files for relations

2023-05-12 Thread Dagfinn Ilmari Mannsåker
Thomas Munro writes: > On Fri, May 12, 2023 at 8:16 AM Jim Mlodgenski wrote: >> On Mon, May 1, 2023 at 9:29 PM Thomas Munro wrote: >>> I am not aware of any modern/non-historic filesystem[2] that can't do >>> large files with ease. Anyone know of anything to worry about on that >>> front? >>

Re: Discussion: psql \et -> edit the trigger function

2023-05-10 Thread Dagfinn Ilmari Mannsåker
Kirk Wolak writes: > We already have > \ef > \ev > > The use case here is simply that it saves me from: > \d > [scroll through all the fields] > [often scroll right] > select function name > \ef [paste function name] > > and tab completion is much narrower I think it would make more sense to

Re: Tab completion for CREATE SCHEMAAUTHORIZATION

2023-05-08 Thread Dagfinn Ilmari Mannsåker
Michael Paquier writes: > On Tue, May 02, 2023 at 01:19:49PM +0100, Dagfinn Ilmari Mannsåker wrote: >> Dagfinn Ilmari Mannsåker writes: >>> This is for completing the word CREATE itself after CREATE SCHEMA >>> [[] AUTHORIZATION] . The things that can come after t

Re: Tab completion for CREATE SCHEMAAUTHORIZATION

2023-05-02 Thread Dagfinn Ilmari Mannsåker
Dagfinn Ilmari Mannsåker writes: > Michael Paquier writes: > >> On Sat, Apr 15, 2023 at 11:06:25AM +0900, Michael Paquier wrote: >>> Thanks, I'll look at it. >> >> + else if (Matches("CREATE", "SCHEMA", "AUTHORIZATION", Ma

Re: Tab completion for CREATE SCHEMAAUTHORIZATION

2023-05-02 Thread Dagfinn Ilmari Mannsåker
Michael Paquier writes: > On Sat, Apr 15, 2023 at 11:06:25AM +0900, Michael Paquier wrote: >> Thanks, I'll look at it. > > + else if (Matches("CREATE", "SCHEMA", "AUTHORIZATION", MatchAny) || > +Matches("CREATE", "SCHEMA", MatchAny, "AUTHORIZATION", MatchAny)) > +

Re: constants for tar header offsets

2023-04-18 Thread Dagfinn Ilmari Mannsåker
Robert Haas writes: > On Tue, Apr 18, 2023 at 12:06 PM Tom Lane wrote: >> Hmm, you're right: I checked the POSIX.1-2018 spec as well, and >> it agrees that the prefix field is 155 bytes long. Perhaps just >> add another comment line indicating that 12 bytes remain unassigned? > > OK. Here's

Re: Adding argument names to aggregate functions

2023-04-18 Thread Dagfinn Ilmari Mannsåker
Jim Jones writes: > On 18.04.23 10:58, I wrote: >> On 14.04.23 12:03, Dagfinn Ilmari Mannsåker wrote: >>> Thanks for the heads-up, here's a rebased patch. I've also formatted >>> the lines to match what reformat_dat_file.pl wants.  It also wanted to >>> refo

Re: Tab completion for CREATE SCHEMAAUTHORIZATION

2023-04-14 Thread Dagfinn Ilmari Mannsåker
Michael Paquier writes: > On Wed, Aug 11, 2021 at 10:16:15AM +0900, Michael Paquier wrote: >> + else if (Matches("CREATE", "SCHEMA", "AUTHORIZATION")) >> + COMPLETE_WITH_QUERY(Query_for_list_of_owner_roles); >> + else if (Matches("CREATE", "SCHEMA", MatchAny,

Re: Adding argument names to aggregate functions

2023-04-14 Thread Dagfinn Ilmari Mannsåker
Jim Jones writes: > On 12.04.23 19:53, Dagfinn Ilmari Mannsåker wrote: >> Dagfinn Ilmari Mannsåker writes: >> >>> Hi hackers, >>> >>> I'm sure I'm not the only one who can never remember which way around >>> the value and delimiter argu

Re: Tab completion for AT TIME ZONE

2023-04-14 Thread Dagfinn Ilmari Mannsåker
Hi Jim, Thanks for having a look at my patch, but please don't top post on PostgreSQL lists. Jim Jones writes: > Hi, > > On 12.04.23 19:53, Dagfinn Ilmari Mannsåker wrote: >> Dagfinn Ilmari Mannsåker writes: >> >>> Hi hackers, >>> >>> A whil

Re: doc: add missing "id" attributes to extension packaging page

2023-04-13 Thread Dagfinn Ilmari Mannsåker
Peter Eisentraut writes: > On 06.04.23 16:19, Brar Piening wrote: >> 001-make_html_ids_discoverable_v5.postgresql.patch which needs to be >> applied to the postgresql repository. It adds the XSLT to generate the >> id links and the CSS to hide/display them. I've added comments as >> suggested

Re: Adding argument names to aggregate functions

2023-04-12 Thread Dagfinn Ilmari Mannsåker
Dagfinn Ilmari Mannsåker writes: > Hi hackers, > > I'm sure I'm not the only one who can never remember which way around > the value and delimiter arguments go for string_agg() and has to look it > up in the manual every time. To make it more convenient, here's a patch > tha

Re: Tab completion for AT TIME ZONE

2023-04-12 Thread Dagfinn Ilmari Mannsåker
Dagfinn Ilmari Mannsåker writes: > Hi hackers, > > A while back we added support for completing time zone names after SET > TIMEZONE, but we failed to do the same for the AT TIME ZONE operator. > Here's a trivial patch for that. Added to the 2023-07 com

Re: Direct I/O

2023-04-12 Thread Dagfinn Ilmari Mannsåker
Andrew Dunstan writes: > On 2023-04-12 We 10:23, Dagfinn Ilmari Mannsåker wrote: >> Andrew Dunstan writes: >> >>> On 2023-04-12 We 01:48, Thomas Munro wrote: >>>> On Wed, Apr 12, 2023 at 3:04 PM Thomas Munro >>>> wrote: >>>>> On

Re: Direct I/O

2023-04-12 Thread Dagfinn Ilmari Mannsåker
Andrew Dunstan writes: > On 2023-04-12 We 01:48, Thomas Munro wrote: >> On Wed, Apr 12, 2023 at 3:04 PM Thomas Munro wrote: >>> On Wed, Apr 12, 2023 at 2:56 PM Christoph Berg wrote: I'm hitting a panic in t_004_io_direct. The build is running on overlayfs on tmpfs/ext4 (upper/lower)

Re: Direct I/O

2023-04-12 Thread Dagfinn Ilmari Mannsåker
Thomas Munro writes: > I think I have that working OK. Any Perl hackers want to comment on > my use of IO::File (copied from examples on the internet that showed > how to use O_DIRECT)? I am not much of a perl hacker but according to > my package manager, IO/File.pm came with perl itself.

Tab completion for AT TIME ZONE

2023-03-29 Thread Dagfinn Ilmari Mannsåker
Hi hackers, A while back we added support for completing time zone names after SET TIMEZONE, but we failed to do the same for the AT TIME ZONE operator. Here's a trivial patch for that. - ilmari >From 57138e851552a99174d00a0e48ce55ca3170df75 Mon Sep 17 00:00:00 2001 From:

Re: MacOS: xsltproc fails with "warning: failed to load external entity"

2023-03-27 Thread Dagfinn Ilmari Mannsåker
Daniel Gustafsson writes: >> On 27 Mar 2023, at 10:41, Julien Rouhaud wrote: >> On Mon, Mar 27, 2023 at 10:32:52AM +0200, Daniel Gustafsson wrote: On 27 Mar 2023, at 10:24, Julien Rouhaud wrote: > FTR the documented XML_CATALOG_FILES environment variable is only valid for Intel

Re: Making background psql nicer to use in tap tests

2023-03-17 Thread Dagfinn Ilmari Mannsåker
Andrew Dunstan writes: > On 2023-03-17 Fr 10:08, Daniel Gustafsson wrote: >>> Why is $restart_before_query a package/class level value instead of >>> an instance value? And why can we only ever set it to 1 but not back >>> again? Maybe we don't want to, but it looks odd. >> It was mostly a POC

Adding argument names to aggregate functions

2023-02-27 Thread Dagfinn Ilmari Mannsåker
Hi hackers, I'm sure I'm not the only one who can never remember which way around the value and delimiter arguments go for string_agg() and has to look it up in the manual every time. To make it more convenient, here's a patch that adds proargnames to its pg_proc entries so that it can be seen

  1   2   3   4   >