MIME-Version: 1.0
References: <20210309104530.GN11758@artax.karlin.mff.cuni.cz>
 <CAASsAGZCq2UOU_wmqO99kku5T3KwTOATi7NzdN_Zgk6mR-CWpA@mail.gmail.com>
 <20210309110619.GO11758@artax.karlin.mff.cuni.cz>
 <CA+mi_8auuDxMLLFS3WpYw-7jMzu8KM69WpaJbGGw=66aPLcsqw@mail.gmail.com>
 <20210309115316.GP11758@artax.karlin.mff.cuni.cz>
In-Reply-To: <20210309115316.GP11758@artax.karlin.mff.cuni.cz>
From: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Date: Tue, 9 Mar 2021 15:02:03 +0100
Message-ID: 
 <CA+mi_8aEuy8bgegNVw40uaBg0skoQx=Fuiby+Strx09B2sO6ew@mail.gmail.com>
Subject: Re: connect using env. variables
To: Hans Ginzel <hans@matfyz.cz>
Cc: Sebastiaan Mannem <sebastiaan.mannem@enterprisedb.com>,
 psycopg@postgresql.org
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bmi_8aEuy8bgegNVw40uaBg0skoQx%3DFuiby%2BStrx09B2sO6ew%40mail.gmail.com>
Precedence: bulk

On Tue, 9 Mar 2021 at 12:53, Hans Ginzel <hans@matfyz.cz> wrote:
>
> Thank you.
>
> Is there a reason why connect() must get the empty string as parametr, please?

No, and I'm happy to make the dsn string optional, as you requested in
github. psycopg3 already works this way and you can use connect(). I
just wanted to point out that you can do what you want to do already:
connecting using only the PG* env var or the parse_dsn() produce.

It's one of these things that is ugly but has been that way for so
long that we are used to it. Or better, which should have been fixed
when we introduced the possibility to pass both the dsn string and the
keywords to connect(), because in the past there was no parse_dsn()
and facility to merge the two.

Cheers

-- Daniele