Re: PostgreSQL on Windows' state

2020-09-23 Thread Tony Shelver
A quick Google search came up with this: https://www.npgsql.org. No experience with it however. We moved to Python just before we moved to Postgresql. The key motivator for C# at the time is now more of a React / JS proponent Everything in our stack apart from 1 proprietary Java / Oracle

Re: PG 13 trusted extensions and pg_available_extensions

2020-09-23 Thread Julien Rouhaud
On Thu, Sep 24, 2020 at 10:58 AM Michael Paquier wrote: > > On Wed, Sep 23, 2020 at 03:28:45PM +, Daniel Westermann (DWE) wrote: > > I was playing a bit with trusted extensions and wondered if there is > > a reason that the "trusted" flag is not exposed in pg_available_extensions. > > I

Re: PG 13 trusted extensions and pg_available_extensions

2020-09-23 Thread Michael Paquier
On Wed, Sep 23, 2020 at 03:28:45PM +, Daniel Westermann (DWE) wrote: > I was playing a bit with trusted extensions and wondered if there is > a reason that the "trusted" flag is not exposed in pg_available_extensions. > I believe that information would be quite useful so one can easily >

Re: PostgreSQL on Windows' state

2020-09-23 Thread raf
On Wed, Sep 23, 2020 at 12:52:58PM +0200, Alessandro Dentella wrote: > On Wed, Sep 23, 2020 at 12:21:39PM +0200, Pavel Stehule wrote: > > st 23. 9. 2020 v 10:38 odesílatel Alessandro Dentella < > > sandro.dente...@gmail.com> napsal: > > > > > > > > Hi, > > > > > > disclaimer: I've never been a

Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?

2020-09-23 Thread Adrian Klaver
On 9/23/20 11:51 AM, tutilu...@tutanota.com wrote: It is not deprecated or legacy and it is still used by many. The issue is that people try to do 'partial' dumps without reading the docs on what those switches actually do and the potential conflicts therein. For large

Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?

2020-09-23 Thread Rob Sargent
That would entail building an AI into the code that would deal with all the possible OS(versions), Postgres(versions), hardware permutations. I... guess. If "AI" means "a series of ifs". Which is what software... is? I doubt that people who can make the world's most advanced open

Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?

2020-09-23 Thread tutiluren
>> I have to agree that pg_dump is largely a step child backup program. >> It has consistently been found over the years to be lacking in a >> number of areas. Unfortunately, working on pg_dump isn't sexy and it >> is difficult to get volunteers or even paid resources to do such a >> thing.

PG 13 trusted extensions and pg_available_extensions

2020-09-23 Thread Daniel Westermann (DWE)
Hi, I was playing a bit with trusted extensions and wondered if there is a reason that the "trusted" flag is not exposed in pg_available_extensions. I believe that information would be quite useful so one can easily identify extensions that can be installed as "normal" user. Regards Daniel

SV: PostgreSQL on Windows' state

2020-09-23 Thread Niels Jespersen
-Oprindelig meddelelse- >Fra: Alessandro Dentella >Sendt: 23. september 2020 10:38 >Til: pgsql-general >Emne: PostgreSQL on Windows' state > >Hi, > >disclaimer: I've never been a Windows user and I send this email just on >behalf of a friend that has problems convincing his team to use

Re: PostgreSQL on Windows' state

2020-09-23 Thread Thomas Kellerer
Alessandro Dentella schrieb am 23.09.2020 um 10:37: Hi, disclaimer: I've never been a Windows user and I send this email just on behalf of a friend that has problems convincing his team to use PostgreSQL. I'd like to understand if what the team replies to him is correct or not. The final

Re: PostgreSQL on Windows' state

2020-09-23 Thread Thomas Munro
On Wed, Sep 23, 2020 at 10:53 PM Alessandro Dentella wrote: > Thanks Pavel, but psycopg2 (that I always use is just for Python). T > hey claim/complain that from c# there's no native solution. Maybe https://www.npgsql.org/?

Re: PostgreSQL on Windows' state

2020-09-23 Thread Alessandro Dentella
On Wed, Sep 23, 2020 at 12:21:39PM +0200, Pavel Stehule wrote: > st 23. 9. 2020 v 10:38 odesílatel Alessandro Dentella < > sandro.dente...@gmail.com> napsal: > > > > > Hi, > > > > disclaimer: I've never been a Windows user and I send this email just on > > behalf > > of a friend that has problems

Re: PostgreSQL on Windows' state

2020-09-23 Thread Pavel Stehule
st 23. 9. 2020 v 10:38 odesílatel Alessandro Dentella < sandro.dente...@gmail.com> napsal: > > Hi, > > disclaimer: I've never been a Windows user and I send this email just on > behalf > of a friend that has problems convincing his team to use PostgreSQL. > > I'd like to understand if what the

PostgreSQL on Windows' state

2020-09-23 Thread Alessandro Dentella
Hi, disclaimer: I've never been a Windows user and I send this email just on behalf of a friend that has problems convincing his team to use PostgreSQL. I'd like to understand if what the team replies to him is correct or not. The final project should work with Python (we know it just works)