package com.vladmihalcea.book.hpjp.util.providers.queries;

/**
 * @author Vlad Mihalcea
 */
public class PostgreSQLQueries implements Queries {

    public static final Queries INSTANCE = new PostgreSQLQueries();

    @Override
    public String transactionId() {
        return "SELECT CAST(txid_current() AS text)";
    }
}

@@ -290,20 +290,18 @@
 AST(
-txid
+pg
 _current
 () A
@@ -296,16 +296,36 @@
 _current
+_xact_id_if_assigned
 () AS te

Update PostgreSQL transaction id query