Postgres Pro
Downloads
Home   >   mailing lists

Re: Prevent psql \watch from running queries that return no rows - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: Prevent psql \watch from running queries that return no rows
Date
Msg-id CAKAnmmL-ame4jd0W1+X_wgywjQOwdh_ZJhF4dtWsQaGs0fM11Q@mail.gmail.com
Whole thread Raw
In response to Re: Prevent psql \watch from running queries that return no rows  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Prevent psql \watch from running queries that return no rows
List pgsql-hackers
Tree view
On Sat, Jun 3, 2023 at 5:58 PM Michael Paquier <michael@paquier.xyz> wrote:

Wouldn't something like a target_rows be more flexible?  You could use
this parameter with a target number of rows to expect, zero being one
choice in that.

Thank you! That does feel better to me. Please see attached a new v2 patch that uses 
a min_rows=X syntax (defaults to 0). Also added some help.c changes.

Cheers,
Greg

Attachment

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: running logical replication as the subscription owner
Next
From: Tomas Vondra
Date:
Subject: Re: Do we want a hashset type?