Re: Allow logical replication to copy tables in binary format - Mailing list pgsql-hackers

From Melih Mutlu
Subject Re: Allow logical replication to copy tables in binary format
Date
Msg-id CAGPVpCQJFwS5E=xAhw0m+ayNNnZTTBySNyzCOS8FyEApz76zAQ@mail.gmail.com
Whole thread Raw
In response to Re: Allow logical replication to copy tables in binary format  (vignesh C <vignesh21@gmail.com>)
Responses Re: Allow logical replication to copy tables in binary format  (Peter Smith <smithpb2250@gmail.com>)
RE: Allow logical replication to copy tables in binary format  ("shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>)
RE: Allow logical replication to copy tables in binary format  ("houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>)
List pgsql-hackers
Hi,

vignesh C <vignesh21@gmail.com>, 15 Mar 2023 Çar, 18:12 tarihinde şunu yazdı:
One comment:
1) There might be a chance the result order of select may vary as
"ORDER BY" is not specified,  Should we add "ORDER BY" as the table
has multiple rows:
+# Check the synced data on the subscriber
+$result = $node_subscriber->safe_psql('postgres', 'SELECT a,b FROM
+public.test_col_order;');
+
+is( $result, '1|2
+3|4', 'check synced data on subscriber for different column order');

Right, it needs to be ordered. Fixed.

Thanks,
--
Melih Mutlu
Microsoft
Attachment

pgsql-hackers by date:

Previous
From: "Gregory Stark (as CFM)"
Date:
Subject: Re: On login trigger: take three
Next
From: "Gregory Stark (as CFM)"
Date:
Subject: Re: Commitfest 2023-03 starting tomorrow!