Pavel Stehule writes:
>> 2016-11-21 8:09 GMT+01:00 Craig Ringer :
>>> Simple fix here is to append COLLATE "C" after the ORDER BY.
> here is a patch
Pushed, thanks.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
2016-11-21 8:13 GMT+01:00 Pavel Stehule :
>
>
> 2016-11-21 8:09 GMT+01:00 Craig Ringer :
>
>> On 21 November 2016 at 14:45, Pavel Stehule
>> wrote:
>>
>> > SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*),
>> > (array_agg(data))[1], (array_agg(data))[count(*)]
>> > FROM pg_logical_slot_g
2016-11-21 8:09 GMT+01:00 Craig Ringer :
> On 21 November 2016 at 14:45, Pavel Stehule
> wrote:
>
> > SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*),
> > (array_agg(data))[1], (array_agg(data))[count(*)]
> > FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE
> data
>
On 21 November 2016 at 14:45, Pavel Stehule wrote:
> SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*),
> (array_agg(data))[1], (array_agg(data))[count(*)]
> FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data
> ~ 'INSERT'
> GROUP BY 1 ORDER BY 1;
>
> but result is
2016-11-16 5:54 GMT+01:00 Pavel Stehule :
> Hi
>
> I have a repeated problem with regress tests
>
> master, Fedora 25,
>
> running on port 50848 with PID 5548
> == creating database "regression" ==
> CREATE DATABASE
> ALTER DATABASE
> == running regressi
Hi
I have a repeated problem with regress tests
master, Fedora 25,
running on port 50848 with PID 5548
== creating database "regression" ==
CREATE DATABASE
ALTER DATABASE
== running regression test queries==
test ddl
Added to TODO:
Allow the regression tests to start postmaster with -i so the tests
can be run on systems that don't support unix-domain sockets
---
Tom Lane wrote:
> Kurt Roeckx <[EMAIL PROTECTED]> writes:
> > The regre
Kurt Roeckx <[EMAIL PROTECTED]> writes:
> The regression tests will fail to start on a system that doesn't
> have, or wasn't compiled for, unix domain sockets.
> I see some options to fix this:
> - Always start with -i
> - Make the "unix_sockets" variable depend on
> HAVE_UNIX_SOCKETS intead of l
The regression tests will fail to start on a system that doesn't
have, or wasn't compiled for, unix domain sockets.
The pg_regress script will start the postmaster with the -i
option in case of QNX and BEOS, but not for instance in case of
WIN32.
I see some options to fix this:
- Always start wit