天天看點

PG10的函數比PG9.6變化不少

 ---如下是9.6的:

https://www.postgresql.org/docs/9.6/static/functions-admin.html

pg_current_xlog_flush_location()	pg_lsn	Get current transaction log flush location
pg_current_xlog_insert_location()	pg_lsn	Get current transaction log insert location
pg_current_xlog_location()	pg_lsn	Get current transaction log write location
           

---如下是10的: https://www.postgresql.org/docs/10/static/functions-admin.html

pg_current_wal_flush_lsn()	pg_lsn	Get current write-ahead log flush location
pg_current_wal_insert_lsn()	pg_lsn	Get current write-ahead log insert location
pg_current_wal_lsn()	pg_lsn	Get current write-ahead log write location 
           

可以看到,名字都不一樣了...

繼續閱讀