Message-ID: <d1be0805-c301-4919-8d9b-9238803a03ad@gmail.com>
Date: Fri, 29 Mar 2024 16:52:56 -0600
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: How to reference a DB with a period in its name ?
Content-Language: en-CA
To: pgsql-general@lists.postgresql.org
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>
From: Rob Sargent <robjsargent@gmail.com>
In-Reply-To: 
 <CAEs=6Dmg6epZ7FH3aOZY0UncGr8x3=OZ7WLnMHTsOG2P=Qog_Q@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/d1be0805-c301-4919-8d9b-9238803a03ad%40gmail.com>
Precedence: bulk


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?