Zen

Translation

`PostgreSQL Range Types <https://www.postgresql.org/docs/current/rangetypes.html>`_
83/830 · 83

Sign in to save the translation.

English Chinese (Simplified) Actions
Editing the Table
表数据编辑操作
Now that the history table is enabled, we can make edits on the main table and watch the log entries appear in the history table.
历史表启用后，对主表执行的所有编辑操作将自动生成日志条目并记录至历史表中。
Note the power of this database-backed approach to history: **no matter what tool is used to make the edits, whether the SQL command line, a web-based JDBC tool, or a desktop tool like QGIS, the history is consistently tracked.**
请注意这种基于数据库的历史记录机制的强大之处：**无论通过何种工具进行编辑（SQL命令行、基于Web的JDBC工具，还是QGIS等桌面工具），系统均能保持历史记录的一致性追踪。**
SQL Edits
SQL 数据编辑操作
Let's turn the two streets named "Cumberland Walk" to the more stylish "Cumberland Wynde":
将两条名为"Cumberland Walk"的街道更名为更优雅的"Cumberland Wynde"：
Updating the two streets will cause the original streets to be marked as deleted in the history table, with a deletion time of now, and two new streets with the new name added, with an addition time of now. You can inspect the historical records:
更新这两条街道将导致原始街道在历史表中被标记为已删除，并记录删除时间为当前时间，同时添加两条具有新名称的新街道，并记录添加时间为当前时间。你可以检查历史记录：
Querying the History Table
历史表查询方法
Now that we have a history table, what use is it? It's useful for time travel! To travel to a particular time **T**, you need to construct a query that includes:
历史表的核心价值在于实现"时间旅行"查询。要回溯特定时间点**T**的数据状态，需构建包含以下要素的查询：
All records created before T, and not yet deleted; and also
需包含所有在时间点T之前创建且尚未删除的记录
All records created before T, but deleted **after** T.
所有在时间点 T 之前创建，但在 T **之后**才被删除的记录。
We can use this logic to create a query, or a view, of the state of the data in the past. Since presumably all your test edits have happened in the past couple minutes, let's create a view of the history table that shows the state of the table 10 minutes ago, **before you started editing** (so, the original data).
我们可以利用这一逻辑创建历史数据查询或视图。假设您的测试编辑操作均在最近几分钟内完成，现在创建一个显示10分钟前（即编辑开始前的原始数据状态）的历史表视图。
We can also create views that show just what a particular used has added, for example:
我们还可以创建仅显示特定用户所添加数据的视图，例如：
See Also
另请参阅
`QGIS open source GIS <http://qgis.org>`_
`QGIS 开源地理信息系统 <http://qgis.org>`_
`PostgreSQL Triggers <http://www.postgresql.org/docs/current/static/plpgsql-trigger.html>`_
`PostgreSQL Triggers <http://www.postgresql.org/docs/current/static/plpgsql-trigger.html>`_
`PostgreSQL Range Types <https://www.postgresql.org/docs/current/rangetypes.html>`_
`PostgreSQL Range Types <https://www.postgresql.org/docs/current/rangetypes.html>`_

Loading…

User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
`PostgreSQL Range Types <https://www.postgresql.org/docs/current/rangetypes.html>`_
`PostgreSQL Range Types <https://www.postgresql.org/docs/current/rangetypes.html>`_
yesterday
User avatar None

String updated in the repository

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
`PostgreSQL Range Types <https://www.postgresql.org/docs/current/rangetypes.html>`_
 
2 years ago
Browse all string changes

Things to check

Unchanged translation

Source and translation are identical

Reset

Glossary

English Chinese (Simplified)
No related strings found in the glossary.

String information

Source string location
../../en/history_tracking.rst:235
String age
2 years ago
Last updated
a year ago
Source string age
3 years ago
Translation file
postgis-intro/sources/locale/zh_Hans/LC_MESSAGES/history_tracking.po, string 42