the 'use DBI;' already does a connect to the server and tries to read
the names of the available databases from the server:
I would check this assumption, because it strikes me as extremely
unlikely. DBI does not load any drivers at use or require/import time.
You could add some tracing state
[Adding the mailing list back in]
You might try turning on DBI_TRACE which will tell you *which*
DBD/Pg.pm driver file and version it thinks it successfully loaded.
I added the requisite lines to httpd.conf as per here
https://perl.apache.org/docs/1.0/guide/databases.html#Debugging_code_which
Sorry that I keep dripping this out. My mail reader doesn't parse your
html emails well and I haven't been reading them thoroughly.
You trace output also included this:
install_driver: DBD::Pg version undef loaded from
/usr/lib64/perl5/vendor_perl/Bundle/DBD/Pg.pm
Is that the expected /
On Mon Oct 30, 2023 at 11:21:42PM +, Johnson, Bruce E - (bjohnson) wrote:
DBI 1.643-ithread default trace level set to 0x0/3 (pid 101338 pi 5613a02b73e0)
at DBI.pm line 294 via startup.pl line 5
-- DBI::END ($@: , $!: )
DBI 1.643-ithread default trace level set to 0x0/3 (pid 101338
Using perl 5.28 and mysql on windows.
Question: Can DBI give me a field from the record on the main table causing
the duplicate so I can add that to the record going to the duplicate table?
It might be preferable to do this directly in SQL, using triggers. See
here for a similar question: