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 20140815085450.GD28805@awork2.anarazel.de
Whole thread Raw
In response to Re: Reporting the commit LSN at commit time  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Reporting the commit LSN at commit time
List pgsql-hackers
On 2014-08-14 12:21:38 -0400, Robert Haas wrote:
> On Sat, Aug 9, 2014 at 12:54 PM, Andres Freund <andres@2ndquadrant.com> wrote:
> > I don't think we really need to embed it at that level. And it doesn't
> > have to be always on - only clients that ask for it need to get the
> > answer. Something like COMMIT WITH (report_commit_lsn ON); or similar
> > might do the trick?
> 
> And what does that actually do?  Send back a result-set, or a new
> protocol message?

What I was thinking of was to return "COMMIT X/X" instead of
"COMMIT". Since that's only sent when COMMIT WITH (report_commit_lsn ON)
was set it won't break clients/libraries that don't need it.

Greetings,

Andres Freund

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



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pg_shmem_allocations view
Next
From: Marko Tiikkaja
Date:
Subject: Re: pgcrypto: PGP armor headers