Re: [GENERAL] Do I need to COMMIT an analyze statement?

2017-03-31 Thread Thomas Kellerer 

David G. Johnston schrieb am 31.03.2017 um 16:49:

On Friday, March 31, 2017, Thomas Kellerer > wrote:

Hello,

something I have always wondered:

If I run with autocommit turned OFF, do I need to commit an ANALYZE statement, or is 
that "non-transactional"?


The results are stored in a catalog table so they are transactional.


Thanks.

That's what I assumed. Just wanted to be sure.

Thomas





--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Do I need to COMMIT an analyze statement?

2017-03-31 Thread David G. Johnston 
On Friday, March 31, 2017, Thomas Kellerer  wrote:

> Hello,
>
> something I have always wondered:
>
> If I run with autocommit turned OFF, do I need to commit an ANALYZE
> statement, or is that "non-transactional"?
>
>
The results are stored in a catalog table so they are transactional.

David J.

[GENERAL] Do I need to COMMIT an analyze statement?

2017-03-31 Thread Thomas Kellerer 
Hello,

something I have always wondered: 

If I run with autocommit turned OFF, do I need to commit an ANALYZE statement, 
or is that "non-transactional"?

Thomas



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general