Re: pgsql: Implement pg_wal_replay_wait() stored procedure

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgsql: Implement pg_wal_replay_wait() stored procedure
Date: 2024-11-04 16:53:20
Message-ID: CA+TgmoaJ4=eq=6A9UMWH6vFuvOSE0Zy5-HN3RPP=58be6zA8Jw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Mon, Nov 4, 2024 at 10:57 AM Heikki Linnakangas <hlinnaka(at)iki(dot)fi> wrote:
> > There's also the patch that Heikki posted to wait using a
> > protocol-level facility.
>
> It was Peter E

Oops.

> > Maybe that's just a better fit and we don't need either a procedure
> > or new syntax.
> I think it would still be good to expose the feature at SQL level too.
> Makes it easier to test and makes it usable without client library
> changes, for example.

OK. Well then I agree with Álvaro. If using a procedure isn't working
out nicely, it's better to consider alternatives than to force a round
peg into a square hole (with due regard for the fact that you can fit
anything through the square hole if you make the square hole big
enough...).

--
Robert Haas
EDB: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2024-11-04 17:11:58 Re: pgsql: Implement pg_wal_replay_wait() stored procedure
Previous Message Heikki Linnakangas 2024-11-04 16:42:15 pgsql: docs: Consistently use <optional> to indicate optional parameter

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2024-11-04 17:11:58 Re: pgsql: Implement pg_wal_replay_wait() stored procedure
Previous Message Heikki Linnakangas 2024-11-04 16:42:24 Re: documentation structure