Christopher B. Browne's Home Page
cbbrowne@acm.org

Chapter 8. Schema schemadoc

Table of Contents
8.1. Table: sl_archive_counter
8.2. Table: sl_config_lock
8.3. Table: sl_confirm
8.4. Table: sl_event
8.5. Table: sl_listen
8.6. Table: sl_log_1
8.7. Table: sl_log_2
8.8. Table: sl_node
8.9. Table: sl_nodelock
8.10. Table: sl_path
8.11. Table: sl_registry
8.12. View: sl_seqlastvalue
8.13. Table: sl_seqlog
8.14. Table: sl_sequence
8.15. Table: sl_set
8.16. Table: sl_setsync
8.17. Table: sl_subscribe
8.18. Table: sl_table
8.19. add_empty_table_to_replication(integer, integer, text, text, text, text)
8.20. add_missing_table_field(text, text, text, text)
8.21. addpartiallogindices()
8.22. altertableaddtriggers(integer)
8.23. altertableconfiguretriggers(integer)
8.24. altertabledroptriggers(integer)
8.25. checkmoduleversion()
8.26. cleanupevent(p_interval interval)
8.27. cleanupnodelock()
8.28. clonenodefinish(integer, integer)
8.29. clonenodeprepare(integer, integer, text)
8.30. clonenodeprepare_int(integer, integer, text)
8.31. copyfields(integer)
8.32. createevent(name, text)
8.33. createevent(name, text, text)
8.34. createevent(name, text, text, text)
8.35. createevent(name, text, text, text, text)
8.36. createevent(name, text, text, text, text, text)
8.37. createevent(name, text, text, text, text, text, text)
8.38. createevent(name, text, text, text, text, text, text, text)
8.39. createevent(name, text, text, text, text, text, text, text, text)
8.40. createevent(name, text, text, text, text, text, text, text, text, text)
8.41. ddlscript_complete(integer, text, integer)
8.42. ddlscript_complete_int(integer, integer)
8.43. ddlscript_prepare(integer, integer)
8.44. ddlscript_prepare_int(integer, integer)
8.45. denyaccess()
8.46. determineattkindunique(text, name)
8.47. determineidxnameunique(text, name)
8.48. disable_indexes_on_table(i_oid oid)
8.49. disablenode(integer)
8.50. disablenode_int(integer)
8.51. droplisten(integer, integer, integer)
8.52. droplisten_int(integer, integer, integer)
8.53. dropnode(integer)
8.54. dropnode_int(integer)
8.55. droppath(integer, integer)
8.56. droppath_int(integer, integer)
8.57. dropset(integer)
8.58. dropset_int(integer)
8.59. enable_indexes_on_table(i_oid oid)
8.60. enablenode(integer)
8.61. enablenode_int(integer)
8.62. enablesubscription(integer, integer, integer)
8.63. enablesubscription_int(integer, integer, integer)
8.64. failednode(integer, integer)
8.65. failednode2(integer, integer, integer, bigint, bigint)
8.66. failoverset_int(integer, integer, integer, bigint)
8.67. finishtableaftercopy(integer)
8.68. forwardconfirm(integer, integer, bigint, timestamp without time zone)
8.69. generate_sync_event(interval)
8.70. getlocalnodeid(name)
8.71. getmoduleversion()
8.72. initializelocalnode(integer, text)
8.73. killbackend(integer, text)
8.74. lockedset()
8.75. lockset(integer)
8.76. logswitch_finish()
8.77. logswitch_start()
8.78. logtrigger()
8.79. mergeset(integer, integer)
8.80. mergeset_int(integer, integer)
8.81. moveset(integer, integer)
8.82. moveset_int(integer, integer, integer, bigint)
8.83. preparetableforcopy(integer)
8.84. rebuildlistenentries()
8.85. registernodeconnection(integer)
8.86. registry_get_int4(text, integer)
8.87. registry_get_text(text, text)
8.88. registry_get_timestamp(text, timestamp without time zone)
8.89. registry_set_int4(text, integer)
8.90. registry_set_text(text, text)
8.91. registry_set_timestamp(text, timestamp without time zone)
8.92. replicate_partition(integer, text, text, text, text)
8.93. seqtrack(integer, bigint)
8.94. sequencelastvalue(text)
8.95. sequencesetvalue(integer, integer, bigint, bigint)
8.96. setaddsequence(integer, integer, text, text)
8.97. setaddsequence_int(integer, integer, text, text)
8.98. setaddtable(integer, integer, text, name, text)
8.99. setaddtable_int(integer, integer, text, name, text)
8.100. setdropsequence(integer)
8.101. setdropsequence_int(integer)
8.102. setdroptable(integer)
8.103. setdroptable_int(integer)
8.104. setmovesequence(integer, integer)
8.105. setmovesequence_int(integer, integer)
8.106. setmovetable(integer, integer)
8.107. setmovetable_int(integer, integer)
8.108. slon_quote_brute(text)
8.109. slon_quote_input(text)
8.110. slonyversion()
8.111. slonyversionmajor()
8.112. slonyversionminor()
8.113. slonyversionpatchlevel()
8.114. storelisten(integer, integer, integer)
8.115. storelisten_int(integer, integer, integer)
8.116. storenode(integer, text)
8.117. storenode_int(integer, text)
8.118. storepath(integer, integer, text, integer)
8.119. storepath_int(integer, integer, text, integer)
8.120. storeset(integer, text)
8.121. storeset_int(integer, integer, text)
8.122. subscribeset(integer, integer, integer, boolean, boolean)
8.123. subscribeset_int(integer, integer, integer, boolean, boolean)
8.124. tablestovacuum()
8.125. terminatenodeconnections(integer)
8.126. uninstallnode()
8.127. unlockset(integer)
8.128. unsubscribeset(integer, integer)
8.129. unsubscribeset_int(integer, integer)
8.130. updaterelname(integer, integer)
8.131. updatereloid(integer, integer)
8.132. upgradeschema(text)

8.1. Table: sl_archive_counter

Table used to generate the log shipping archive number.

Structure of sl_archive_counter

ac_num

bigint

Counter of SYNC ID used in log shipping as the archive number

ac_timestamp

timestamp without time zone

Time at which the archive log was generated on the subscriber

Google

If this was useful, let others know by an Affero rating

Contact me at cbbrowne@acm.org