From: Rob Sargent <robjsargent@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: How to reference a DB with a period in its name ?
Date: Fri, 29 Mar 2024 16:52:56 -0600
Message-ID: <d1be0805-c301-4919-8d9b-9238803a03ad@gmail.com> (raw)
In-Reply-To: <CAEs=6Dmg6epZ7FH3aOZY0UncGr8x3=OZ7WLnMHTsOG2P=Qog_Q@mail.gmail.com>
References: <CAEs=6DniFeqNT6RHCcPiiFFWzTGzQKMKboNch72Ftadr_W-Cdw@mail.gmail.com>
<CAKFQuwa+hOABHbcq5UBThqpGCZ2_d2ObQy0YPfOdNoDWrkD6fg@mail.gmail.com>
<CAKFQuwbSsRU=yYwR7k9ituWTj_D+A8+rxiRWgq03o990GcfDVA@mail.gmail.com>
<CAEs=6Dmg6epZ7FH3aOZY0UncGr8x3=OZ7WLnMHTsOG2P=Qog_Q@mail.gmail.com>
On 3/29/24 15:36, David Gauthier wrote:
> Ya, I kind of agree on the >1 DB connections not allowed. It
> (perl/DBI) does allow for >1 active DB handles (objects). But of
> course those handles/objects have different names and that's how to
> work with the different ones (not a DB prefix like what I have).
> Still, it accepted the name in the syntax if it didn't have a ".". I
> kinda liked the db prefix because I'm doing these sweeping deletes and
> I wanted to make extra-sure that I was deleting from the correct DB.
>
> I'm going to ask them to just create another DB without the "." in the
> name. All the code has the prefix and I don't want to uproot that
> (because it's working).
Or is it working, really? Or are you working around it?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: robjsargent@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: How to reference a DB with a period in its name ?
In-Reply-To: <d1be0805-c301-4919-8d9b-9238803a03ad@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox