Re: How to find transaction ID
| От | Glyn Astill |
|---|---|
| Тема | Re: How to find transaction ID |
| Дата | |
| Msg-id | 1375971627.86078.YahooMailNeo@web133204.mail.ir2.yahoo.com обсуждение исходный текст |
| Ответ на | How to find transaction ID ("ascot.moss@gmail.com" <ascot.moss@gmail.com>) |
| Ответы |
Re: How to find transaction ID
|
| Список | pgsql-general |
> From: "ascot.moss@gmail.com" <ascot.moss@gmail.com> > To: PostgreSQL general <pgsql-general@postgresql.org> > Cc: ascot.moss@gmail.com > Sent: Thursday, 8 August 2013, 14:52 > Subject: [GENERAL] How to find transaction ID > > Hi, > > I am trying some restore tools, can you advise how to find the latest > transaction ID in PostgreSQL and the transaction ID at a particular > "Point-In-Time"? > Hmm, it's not clear entirely what you want. Afaik "select txid_current()" should get you the current transaction id. Thecolumn xmin for a row from any table will get you the inserting transaction id, and xmax will get you the deleting (orattempted delete) transaction id. See http://www.postgresql.org/docs/9.0/static/functions-info.html
В списке pgsql-general по дате отправления: