Pg9.3
From PostgreSQL wiki
Jump to navigationJump to search总体目标
翻译平台搭建完毕, 网址: http://58.58.25.191:8079/doc/doc/doc_center.php 请大家注册登录使用。
翻译的基本流程及框架
- 本次翻译9.3的基线为:8.2.3中文文档
- 翻译流程
1.对比需要翻译的sgml文件 2.指定翻译到翻译人员 3.翻译好后上传提交 4.审核人员审核 5.锁定翻译成果 6.发布
- 9.3翻译的主要内容
1.新增页面的全文翻译 2.内容有差异页面的修改 3.内容相同页面的整理
- 9.3与8.2.3 HTML差异对比详情
http://bbs.pgsqldb.com/doc/load_html.php?path_old=./doc/8.2.3&path_new=./doc/9.3
翻译的详细流程
作成中
sgml的翻译规范
为了方便校验和以后的维护,翻译sgml时需遵循下面的规范。
- 内容相关的约定
1)8.2.3已经翻过的内容,直接使用8.2.3中文版上的。(注) 2)8.2.3之后修改或新增部分的翻译在风格和专业术语上和8.2.3保持一致。 3)8.2.3中未出现的专业术语,查一下"新增术语表"。如果也没有自己在wiki上添加一下,对有争议的术语翻译可在群里讨论。
注)如果发现原来8.2.3中文版上有问题的地方可以纠正
- 格式相关的约定
1)翻译后的sgml文件的编码统一使用GB码(GBK,GB2312或gb18030)。 2)通过注释保留原始的英文,方便校验。 注释时在原始英文前后另起新行加注视标记("<!--"和"-->"),这样方便和原始文档比对。 3)需要翻译的部分(比如<para>,详见"需要翻译的sgml tag")中内嵌的tag(比如"<productname>PostgreSQL</>")都要保留。 4)不需要翻译的部分尽量不要动,比如重新格式化(加些空行空格,对齐等)。 5)翻译后的大段中文的换行 对于比较长的段落,为了方便源文件的阅读,可以在段落中间适当增加换行。但是转换成html后, 换行会和其他相邻的空白符一起表现为一个空格。因此为了尽量不影响html的显示效果, 换行的位置应放已有的空白符位置或标点符号的后面。
- 例子
翻译前:
<title>Server Administration</title> <para> This part covers topics that are of interest to a <productname>PostgreSQL</> database administrator. This includes installation of the software, set up and configuration of the server, management of users and databases, and maintenance tasks. Anyone who runs a <productname>PostgreSQL</> server, even for personal use, but especially in production, should be familiar with the topics covered in this part. </para>
翻译后:
<!-- <title>Server Administration</title> --> <title>服务器管理</title> <partintro> <!-- <para> This part covers topics that are of interest to a <productname>PostgreSQL</> database administrator. This includes installation of the software, set up and configuration of the server, management of users and databases, and maintenance tasks. Anyone who runs a <productname>PostgreSQL</> server, even for personal use, but especially in production, should be familiar with the topics covered in this part. </para> --> <para> 这部分覆盖的内容是那些 <productname>PostgreSQL</> 数据库管理员感兴趣的东西。 包括安装软件、设置和配置服务器、管理用户和数据库、日常维护任务。任何运行 <productname>PostgreSQL</> 服务器的人,尤其是生产环境中的使用者, 都应该熟悉这部分中讨论的内容。 </para>
- 需要翻译的sgml tag(需不断更新)
tag | 说明 | 备注 |
---|---|---|
title | 标题 | |
para | 段落 |
- 新增术语表(需不断更新)
英文术语 | 中文术语 | 备注 |
---|---|---|
foreign table | 外部表 | |
当前翻译任务
- 当前任务:9.3较8.2.3新增的sgml
- 翻译状态:空白(表示无人翻译),翻译中,已提交,审核中,完成。
- sgml文件下载:sgml9.3
编号 | 文件名 | 标题 | 和8.2.3比较结果 | 总行数 | 比8.2.3修改行数 | 翻译者 | 状态 | 开始时间 | 结束时间 |
---|---|---|---|---|---|---|---|---|---|
1 | postgres.sgml | PostgreSQL 9.3.1 Documentation | ≠ | 274 | 23 | 陈华军 | 翻译中 | 2013.11.07 | |
2 | legal.sgml | Legal Notice | ≠ | 48 | 7 | 陈华军 | 翻译中 | 2013.11.07 | |
Preface | |||||||||
3 | intro.sgml | Preface | ≠ | 161 | 7 | 瀚高-韩悦悦 | 已提交 | 2013.11.08 | 2013.11.12 |
4 | history.sgml | A Brief History of PostgreSQL | ≠ | 222 | 16 | 瀚高-韩悦悦 | 已提交 | 2013.11.08 | 2013.11.13 |
5 | notation.sgml | Conventions | ≠ | 31 | 1 | 瀚高-韩悦悦 | 已提交 | 2013.11.08 | 2013.11.15 |
6 | info.sgml | Further Information | ≠ | 69 | 9 | 瀚高-韩志平 | 翻译中 | 2013.11.08 | |
7 | problems.sgml | Bug Reporting Guidelines | ≠ | 366 | 15 | 瀚高-韩志平 | 翻译中 | 2013.11.08 | |
I. Tutorial | |||||||||
8 | start.sgml | 1. Getting Started | ≠ | 411 | 32 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
9 | query.sgml | 2. The SQL Language | ≠ | 880 | 42 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
10 | advanced.sgml | 3. Advanced Features | ≠ | 717 | 261 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
II. The SQL Language | |||||||||
11 | syntax.sgml | 4. SQL Syntax | ≠ | 2508 | 921 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
12 | ddl.sgml | 5. Data Definition | ≠ | 3201 | 560 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
13 | dml.sgml | 6. Data Manipulation | ≠ | 255 | 28 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
14 | queries.sgml | 7. Queries | ≠ | 2094 | 794 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
15 | datatype.sgml | 8. Data Types | ≠ | 4666 | 1749 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
16 | array.sgml | 8.15.Arrays | ≠ | 723 | 163 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
17 | rowtypes.sgml | 8.16.Composite Types | ≠ | 330 | 26 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
18 | rangetypes.sgml | 8.17.Range Types | 新 | 508 | 508 | 沈阳-motes | 翻译中 | 2013.11.08 | |
19 | func.sgml | 9. Functions and Operators | ≠ | 16370 | 7579 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
20 | typeconv.sgml | 10. Type Conversion | ≠ | 1004 | 226 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
21 | indices.sgml | 11. Indexes | ≠ | 1198 | 330 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
22 | textsearch.sgml | 12. Full Text Search | 新 | 3668 | 3668 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
23 | mvcc.sgml | 13. Concurrency Control | ≠ | 1558 | 726 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
24 | perform.sgml | 14. Performance Tips | ≠ | 1576 | 900 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
III. Server Administration | |||||||||
25 | installation.sgml | 15. Installation from Source Code | ≠ | 2973 | 1620 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
26 | install-windows.sgml | 16. Installation from Source Code on Windows | 新 | 611 | 611 | 上海-北极之北 | 翻译中 | 2013.11.08 | |
27 | runtime.sgml | 17. Server Setup and Operation | ≠ | 2290 | 1083 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
28 | config.sgml | 18. Server Configuration | ≠ | 6798 | 3206 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
29 | client-auth.sgml | 19. Client Authentication | ≠ | 1804 | 1049 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
30 | user-manag.sgml | 20. Database Roles | ≠ | 442 | 61 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
31 | manage-ag.sgml | 21. Managing Databases | ≠ | 510 | 179 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
32 | charset.sgml | 22. Localization | ≠ | 1540 | 472 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
33 | maintenance.sgml | 23. Routine Database Maintenance Tasks | ≠ | 883 | 431 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
34 | backup.sgml | 24. Backup and Restore | ≠ | 1426 | 603 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
35 | high-availability.sgml | 25. High Availability, Load Balancing, and Replication | ≠ | 2197 | 2071 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
36 | recovery-config.sgml | 26. Recovery Configuration | 新 | 361 | 361 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
37 | monitoring.sgml | 27. Monitoring Database Activity | ≠ | 2539 | 1988 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
38 | diskusage.sgml | 28. Monitoring Disk Usage | ≠ | 144 | 38 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
39 | wal.sgml | 29. Reliability and the Write-Ahead Log | ≠ | 766 | 509 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
40 | regress.sgml | 30. Regression Tests | ≠ | 605 | 246 | ||||
IV. Client Interfaces | |||||||||
41 | libpq.sgml | 31. libpq - C Library | ≠ | 8240 | 7311 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
42 | lobj.sgml | 32. Large Objects | ≠ | 853 | 304 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
43 | ecpg.sgml | 33. ECPG - Embedded SQL in C | ≠ | 9678 | 8372 | ||||
44 | information_schema.sgml | 34. The Information Schema | ≠ | 6612 | 2751 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
V. Server Programming | |||||||||
45 | extend.sgml | 35. Extending SQL | ≠ | 1206 | 978 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
46 | xfunc.sgml | 35.3. User-defined Functions | ≠ | 3388 | 882 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
47 | dfunc.sgml | 35.9.6. Compiling and Linking Dynamically-loaded Functions | ≠ | 299 | 11 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
48 | xaggr.sgml | 35.10. User-defined Aggregates | ≠ | 196 | 39 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
49 | xtypes.sgml | 35.11. User-defined Types | ≠ | 294 | 70 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
50 | xoper.sgml | 35.12. User-defined Operators | ≠ | 466 | 79 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
51 | xindex.sgml | 35.14. Interfacing Extensions To Indexes | ≠ | 1177 | 461 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
52 | trigger.sgml | 36. Triggers | ≠ | 842 | 199 | yunling,瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
53 | event-trigger.sgml | 37. Event Triggers | 新 | 822 | 822 | yunling,瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
54 | rules.sgml | 38. The Rule System | ≠ | 2438 | 501 | yunling,瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
55 | xplang.sgml | 39. Procedural Languages | ≠ | 239 | 71 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
56 | plpgsql.sgml | 40. PL/pgSQL - SQL Procedural Language | ≠ | 5384 | 2444 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
57 | pltcl.sgml | 41. PL/Tcl - Tcl Procedural Language | ≠ | 778 | 79 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
58 | plperl.sgml | 42. PL/Perl - Perl Procedural Language | ≠ | 1389 | 637 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
59 | plpython.sgml | 43. PL/Python - Python Procedural Language | ≠ | 1440 | 1043 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
60 | spi.sgml | 44. Server Programming Interface | ≠ | 4260 | 1369 | ||||
61 | bgworker.sgml | 45. Background Worker Processes | 新 | 138 | 138 | ||||
VI. Reference | |||||||||
62 | reference.sgml | VI. Reference | ≠ | 262 | 62 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
VI. Reference -> I. SQL Commands | |||||||||
63 | ref/abort.sgml | ≠ | 100 | 10 | |||||
64 | ref/alter_aggregate.sgml | ≠ | 148 | 14 | |||||
65 | ref/alter_collation.sgml | 新 | 127 | 127 | |||||
66 | ref/alter_conversion.sgml | ≠ | 127 | 24 | |||||
67 | ref/alter_database.sgml | ≠ | 215 | 77 | |||||
68 | ref/alter_default_privileges.sgml | 新 | 221 | 221 | |||||
69 | ref/alter_domain.sgml | ≠ | 347 | 128 | |||||
70 | ref/alter_extension.sgml | 新 | 314 | 314 | |||||
71 | ref/alter_event_trigger.sgml | 新 | 105 | 105 | |||||
72 | ref/alter_foreign_data_wrapper.sgml | 新 | 186 | 186 | |||||
73 | ref/alter_foreign_table.sgml | 新 | 371 | 371 | 山东王瑜 | 翻译中 | 2013.11.12 | ||
74 | ref/alter_function.sgml | ≠ | 330 | 103 | |||||
75 | ref/alter_group.sgml | ≠ | 128 | 18 | |||||
76 | ref/alter_index.sgml | ≠ | 225 | 31 | |||||
77 | ref/alter_language.sgml | ≠ | 91 | 21 | |||||
78 | ref/alter_large_object.sgml | 新 | 80 | 80 | |||||
79 | ref/alter_materialized_view.sgml | 新 | 167 | 167 | |||||
80 | ref/alter_operator.sgml | ≠ | 128 | 25 | |||||
81 | ref/alter_opclass.sgml | ≠ | 119 | 24 | |||||
82 | ref/alter_opfamily.sgml | 新 | 351 | 351 | |||||
83 | ref/alter_role.sgml | ≠ | 326 | 106 | |||||
84 | ref/alter_rule.sgml | 新 | 105 | 105 | |||||
85 | ref/alter_schema.sgml | ≠ | 100 | 10 | |||||
86 | ref/alter_sequence.sgml | ≠ | 319 | 109 | |||||
87 | ref/alter_server.sgml | 新 | 144 | 144 | |||||
88 | ref/alter_table.sgml | ≠ | 1116 | 380 | |||||
89 | ref/alter_tablespace.sgml | ≠ | 134 | 35 | |||||
90 | ref/alter_tsconfig.sgml | 新 | 189 | 189 | |||||
91 | ref/alter_tsdictionary.sgml | 新 | 170 | 170 | |||||
92 | ref/alter_tsparser.sgml | 新 | 93 | 93 | |||||
93 | ref/alter_tstemplate.sgml | 新 | 93 | 93 | |||||
94 | ref/alter_trigger.sgml | ≠ | 114 | 9 | |||||
95 | ref/alter_type.sgml | ≠ | 344 | 246 | |||||
96 | ref/alter_user.sgml | ≠ | 74 | 13 | |||||
97 | ref/alter_user_mapping.sgml | 新 | 124 | 124 | |||||
98 | ref/alter_view.sgml | 新 | 188 | 188 | |||||
99 | ref/analyze.sgml | ≠ | 227 | 80 | |||||
100 | ref/begin.sgml | ≠ | 161 | 34 | |||||
101 | ref/checkpoint.sgml | ≠ | 64 | 20 | |||||
102 | ref/close.sgml | ≠ | 132 | 37 | |||||
103 | ref/cluster.sgml | ≠ | 227 | 82 | |||||
104 | ref/comment.sgml | ≠ | 313 | 85 | |||||
105 | ref/commit.sgml | ≠ | 96 | 10 | |||||
106 | ref/commit_prepared.sgml | ≠ | 107 | 20 | |||||
107 | ref/copy.sgml | ≠ | 975 | 292 | |||||
108 | ref/create_aggregate.sgml | ≠ | 318 | 22 | |||||
109 | ref/create_cast.sgml | ≠ | 430 | 179 | |||||
110 | ref/create_collation.sgml | 新 | 177 | 177 | |||||
111 | ref/create_conversion.sgml | ≠ | 170 | 18 | |||||
112 | ref/create_database.sgml | ≠ | 289 | 77 | |||||
113 | ref/create_domain.sgml | ≠ | 230 | 37 | |||||
114 | ref/create_extension.sgml | 新 | 210 | 210 | |||||
115 | ref/create_event_trigger.sgml | 新 | 162 | 162 | |||||
116 | ref/create_foreign_data_wrapper.sgml | 新 | 183 | 183 | |||||
117 | ref/create_foreign_table.sgml | 新 | 237 | 237 | |||||
118 | ref/create_function.sgml | ≠ | 782 | 356 | |||||
119 | ref/create_group.sgml | ≠ | 70 | 17 | |||||
120 | ref/create_index.sgml | ≠ | 650 | 237 | |||||
121 | ref/create_language.sgml | ≠ | 332 | 102 | |||||
122 | ref/create_materialized_view.sgml | 新 | 151 | 151 | |||||
123 | ref/create_operator.sgml | ≠ | 296 | 52 | |||||
124 | ref/create_opclass.sgml | ≠ | 325 | 82 | |||||
125 | ref/create_opfamily.sgml | 新 | 118 | 118 | |||||
126 | ref/create_role.sgml | ≠ | 484 | 58 | |||||
127 | ref/create_rule.sgml | ≠ | 297 | 44 | |||||
128 | ref/create_schema.sgml | ≠ | 221 | 48 | |||||
129 | ref/create_sequence.sgml | ≠ | 362 | 29 | |||||
130 | ref/create_server.sgml | 新 | 155 | 155 | |||||
131 | ref/create_table.sgml | ≠ | 1463 | 517 | |||||
132 | ref/create_table_as.sgml | ≠ | 352 | 71 | |||||
133 | ref/create_tablespace.sgml | ≠ | 145 | 16 | |||||
134 | ref/create_tsconfig.sgml | 新 | 126 | 126 | |||||
135 | ref/create_tsdictionary.sgml | 新 | 141 | 141 | |||||
136 | ref/create_tsparser.sgml | 新 | 153 | 153 | |||||
137 | ref/create_tstemplate.sgml | 新 | 126 | 126 | |||||
138 | ref/create_trigger.sgml | ≠ | 575 | 349 | |||||
139 | ref/create_type.sgml | ≠ | 948 | 404 | |||||
140 | ref/create_user.sgml | ≠ | 78 | 17 | |||||
141 | ref/create_user_mapping.sgml | 新 | 120 | 120 | |||||
142 | ref/create_view.sgml | ≠ | 386 | 187 | |||||
143 | ref/deallocate.sgml | ≠ | 98 | 16 | |||||
144 | ref/declare.sgml | ≠ | 349 | 136 | |||||
145 | ref/delete.sgml | ≠ | 282 | 65 | |||||
146 | ref/discard.sgml | 新 | 108 | 108 | |||||
147 | ref/do.sgml | 新 | 128 | 128 | |||||
148 | ref/drop_aggregate.sgml | ≠ | 123 | 9 | |||||
149 | ref/drop_cast.sgml | ≠ | 114 | 11 | |||||
150 | ref/drop_collation.sgml | 新 | 109 | 109 | |||||
151 | ref/drop_conversion.sgml | ≠ | 104 | 13 | |||||
152 | ref/drop_database.sgml | ≠ | 101 | 8 | |||||
153 | ref/drop_domain.sgml | ≠ | 112 | 12 | |||||
154 | ref/drop_extension.sgml | 新 | 121 | 121 | |||||
155 | ref/drop_event_trigger.sgml | 新 | 113 | 113 | |||||
156 | ref/drop_foreign_data_wrapper.sgml | 新 | 112 | 112 | |||||
157 | ref/drop_foreign_table.sgml | 新 | 111 | 111 | |||||
158 | ref/drop_function.sgml | ≠ | 157 | 15 | |||||
159 | ref/drop_group.sgml | ≠ | 53 | 5 | |||||
160 | ref/drop_index.sgml | ≠ | 133 | 29 | |||||
161 | ref/drop_language.sgml | ≠ | 125 | 23 | |||||
162 | ref/drop_materialized_view.sgml | 新 | 114 | 114 | |||||
163 | ref/drop_operator.sgml | ≠ | 146 | 13 | |||||
164 | ref/drop_opclass.sgml | ≠ | 147 | 31 | |||||
165 | ref/drop_opfamily.sgml | 新 | 136 | 136 | |||||
166 | ref/drop_owned.sgml | ≠ | 119 | 14 | |||||
167 | ref/drop_role.sgml | ≠ | 122 | 13 | |||||
168 | ref/drop_rule.sgml | ≠ | 121 | 13 | |||||
169 | ref/drop_schema.sgml | ≠ | 120 | 12 | |||||
170 | ref/drop_sequence.sgml | ≠ | 113 | 14 | |||||
171 | ref/drop_server.sgml | 新 | 112 | 112 | |||||
172 | ref/drop_table.sgml | ≠ | 127 | 17 | |||||
173 | ref/drop_tablespace.sgml | ≠ | 110 | 14 | |||||
174 | ref/drop_tsconfig.sgml | 新 | 119 | 119 | |||||
175 | ref/drop_tsdictionary.sgml | 新 | 118 | 118 | |||||
176 | ref/drop_tsparser.sgml | 新 | 116 | 116 | |||||
177 | ref/drop_tstemplate.sgml | 新 | 117 | 117 | |||||
178 | ref/drop_trigger.sgml | ≠ | 125 | 13 | |||||
179 | ref/drop_type.sgml | ≠ | 114 | 11 | |||||
180 | ref/drop_user.sgml | ≠ | 55 | 5 | |||||
181 | ref/drop_user_mapping.sgml | 新 | 110 | 110 | |||||
182 | ref/drop_view.sgml | ≠ | 112 | 12 | |||||
183 | ref/end.sgml | ≠ | 100 | 13 | |||||
184 | ref/execute.sgml | ≠ | 122 | 8 | |||||
185 | ref/explain.sgml | ≠ | 436 | 220 | |||||
186 | ref/fetch.sgml | ≠ | 418 | 28 | |||||
187 | ref/grant.sgml | ≠ | 672 | 256 | |||||
188 | ref/insert.sgml | ≠ | 337 | 59 | |||||
189 | ref/listen.sgml | ≠ | 136 | 32 | |||||
190 | ref/load.sgml | ≠ | 79 | 14 | |||||
191 | ref/lock.sgml | ≠ | 248 | 32 | |||||
192 | ref/move.sgml | ≠ | 124 | 28 | |||||
193 | ref/notify.sgml | ≠ | 228 | 99 | |||||
194 | ref/prepare.sgml | ≠ | 229 | 56 | |||||
195 | ref/prepare_transaction.sgml | ≠ | 180 | 60 | |||||
196 | ref/reassign_owned.sgml | ≠ | 117 | 20 | |||||
197 | ref/refresh_materialized_view.sgml | 新 | 112 | 112 | |||||
198 | ref/reindex.sgml | ≠ | 275 | 20 | |||||
199 | ref/release_savepoint.sgml | ≠ | 130 | 13 | |||||
200 | ref/reset.sgml | ≠ | 113 | 28 | |||||
201 | ref/revoke.sgml | ≠ | 301 | 89 | |||||
202 | ref/rollback.sgml | ≠ | 96 | 8 | |||||
203 | ref/rollback_prepared.sgml | ≠ | 107 | 20 | |||||
204 | ref/rollback_to.sgml | ≠ | 158 | 20 | |||||
205 | ref/savepoint.sgml | ≠ | 137 | 18 | |||||
206 | ref/security_label.sgml | 新 | 219 | 219 | |||||
207 | ref/select.sgml | ≠ | 1853 | 949 | |||||
208 | ref/select_into.sgml | ≠ | 154 | 33 | |||||
209 | ref/set.sgml | ≠ | 322 | 66 | |||||
210 | ref/set_constraints.sgml | ≠ | 123 | 36 | |||||
211 | ref/set_role.sgml | ≠ | 148 | 22 | |||||
212 | ref/set_session_auth.sgml | ≠ | 126 | 22 | |||||
213 | ref/set_transaction.sgml | ≠ | 273 | 123 | |||||
214 | ref/show.sgml | ≠ | 200 | 25 | |||||
215 | ref/start_transaction.sgml | ≠ | 97 | 23 | |||||
216 | ref/truncate.sgml | ≠ | 228 | 119 | |||||
217 | ref/unlisten.sgml | ≠ | 133 | 19 | |||||
218 | ref/update.sgml | ≠ | 385 | 76 | |||||
219 | ref/vacuum.sgml | ≠ | 277 | 64 | |||||
220 | ref/values.sgml | ≠ | 247 | 20 | |||||
VI. Reference -> II. PostgreSQL Client Applications | |||||||||
221 | ref/clusterdb.sgml | ≠ | 332 | 128 | |||||
222 | ref/createdb.sgml | ≠ | 384 | 123 | |||||
223 | ref/createlang.sgml | ≠ | 291 | 99 | |||||
224 | ref/createuser.sgml | ≠ | 489 | 168 | |||||
225 | ref/dropdb.sgml | ≠ | 291 | 94 | |||||
226 | ref/droplang.sgml | ≠ | 288 | 102 | |||||
227 | ref/dropuser.sgml | ≠ | 283 | 83 | |||||
228 | ref/ecpg-ref.sgml | ≠ | 259 | 45 | |||||
229 | ref/pg_basebackup.sgml | 新 | 571 | 571 | |||||
230 | ref/pg_config-ref.sgml | ≠ | 344 | 41 | |||||
231 | ref/pg_dump.sgml | ≠ | 1242 | 515 | |||||
232 | ref/pg_dumpall.sgml | ≠ | 623 | 264 | |||||
233 | ref/pg_isready.sgml | 新 | 213 | 213 | |||||
234 | ref/pg_receivexlog.sgml | 新 | 312 | 312 | |||||
235 | ref/pg_restore.sgml | ≠ | 878 | 293 | |||||
236 | ref/psql-ref.sgml | ≠ | 3751 | 1402 | |||||
237 | ref/reindexdb.sgml | ≠ | 375 | 153 | |||||
238 | ref/vacuumdb.sgml | ≠ | 402 | 136 | |||||
VI. Reference -> III. PostgreSQL Server Applications | |||||||||
239 | ref/initdb.sgml | ≠ | 444 | 194 | |||||
240 | ref/pg_controldata.sgml | ≠ | 67 | 13 | |||||
241 | ref/pg_ctl-ref.sgml | ≠ | 627 | 287 | |||||
242 | ref/pg_resetxlog.sgml | ≠ | 208 | 72 | |||||
243 | ref/postgres-ref.sgml | ≠ | 863 | 119 | |||||
244 | ref/postmaster.sgml | ≠ | 44 | 2 | |||||
VII. Internals | |||||||||
245 | arch-dev.sgml | 46. Overview of PostgreSQL Internals | ≠ | 555 | 69 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
246 | catalogs.sgml | 47. System Catalogs | ≠ | 9261 | 4687 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
247 | protocol.sgml | 48. Frontend/Backend Protocol | ≠ | 5001 | 1046 | ||||
248 | sources.sgml | 49. PostgreSQL Coding Conventions | ≠ | 838 | 234 | ||||
249 | nls.sgml | 50. Native Language Support | ≠ | 539 | 70 | ||||
250 | plhandler.sgml | 51. Writing A Procedural Language Handler | ≠ | 242 | 86 | ||||
251 | fdwhandler.sgml | 52. Writing A Foreign Data Wrapper | 新 | 955 | 955 | ||||
252 | geqo.sgml | 53. Genetic Query Optimizer | ≠ | 360 | 63 | ||||
253 | indexam.sgml | 54. Index Access Method Interface Definition | ≠ | 1141 | 386 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
254 | gist.sgml | 55. GiST Indexes | ≠ | 762 | 571 | ||||
255 | spgist.sgml | 56. SP-GiST Indexes | 新 | 751 | 751 | ||||
256 | gin.sgml | 57. GIN Indexes | ≠ | 527 | 357 | ||||
257 | storage.sgml | 58. Database Physical Storage | ≠ | 886 | 289 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
258 | bki.sgml | 59. BKI Backend Interface | ≠ | 357 | 15 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
259 | planstats.sgml | 60. How the Planner Uses Statistics | ≠ | 451 | 279 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
VIII. Appendixes | |||||||||
260 | errcodes.sgml | A. PostgreSQL Error Codes | ≠ | 89 | 21 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
261 | datetime.sgml | B. Date/Time Support | ≠ | 594 | 76 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
262 | keywords.sgml | C. SQL Key Words | ≠ | 5327 | 1269 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
263 | features.sgml | D. SQL Conformance | ≠ | 158 | 34 | ||||
264 | release.sgml | E. Release Notes | ≠ | 91 | 59 | ||||
265 | release-9.3.sgml | release-9.3 | 新 | 2268 | 2268 | 姥姥 | 翻译中 | 2013.11.08 | |
266 | release-9.2.sgml | release-9.2 | 新 | 5128 | 5128 | ||||
267 | release-9.1.sgml | release-9.1 | 新 | 6906 | 6906 | ||||
268 | release-9.0.sgml | release-9.0 | 新 | 8012 | 8012 | ||||
269 | release-8.4.sgml | release-8.4 | 新 | 8978 | 8978 | ||||
270 | release-8.3.sgml | release-8.3 | 新 | 8549 | 8549 | ||||
271 | release-8.2.sgml | release-8.2 | 新 | 7077 | 7077 | ||||
272 | release-8.1.sgml | release-8.1 | 新 | 5444 | 5444 | ||||
273 | release-8.0.sgml | release-8.0 | 新 | 5421 | 5421 | ||||
274 | release-7.4.sgml | release-7.4 | 新 | 4622 | 4622 | ||||
275 | release-old.sgml | release-old | 新 | 6657 | 6657 | ||||
276 | contrib.sgml | F. Additional Supplied Modules | 新 | 212 | 212 | ||||
277 | adminpack.sgml | F.1. adminpack | 新 | 40 | 40 | ||||
278 | auth-delay.sgml | F.2. auth_delay | 新 | 65 | 65 | ||||
279 | auto-explain.sgml | F.3. auto_explain | 新 | 233 | 233 | ||||
280 | btree-gin.sgml | F.4. btree_gin | 新 | 58 | 58 | ||||
281 | btree-gist.sgml | F.5. btree_gist | 新 | 110 | 110 | ||||
282 | chkpass.sgml | F.6. chkpass | 新 | 95 | 95 | ||||
283 | citext.sgml | F.7. citext | 新 | 255 | 255 | ||||
284 | cube.sgml | F.8. cube | 新 | 420 | 420 | ||||
285 | dblink.sgml | F.9. dblink | 新 | 2109 | 2109 | ||||
286 | dict-int.sgml | F.10. dict_int | 新 | 85 | 85 | ||||
287 | dict-xsyn.sgml | F.11. dict_xsyn | 新 | 149 | 149 | ||||
288 | dummy-seclabel.sgml | F.12. dummy_seclabel | 新 | 74 | 74 | ||||
289 | earthdistance.sgml | F.13. earthdistance | 新 | 193 | 193 | ||||
290 | file-fdw.sgml | F.14. file_fdw | 新 | 234 | 234 | ||||
291 | fuzzystrmatch.sgml | F.15. fuzzystrmatch | 新 | 233 | 233 | ||||
292 | hstore.sgml | F.16. hstore | 新 | 616 | 616 | ||||
293 | intagg.sgml | F.17. intagg | 新 | 131 | 131 | ||||
294 | intarray.sgml | F.18. intarray | 新 | 341 | 341 | ||||
295 | isn.sgml | F.19. isn | 新 | 389 | 389 | ||||
296 | lo.sgml | F.20. lo | 新 | 129 | 129 | ||||
297 | ltree.sgml | F.21. ltree | 新 | 679 | 679 | ||||
298 | pageinspect.sgml | F.22. pageinspect | 新 | 223 | 223 | ||||
299 | passwordcheck.sgml | F.23. passwordcheck | 新 | 62 | 62 | ||||
300 | pgbuffercache.sgml | F.24. pg_buffercache | 新 | 184 | 184 | ||||
301 | pgcrypto.sgml | F.25. pgcrypto | 新 | 1365 | 1365 | ||||
302 | pgfreespacemap.sgml | F.26. pg_freespacemap | 新 | 126 | 126 | ||||
303 | pgrowlocks.sgml | F.27. pgrowlocks | 新 | 144 | 144 | ||||
304 | pgstatstatements.sgml | F.28. pg_stat_statements | 新 | 412 | 412 | ||||
305 | pgstattuple.sgml | F.29. pgstattuple | 新 | 340 | 340 | ||||
306 | pgtrgm.sgml | F.30. pg_trgm | 新 | 326 | 326 | ||||
307 | postgres-fdw.sgml | F.31. postgres_fdw | 新 | 385 | 385 | 北京-henry | 翻译中 | 2013.11.7 | |
308 | seg.sgml | F.32. seg | 新 | 397 | 397 | ||||
309 | sepgsql.sgml | F.33. sepgsql | 新 | 789 | 789 | ||||
310 | contrib-spi.sgml | F.34. spi | 新 | 230 | 230 | ||||
311 | sslinfo.sgml | F.35. sslinfo | 新 | 238 | 238 | ||||
312 | tablefunc.sgml | F.36. tablefunc | 新 | 835 | 835 | ||||
313 | tcn.sgml | F.37. tcn | 新 | 71 | 71 | ||||
314 | test-parser.sgml | F.38. test_parser | 新 | 90 | 90 | ||||
315 | tsearch2.sgml | F.39. tsearch2 | 新 | 203 | 203 | ||||
316 | unaccent.sgml | F.40. unaccent | 新 | 157 | 157 | ||||
317 | uuid-ossp.sgml | F.41. uuid-ossp | 新 | 175 | 175 | ||||
318 | xml2.sgml | F.42. xml2 | 新 | 467 | 467 | ||||
319 | oid2name.sgml | G.1 oid2name | 新 | 332 | 332 | ||||
320 | pgbench.sgml | G.2 pgbench | 新 | 954 | 954 | John Winn | 翻译中 | 2013.11.8 | |
321 | vacuumlo.sgml | G.3 vacuumlo | 新 | 193 | 193 | ||||
322 | pgarchivecleanup.sgml | G.4 pgarchivecleanup | 新 | 211 | 211 | sh-doom.zhou | 翻译中 | 2013.11.8 | |
323 | pgstandby.sgml | G.5 pgstandby | 新 | 394 | 394 | sh-doom.zhou | 翻译中 | 2013.11.8 | |
324 | pgtestfsync.sgml | G.6 pgtestfsync | 新 | 121 | 121 | sh-doom.zhou | 翻译中 | 2013.11.8 | |
325 | pgtesttiming.sgml | G.7 pgtesttiming | 新 | 308 | 308 | sh-doom.zhou | 翻译中 | 2013.11.8 | |
326 | pgupgrade.sgml | G.8 pgupgrade | 新 | 663 | 663 | sh-doom.zhou | 翻译中 | 2013.11.8 | |
327 | pg_xlogdump.sgml | G.9 pg_xlogdump | 新 | 205 | 205 | sh-doom.zhou | 翻译中 | 2013.11.8 | |
328 | external-projects.sgml | H. External Projects | ≠ | 242 | 38 | 瀚高-韩悦悦 | 翻译中 | 2013.11.08 | |
329 | sourcerepo.sgml | I. The Source Code Repository | 新 | 97 | 97 | sh-doom.zhou | 翻译中 | 2013.11.8 | |
330 | docguide.sgml | J. Documentation | ≠ | 1299 | 190 | 媛媛 | 翻译中 | 2013.11.6 | |
331 | acronyms.sgml | K. Acronyms | 新 | 757 | 757 | ||||
332 | biblio.sgml | Bibliography | ≠ | 541 | 16 | ||||
其他 | |||||||||
333 | contacts.sgml | html中未找到引用 | ≠ | 26 | 2 | ||||
334 | filelist.sgml | 不需要翻译 | ≠ | 198 | 170 | ||||
335 | ref/allfiles.sgml | 不需要翻译 | ≠ | 191 | 183 | ||||
336 | sql.sgml | html中未找到引用 | ≠ | 2149 | 603 | ||||
337 | standalone-install.sgml | 不需要翻译 | ≠ | 42 | 4 |
文档规模汇总
Part | 总行数 | 比8.2.3修改行数 |
---|---|---|
index.html | 322 | 30 |
Preface | 849 | 48 |
I. Tutorial | 2008 | 335 |
II. The SQL Language | 39659 | 18178 |
III. Server Administration | 25889 | 14528 |
IV. Client Interfaces | 25383 | 18738 |
V. Server Programming | 24756 | 9823 |
VI. Reference | 262 | 62 |
VI. Reference -> I. SQL Commands | 35743 | 15386 |
VI. Reference -> II. PostgreSQL Client Applications | 11328 | 4742 |
VI. Reference -> III. PostgreSQL Server Applications | 2253 | 687 |
VII. Internals | 22626 | 9858 |
VIII. Appendixes | 95707 | 89069 |
合计 | 286785 | 181484 |
注)英文PG手册有2000多页,sgml共286785行,由此粗略估计每页相当于sgml的大约100行
翻译参加人员
- 组织:泥鳅、媛媛
- 参与:
联系方法
PG文档翻译群QQ:309292849