I have a script that loads large (40 Meg files) into a postgres
database. I would like to issue a vacuum and analyze, but I get the
message "VACUUM cannot run inside a BEGIN/END block" when I
try to send the message. Autoconfirm is off, an the vacuum
statement comes right after a commit.
I am using:
postgres 7.2.2 and 7.2.3 (have both available, tried both)
DBD::Pg 1.13
DBI::1.32
I cannot find any method that will let me do a statement that is not
in a transaction in Pg. Is there any way to issue
this statement?
