Pg9.3

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(翻译任务及状态)
Line 27: Line 27:
 
! 编号  !!  文件名  !!  标题  !!  和8.2.3比较结果  !!  总行数  !!  比8.2.3修改行数  !!  翻译者  !!  状态  !!  开始时间  !!  结束时间
 
! 编号  !!  文件名  !!  标题  !!  和8.2.3比较结果  !!  总行数  !!  比8.2.3修改行数  !!  翻译者  !!  状态  !!  开始时间  !!  结束时间
 
|-  
 
|-  
|  1  ||  postgres.sgml  ||  PostgreSQL 9.3.1 Documentation  ||  ≠  ||  274  ||  23  ||   ||   ||   ||   
+
|  1  ||  postgres.sgml  ||  PostgreSQL 9.3.1 Documentation  ||  ≠  ||  274  ||  23  || 陈华军  || 翻译中  || 2013.11.07  ||   
 
|-  
 
|-  
|  2  ||  legal.sgml  ||  Legal Notice  ||  ≠  ||  48  ||  7  ||   ||   ||   ||   
+
|  2  ||  legal.sgml  ||  Legal Notice  ||  ≠  ||  48  ||  7  || 陈华军  || 翻译中  || 2013.11.07  ||   
 
|-  
 
|-  
 
| colspan=10 | '''Preface'''
 
| colspan=10 | '''Preface'''

Revision as of 11:11, 7 November 2013

Contents

总体目标

翻译的流程及框架

  • 本次翻译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

翻译任务及状态

  • 当前任务: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
4 history.sgml A Brief History of PostgreSQL 222 16
5 notation.sgml Conventions 31 1
6 info.sgml Further Information 69 9
7 problems.sgml Bug Reporting Guidelines 366 15
I. Tutorial
8 start.sgml 1. Getting Started 411 32
9 query.sgml 2. The SQL Language 880 42
10 advanced.sgml 3. Advanced Features 717 261
II. The SQL Language
11 syntax.sgml 4. SQL Syntax 2508 921
12 ddl.sgml 5. Data Definition 3201 560
13 dml.sgml 6. Data Manipulation 255 28
14 queries.sgml 7. Queries 2094 794
15 datatype.sgml 8. Data Types 4666 1749
16 array.sgml 8.15.Arrays 723 163
17 rowtypes.sgml 8.16.Composite Types 330 26
18 rangetypes.sgml 8.17.Range Types 508 508
19 func.sgml 9. Functions and Operators 16370 7579
20 typeconv.sgml 10. Type Conversion 1004 226
21 indices.sgml 11. Indexes 1198 330
22 textsearch.sgml 12. Full Text Search 3668 3668
23 mvcc.sgml 13. Concurrency Control 1558 726
24 perform.sgml 14. Performance Tips 1576 900
III. Server Administration
25 installation.sgml 15. Installation from Source Code 2973 1620
26 install-windows.sgml 16. Installation from Source Code on Windows 611 611
27 runtime.sgml 17. Server Setup and Operation 2290 1083
28 config.sgml 18. Server Configuration 6798 3206
29 client-auth.sgml 19. Client Authentication 1804 1049
30 user-manag.sgml 20. Database Roles 442 61
31 manage-ag.sgml 21. Managing Databases 510 179
32 charset.sgml 22. Localization 1540 472
33 maintenance.sgml 23. Routine Database Maintenance Tasks 883 431
34 backup.sgml 24. Backup and Restore 1426 603
35 high-availability.sgml 25. High Availability, Load Balancing, and Replication 2197 2071
36 recovery-config.sgml 26. Recovery Configuration 361 361
37 monitoring.sgml 27. Monitoring Database Activity 2539 1988
38 diskusage.sgml 28. Monitoring Disk Usage 144 38
39 wal.sgml 29. Reliability and the Write-Ahead Log 766 509
40 regress.sgml 30. Regression Tests 605 246
IV. Client Interfaces
41 libpq.sgml 31. libpq - C Library 8240 7311
42 lobj.sgml 32. Large Objects 853 304
43 ecpg.sgml 33. ECPG - Embedded SQL in C 9678 8372
44 information_schema.sgml 34. The Information Schema 6612 2751
V. Server Programming
45 extend.sgml 35. Extending SQL 1206 978
46 xfunc.sgml 35.3. User-defined Functions 3388 882
47 dfunc.sgml 35.9.6. Compiling and Linking Dynamically-loaded Functions 299 11
48 xaggr.sgml 35.10. User-defined Aggregates 196 39
49 xtypes.sgml 35.11. User-defined Types 294 70
50 xoper.sgml 35.12. User-defined Operators 466 79
51 xindex.sgml 35.14. Interfacing Extensions To Indexes 1177 461
52 trigger.sgml 36. Triggers 842 199
53 event-trigger.sgml 37. Event Triggers 822 822
54 rules.sgml 38. The Rule System 2438 501
55 xplang.sgml 39. Procedural Languages 239 71
56 plpgsql.sgml 40. PL/pgSQL - SQL Procedural Language 5384 2444
57 pltcl.sgml 41. PL/Tcl - Tcl Procedural Language 778 79
58 plperl.sgml 42. PL/Perl - Perl Procedural Language 1389 637
59 plpython.sgml 43. PL/Python - Python Procedural Language 1440 1043
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
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
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
246 catalogs.sgml 47. System Catalogs 9261 4687
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
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
258 bki.sgml 59. BKI Backend Interface 357 15
259 planstats.sgml 60. How the Planner Uses Statistics 451 279
VIII. Appendixes
260 errcodes.sgml A. PostgreSQL Error Codes 89 21
261 datetime.sgml B. Date/Time Support 594 76
262 keywords.sgml C. SQL Key Words 5327 1269
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
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
321 vacuumlo.sgml G.3 vacuumlo 193 193
322 pgarchivecleanup.sgml G.4 pgarchivecleanup 211 211
323 pgstandby.sgml G.5 pgstandby 394 394
324 pgtestfsync.sgml G.6 pgtestfsync 121 121
325 pgtesttiming.sgml G.7 pgtesttiming 308 308
326 pgupgrade.sgml G.8 pgupgrade 663 663
327 pg_xlogdump.sgml G.9 pg_xlogdump 205 205
328 external-projects.sgml H. External Projects 242 38
329 sourcerepo.sgml I. The Source Code Repository 97 97
330 docguide.sgml J. Documentation 1299 190
331 acronyms.sgml K. Acronyms 757 757 媛媛 翻译中 2013.11.6
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

参考

https://github.com/buke/openerp-doc

Personal tools