Michael Fuhr wrote:

On Tue, Apr 11, 2006 at 12:54:12PM +0100, Ricardo Manuel Pereira Vilaça wrote:
How I can determine information about the last committed transaction in postgresql?

What information are you looking for?  What are you trying to do?

When a server restarts, and possible recovery, how can I know the id of
the last commited transaction?
I need that information for synchronization with  other  servers.
Can I add some application specific information to postgresql write
ahead log?

Thanks,

Ricardo Vilaça



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to