|From:||Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>|
|To:||Stuart McGraw <smcg4191(at)mtneva(dot)com>|
|Subject:||Re: existence of a savepoint?|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
On 2018-May-29, Stuart McGraw wrote:
> Alternatively if there were a setting to tell Postgresql to
> follow the SQL standard behavior of overwriting rather stacking
> savepoints, that too would also solve my current problem I think.
> Perhaps it is just my limited experience but the former behavior
> has always seemed more useful in practice than the latter.
I think if what we're doing breaks the semantics of the SQL spec, we're
definitely open to changing our behavior. But that wouldn't solve your
problem today. What I think could solve your problem today is a
C-language extension that uses xact.c callbacks in order to expose a
list that you can query from user space.
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
|Next Message||Alvaro Herrera||2018-05-29 23:14:51||Re: found xmin from before relfrozenxid on pg_catalog.pg_authid|
|Previous Message||nageswara Bandla||2018-05-29 22:57:31||Re: Pgagent is not reading pgpass file either in Windows or Linux.|