Incorrect check in 037_except.pl?

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Incorrect check in 037_except.pl?
Date: 2026-07-22 12:59:25
Message-ID: CAHGQGwGfXUO7f4t6KNGurYwg6QsnLtpP0K3EACbAwYWtxGfKfQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

$result =
$node_publisher->safe_psql('postgres', "SELECT * FROM tab1 ORDER BY a");
is( $result, qq(1
2),
"check replication of a table in the EXCEPT clause of one
publication but included by another"
);

In 037_except.pl, this query is executed on the publisher. But,
if the intent is to verify that rows inserted on the publisher are
replicated to the subscriber, shouldn't this query be executed on
the subscriber instead? IOW, should "$node_publisher" here be
"$node_subscriber"? Or am I missing something?

Regards,

--
Fujii Masao

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message ZizhuanLiu X-MAN 2026-07-22 13:02:27 Re: support create index on virtual generated column.
Previous Message Fujii Masao 2026-07-22 12:34:30 Re: Allow pg_read_all_stats to see database size in \l+