Re: Reporting the commit LSN at commit time - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Reporting the commit LSN at commit time
Date
Msg-id 20140819102139.GD5762@awork2.anarazel.de
Whole thread Raw
In response to Re: Reporting the commit LSN at commit time  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: Reporting the commit LSN at commit time
Re: Reporting the commit LSN at commit time
List pgsql-hackers
On 2014-08-19 08:21:10 +0800, Craig Ringer wrote:
> On 08/19/2014 01:03 AM, Robert Haas wrote:
> > 2. I agree that it's not good to have this get controlled by a GUC.
> > If the behavior change is big enough that it's going to break clients,
> > adding a GUC isn't a sufficient remedy.  If it's not, adding a GUC is
> > unnecessary.
> 
> There's plenty of agreement on "not a GUC" - but what about alternatives?

What's the problem with the COMMIT WITH (report_lsn on) I've proposed?
Reporting the LSN in the command tag? Anything doing transparent
failover needs to be aware of transaction boundaries anyway. 

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Reporting the commit LSN at commit time
Next
From: Fujii Masao
Date:
Subject: Re: After switching primary server while using replication slot.