Warning messages appearing twice

On Fri, Jul 26, 2019 at 11:04 AM vignesh C <vignesh21@gmail.com> wrote:

Hi,

I have noticed in some cases the warning messages appear twice, one such instance is given below:
postgres=# begin;
BEGIN
postgres=# prepare transaction 't1';
PREPARE TRANSACTION
postgres=# rollback;
WARNING: there is no transaction in progress
WARNING: there is no transaction in progress
ROLLBACK

However if logging is enabled, the warning message appears only once.

Seems like you are seeing one message from the client and the other
one from the server log as you have not enabled the logging collector
the WARNING is printed on your console.

I'm not sure if this is already known.
I'm not sure if this is widely used scenario or not.

--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

On Fri, Jul 26, 2019 at 11:23 AM Dilip Kumar <dilipbalaut@gmail.com> wrote:

On Fri, Jul 26, 2019 at 11:04 AM vignesh C <vignesh21@gmail.com> wrote:

Hi,

I have noticed in some cases the warning messages appear twice, one such

instance is given below:

postgres=# begin;
BEGIN
postgres=# prepare transaction 't1';
PREPARE TRANSACTION
postgres=# rollback;
WARNING: there is no transaction in progress
WARNING: there is no transaction in progress
ROLLBACK

However if logging is enabled, the warning message appears only once.

Seems like you are seeing one message from the client and the other
one from the server log as you have not enabled the logging collector
the WARNING is printed on your console.

Thanks for the clarification Dilip. <http://www.enterprisedb.com&gt;

Regards,
Vignesh
EnterpriseDB: http://www.enterprisedb.com