* Konstantin Malanchev [2019-07-09 11:51]:
> Hello,
>
> I'm running PostgreSQL 11.4 on Linux 4.12.14 and I see the following issue
> while executing single one query:
> ERROR: could not resize shared
> memory segment "/PostgreSQL.1596105766" to 536870912 bytes: No space left on
> device
>
> I
* Konstantin Malanchev [2019-07-09 12:10]:
> Hello Jean,
>
> I have 8 GB RAM and /dev/shm size is 4GB, and there is no significant memory
> usage by other system processes. I surprised that Postgres uses more space in
> /dev/shm than sharred_buffers parameter allows, probably I don't understand
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).
Why do I get it in braces?
Is there a way without specifying specific fie
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
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
