Postgres Pro
Downloads
Home   >   mailing lists

Thread: Regression tests (Background Workers)

Regression tests (Background Workers)

From
Dharini
Date:

Background process is initialized at server start and when trying to run the tests i get the following error.

$ make installcheck
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
ERROR:  DROP DATABASE cannot be executed from a function or multi-command string
command failed: "/postgres/install/bin/psql" -X -c "DROP DATABASE IF EXISTS \"contrib_regression\"" "postgres"
make: *** [installcheck] Error 2

Re: Regression tests (Background Workers)

From
Michael Paquier
Date:
On Tue, Jun 21, 2016 at 2:02 PM, Dharini <dharini1994@gmail.com> wrote:
> Background process is initialized at server start and when trying to run the
> tests i get the following error.
>
> $ make installcheck
> (using postmaster on Unix socket, default port)
> ============== dropping database "contrib_regression" ==============
> ERROR:  DROP DATABASE cannot be executed from a function or multi-command
> string
> command failed: "/postgres/install/bin/psql" -X -c "DROP DATABASE IF EXISTS
> \"contrib_regression\"" "postgres"
> make: *** [installcheck] Error 2

Which test are you trying to run? That's not from the in-core source
tree, right? And on which version of Postgres is this attempt tried?
With this level of details that's hard to know what's going on, one
can just guess that PreventTransactionChain is being called on DROP
DATABASE..
--
Michael