dup(0) fails on Ubuntu 20.04 and macOS 10.15 with 13.0

2020-10-05 Thread Mario Emmenlauer
shows `1048576` which seems also relatively high (but must be the default, not changed by me). Does this problem mean anything to anyone? I'm completely lost where to go from here, or what to try next :-( Help would be greatly appreciated! All the best, Mario Emmenlauer

Re: dup(0) fails on Ubuntu 20.04 and macOS 10.15 with 13.0

2020-10-05 Thread Mario Emmenlauer
On 05.10.20 13:22, Mario Emmenlauer wrote: > I've used PostgreSQL since version 9.x successfully on Linux, macOS > and Windows. Today I've upgraded from 12.3 to 13.0 and suddenly I can > not start the server any more on Ubuntu 20.04 (inside Docker on Ubuntu > 18.04) and on m

Is it possible to write a generic UPSERT?

2020-11-12 Thread Mario Emmenlauer
definitions because we create all tables in code. We currently do not have concurrency concerns so a more complex solution using multiple statements would be fine. Has anybody ever done something like this? Is there an SQL way to achieve this? Or another programmatic way? All the best,

Re: Is it possible to write a generic UPSERT?

2020-11-12 Thread Mario Emmenlauer
On 12.11.20 17:55, Alban Hertroys wrote: >> On 12 Nov 2020, at 14:58, Mario Emmenlauer wrote: > > (…) > >> But the statement is slightly complex to type, and I find me and my >> colleagues often spend more time on this than I would hope. Our two >> main challeng

Re: Is it possible to write a generic UPSERT?

2020-11-13 Thread Mario Emmenlauer
On 12.11.20 18:34, Michael Lewis wrote: > On Thu, Nov 12, 2020 at 6:58 AM Mario Emmenlauer <mailto:ma...@emmenlauer.de>> wrote: > > I can see how "ON CONFLICT" is very powerful. But that power seems > often a burden for us. We would prefer something that

lib and share are installed differently, but why?

2021-08-30 Thread Mario Emmenlauer
ing, which indeed is true (because the file is at A/share/postgresql.bki). Any help would be appreciated! All the best, Mario Emmenlauer -- BioDataAnalysis GmbH, Mario Emmenlauer Tel. Buero: +49-89-74677203 Balanstr. 43 mailto: memmenlauer * biodataan

Re: lib and share are installed differently, but why?

2021-08-30 Thread Mario Emmenlauer
On 30.08.21 16:24, Tom Lane wrote: > Mario Emmenlauer writes: >> I've been building and using PostgreSQL from source for a few years >> now, thanks for the awesome work! > >> Since upgrading from 12.5 to 12.8, I've found a problem that I can >> not resolve

Re: dup(0) fails on Ubuntu 20.04 and macOS 10.15 with 13.0

2021-09-01 Thread Mario Emmenlauer
On 05.10.20 14:35, Tom Lane wrote: > Mario Emmenlauer writes: >> I get reproducibly the error: >> 2020-10-05 11:48:19.720 CEST [84731] WARNING: dup(0) failed after 0 >> successes: Bad file descriptor > > Hmph. That code loop assumes that stdin exists to be duplic