PL/pgSQL RETURN QUERY and DOMAIN CHECKs

2023-08-23 Thread Christian Barthel
CT v::t from test; 167 *** +---+ 168 *** | v | 169 *** +---+ 170 *** | (1,1) | 171 *** | (3,2) | 172 *** | (4,5) | 173 *** | (4,5) | 174 *** +---+ 175 *** (4 rows) 176 */ --8<---cut here---end--->8--- Is that on purpose? Have I missed something in the documentation? -- Christian Barthel

Re: Logical replication versus pglogical on PostgreSQL 14

2022-07-29 Thread Christian Barthel
re you that the development of pglogical continues. Furthermore, the last release is from Dec, 2021 and the last commit is 12 days ago, <https://github.com/2ndQuadrant/pglogical>. -- Christian Barthel

Re: FK Constraint sort order with pg_dump

2022-07-21 Thread Christian Barthel
On Thursday, July 21, 2022, Adrian Klaver wrote: > On 7/21/22 10:25, Christian Barthel wrote: >> Hello, The sorting order of FK constraints with the same name is >> based on the OID (because it lands in the “Usually shouldn’t get >> here” OID comparison block at [1]). Wou

FK Constraint sort order with pg_dump

2022-07-21 Thread Christian Barthel
n the table if it exists). Any thoughts on that? [1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/bin/pg_dump/pg_dump_sort.c;h=80641cd79a2e6ce0a10bd55218b10d22ac369ed5;hb=7c850320d8cfa5503ecec61c2559661b924f7595#l212 (*) Tested on 14.4 -- Christian Barthel modified src/bi