Things affected globally in a postgresql transaction

by Luciano Andress Martini   Last Updated October 22, 2018 13:06 PM

I know that sequences are affected globally for all running transactions, but my doubt is there is a list with some other roles that are affected globally, if i set inside a transaction?

And please correct me if this the correct term: "affected globally" I mean, if I increase the sequence value, it will be increased for all other running transactions without the need of commit....

For example, if I set alter table mytable enable trigger all; this will affect the trigger behavior only in the local transaction or in other transactions, but this is only a example, i am thinking about a lot of other things that i am need to be carefully about it.

Tags : postgresql


Related Questions


Postgres gist slow index f_unaccent

Updated April 09, 2018 20:06 PM