On Sat, Jun 15, 2019 at 1:50 AM Tiemen Ruiten wrote:
> During normal operation I don't mind that it takes a long time, but when
> performing maintenance I want to be able to gracefully bring down the master
> without long delays to promote one of the standby's.
Maybe an "immediate" mode shutdow
so 15. 6. 2019 v 16:20 odesílatel Jean Louis napsal:
> Dear Pavel,
>
> Ahoj.
>
> * Pavel Stehule [2019-06-15 11:37]:
> > you can write own function that will do what you want
> >
> > create or replace function rec_concat_fields(record, text)
> > returns text as $$
> > begin
> > return stri
Dear Thomas,
* Thomas Kellerer [2019-06-15 11:37]:
> Jean Louis schrieb am 15.06.2019 um 13:19:
> > I have tried doing something like:
> >
> > SELECT concat_ws(' ', table.*) FROM table;
> >
> > and if I do that way, it is essentially same as
> >
> > SELECT concat(table.*) FROM table;
> >
> >
Dear Pavel,
Ahoj.
* Pavel Stehule [2019-06-15 11:37]:
> you can write own function that will do what you want
>
> create or replace function rec_concat_fields(record, text)
> returns text as $$
> begin
> return string_agg(value, '|') from json_each_text(row_to_json($1));
> end
> $$ lang
On 6/14/19 7:24 PM, Leandro Guimarães wrote:
Hi Tim, thanks for you answer!
The columns were just examples, but let me explain the database
structure, the fields in *bold are the keys*:
*customer_id integer*
*date_time timestamp*
*indicator_id integer*
*element_id integer*
indicator_value dou
On Sat, 15 Jun 2019 at 02:33, Rob Nikander wrote:
> Hi,
>
> I'm experimenting with Java client libraries (the usual JDBC and some
> other async projects, eg [1]). So far, I'm not finding ways to select/read
> composite types without ugly string parsing. The simple cases are okay, but
> if I have
Hi
so 15. 6. 2019 v 8:20 odesílatel Jean Louis napsal:
> Hello,
>
> I have tried doing something like:
>
> SELECT concat_ws(' ', table.*) FROM table;
>
> and if I do that way, it is essentially same as
>
> SELECT concat(table.*) FROM table;
>
> and I get the items in braces like (1,something).
>
Jean Louis schrieb am 15.06.2019 um 13:19:
> I have tried doing something like:
>
> SELECT concat_ws(' ', table.*) FROM table;
>
> and if I do that way, it is essentially same as
>
> SELECT concat(table.*) FROM table;
>
> and I get the items in braces like (1,something).
>
> Why do I get it i
On Fri, Jun 14, 2019 at 5:43 PM Stephen Frost wrote:
> Greetings,
>
> * Tiemen Ruiten (t.rui...@tech-lab.io) wrote:
> > checkpoint_timeout = 60min
>
> That seems like a pretty long timeout.
>
My reasoning was that a longer recovery time to avoid writes would be
acceptable because there are two m
