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).
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).
Thanks David !
On Fri, Mar 29, 2024 at 5:22 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Fri, Mar 29, 2024 at 2:20 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:On Fri, Mar 29, 2024 at 2:16 PM David Gauthier <dfgpostgres@xxxxxxxxx> wrote:I tried encapsulating the DB name in double quotes (no good)This is what the documentation says you are supposed to do for non-simple identifiers so you need to show your work to understand where you went wrong.Actually, you really aren't supposed to put the database name in there at all; it's pointless since there is no ability to reference a database other than the one you are connected to.David J.
