Changeset 412
- Timestamp:
- 10/07/06 15:54:22 (2 years ago)
- Files:
-
- traduc/trunk/manuel/backup.xml (modified) (8 diffs)
- traduc/trunk/manuel/catalogs.xml (modified) (11 diffs)
- traduc/trunk/manuel/client-auth.xml (modified) (1 diff)
- traduc/trunk/manuel/config.xml (modified) (3 diffs)
- traduc/trunk/manuel/ddl.xml (modified) (4 diffs)
- traduc/trunk/manuel/ecpg.xml (modified) (4 diffs)
- traduc/trunk/manuel/func.xml (modified) (3 diffs)
- traduc/trunk/manuel/gin.xml (modified) (1 diff)
- traduc/trunk/manuel/indexam.xml (modified) (1 diff)
- traduc/trunk/manuel/indices.xml (modified) (1 diff)
- traduc/trunk/manuel/information_schema.xml (modified) (1 diff)
- traduc/trunk/manuel/libpq.xml (modified) (1 diff)
- traduc/trunk/manuel/monitoring.xml (modified) (1 diff)
- traduc/trunk/manuel/ref/alter_index.xml (modified) (1 diff)
- traduc/trunk/manuel/ref/copy.xml (modified) (1 diff)
- traduc/trunk/manuel/ref/postmaster.xml (modified) (2 diffs)
- traduc/trunk/manuel/ref/select.xml (modified) (1 diff)
- traduc/trunk/manuel/release.xml (modified) (3 diffs)
- traduc/trunk/manuel/syntax.xml (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
traduc/trunk/manuel/backup.xml
r411 r412 161 161 <para> 162 162 After restoring a backup, it is wise to run <xref 163 linkend="sql-analyze" endterm="sql-analyze-title" > on each163 linkend="sql-analyze" endterm="sql-analyze-title"/> on each 164 164 database so the query optimizer has useful statistics. An easy way 165 165 to do this is to run <command>vacuumdb -a -z</command>; this is … … 619 619 of a transaction and its safe recording in archive storage. To put 620 620 a limit on how old unarchived data can be, you can set 621 <xref linkend="guc-archive-timeout" > to force the server to switch621 <xref linkend="guc-archive-timeout"/> to force the server to switch 622 622 to a new WAL segment file at least that often. Note that archived 623 623 files that are ended early due to a forced switch are still the same … … 633 633 just-finished transaction is archived immediately. Other utility 634 634 functions related to WAL management are listed in <xref 635 linkend="functions-admin-backup-table" >.635 linkend="functions-admin-backup-table"/>. 636 636 </para> 637 637 </sect2> … … 1401 1401 <programlisting> 1402 1402 triggered = false; 1403 while (!NextWALFileReady() & &!triggered)1403 while (!NextWALFileReady() && !triggered) 1404 1404 { 1405 1405 sleep(100000L); // wait for ~0.1 sec … … 1451 1451 Set up Continuous Archiving from the Primary to a WAL archive located 1452 1452 in a directory on the Standby Server. Ensure that both <xref 1453 linkend="guc-archive-command" > and <xref linkend="guc-archive-timeout">1454 are set. (See <xref linkend="backup-archiving-wal" >)1453 linkend="guc-archive-command"/> and <xref linkend="guc-archive-timeout"/> 1454 are set. (See <xref linkend="backup-archiving-wal"/>) 1455 1455 </para> 1456 1456 </listitem> … … 1458 1458 <para> 1459 1459 Make a Base Backup of the Primary Server. (See <xref 1460 linkend="backup-base-backup" >)1460 linkend="backup-base-backup"/>) 1461 1461 </para> 1462 1462 </listitem> … … 1465 1465 Begin recovery on the Standby Server from the local WAL archive, 1466 1466 using a recovery.conf that specifies a restore_command that waits as 1467 described previously. (See <xref linkend="backup-pitr-recovery" >)1467 described previously. (See <xref linkend="backup-pitr-recovery"/>) 1468 1468 </para> 1469 1469 </listitem> … … 1552 1552 possible to implement record-based Log Shipping using the 1553 1553 <function>pg_xlogfile_name_offset</function> function (see <xref 1554 linkend="functions-admin" >), though this requires custom1554 linkend="functions-admin"/>), though this requires custom 1555 1555 development. 1556 1556 </para> traduc/trunk/manuel/catalogs.xml
r398 r412 4051 4051 <title><structname>pg_shdescription</structname> Columns</title> 4052 4052 4053 <tgroup cols="4" />4053 <tgroup cols="4"> 4054 4054 <thead> 4055 4055 <row> … … 5012 5012 <listitem> 5013 5013 <para> 5014 via the <xref linkend="sql-declare" endterm="sql-declare-title" >5014 via the <xref linkend="sql-declare" endterm="sql-declare-title"/> 5015 5015 statement in SQL 5016 5016 </para> … … 5020 5020 <para> 5021 5021 via the Bind message in the frontend/backend protocol, as 5022 described in <xref linkend="protocol-flow-ext-query" >5022 described in <xref linkend="protocol-flow-ext-query"/> 5023 5023 </para> 5024 5024 </listitem> … … 5027 5027 <para> 5028 5028 via the Server Programming Interface (SPI), as described in 5029 <xref linkend="spi-interface" >5029 <xref linkend="spi-interface"/> 5030 5030 </para> 5031 5031 </listitem> … … 5052 5052 <title><structname>pg_cursors</structname> Columns</title> 5053 5053 5054 <tgroup cols="4" />5054 <tgroup cols="4"> 5055 5055 <thead> 5056 5056 <row> … … 5517 5517 all the prepared statements that are available in the current 5518 5518 session. See <xref linkend="sql-prepare" 5519 endterm="sql-prepare-title" > for more information about prepared5519 endterm="sql-prepare-title"/> for more information about prepared 5520 5520 statements. 5521 5521 </para> … … 5526 5526 prepared statement is created and removed when a prepared statement 5527 5527 is released (for example, via the <xref linkend="sql-deallocate" 5528 endterm="sql-deallocate-title" > command).5528 endterm="sql-deallocate-title"/> command). 5529 5529 </para> 5530 5530 … … 5532 5532 <title><structname>pg_prepared_statements</structname> Columns</title> 5533 5533 5534 <tgroup cols="4" />5534 <tgroup cols="4"> 5535 5535 <thead> 5536 5536 <row> … … 6371 6371 of time zone abbreviations that are currently recognized by the datetime 6372 6372 input routines. The contents of this view change when the 6373 <xref linkend="guc-timezone-abbreviations" > run-time parameter is modified.6373 <xref linkend="guc-timezone-abbreviations"/> run-time parameter is modified. 6374 6374 </para> 6375 6375 … … 6377 6377 <title><structname>pg_timezone_abbrevs</structname> Columns</title> 6378 6378 6379 <tgroup cols="3" />6379 <tgroup cols="3"> 6380 6380 <thead> 6381 6381 <row> … … 6429 6429 <title><structname>pg_timezone_names</structname> Columns</title> 6430 6430 6431 <tgroup cols="3" />6431 <tgroup cols="3"> 6432 6432 <thead> 6433 6433 <row> traduc/trunk/manuel/client-auth.xml
r411 r412 344 344 <para> 345 345 Authenticate using LDAP to a central server. See <xref 346 linkend="auth-ldap" > for details.346 linkend="auth-ldap"/> for details. 347 347 </para> 348 348 </listitem> traduc/trunk/manuel/config.xml
r411 r412 1509 1509 Turning off this parameter does not affect use of 1510 1510 WAL archiving for point-in-time recovery (PITR) 1511 (see <xref linkend="continuous-archiving" >).1511 (see <xref linkend="continuous-archiving"/>). 1512 1512 </para> 1513 1513 … … 4533 4533 4534 4534 <variablelist> 4535 <variablelist>4536 4535 <varlistentry id="guc-allow-system-table-mods" xreflabel="allow_system_table_mods"> 4537 4536 <term><varname>allow_system_table_mods</varname> (<type>boolean</type>)</term> … … 4707 4706 </variablelist> 4708 4707 </sect1> 4708 4709 4709 <sect1 id="runtime-config-short"> 4710 4710 <title>Options courtes</title> traduc/trunk/manuel/ddl.xml
r398 r412 83 83 <para> 84 84 Pour créer une table, il faut utiliser la commande bien nommée <xref 85 linkend="sql-createtable" endterm="sql-createtable-title" >. Dans cette85 linkend="sql-createtable" endterm="sql-createtable-title"/>. Dans cette 86 86 commande, vous devez spécifier au moins le nom de la 87 87 nouvelle table, les noms des colonnes et le type de données pour chacune des … … 140 140 Si vous n'avez plus besoin d'une table, vous pouvez la retirer en utilisant 141 141 la commande <xref 142 linkend="sql-droptable" endterm="sql-droptable-title" >. Par exemple :142 linkend="sql-droptable" endterm="sql-droptable-title"/>. Par exemple : 143 143 <programlisting>DROP TABLE ma_premiere_table; 144 144 DROP TABLE produits;</programlisting> … … 1428 1428 <para> 1429 1429 Pour créer un schéma, utilisez la commande <xref linkend="sql-createschema" 1430 endterm="sql-createschema-title" >. Donnez au schéma un nom de votre choix. Par1430 endterm="sql-createschema-title"/>. Donnez au schéma un nom de votre choix. Par 1431 1431 exemple : 1432 1432 <programlisting>CREATE SCHEMA mon_schema;</programlisting> … … 2090 2090 requêtes. Ceci facilitait les erreurs et est en plus une violation du 2091 2091 standard SQL. You can get the pre-7.1 behavior by turning off the 2092 <xref linkend="guc-sql-inheritance" > configuration2092 <xref linkend="guc-sql-inheritance"/> configuration 2093 2093 option. 2094 2094 </para> traduc/trunk/manuel/ecpg.xml
r411 r412 771 771 <para> 772 772 The numeric type offers to do calculations with arbitrary precision. See 773 <xref linkend="datatype-numeric" > for the equivalent type in the773 <xref linkend="datatype-numeric"/> for the equivalent type in the 774 774 <productname>PostgreSQL</productname> server. Because of the arbitrary precision this 775 775 variable needs to be able to expand and shrink dynamically. That's why you … … 1136 1136 <table> 1137 1137 <title>Valid input formats for <function>PGTYPESdate_from_asc</function></title> 1138 <tgroup cols="2" />1138 <tgroup cols="2"> 1139 1139 <thead> 1140 1140 <row> … … 1571 1571 <para> 1572 1572 The timestamp type in C enables your programs to deal with data of the SQL 1573 type timestamp. See <xref linkend="datatype-datetime" > for the equivalent1573 type timestamp. See <xref linkend="datatype-datetime"/> for the equivalent 1574 1574 type in the <productname>PostgreSQL</productname> server. 1575 1575 </para> … … 2193 2193 PGTYPESdecimal_new() and PGTYPESdecimal_free(). There are a lot of other 2194 2194 functions that deal with the decimal type in the Informix compatibility 2195 mode described in <xref linkend="ecpg-informix-compat" >.2195 mode described in <xref linkend="ecpg-informix-compat"/>. 2196 2196 </para> 2197 2197 <para> traduc/trunk/manuel/func.xml
r411 r412 1529 1529 <entry> 1530 1530 Remplace la sous-chaîne correspondant à l'expression rationnelle POSIX. 1531 Voir <xref linkend="functions-matching" > pour plus d'informations1531 Voir <xref linkend="functions-matching"/> pour plus d'informations 1532 1532 sur la correspondance de modèle. 1533 1533 </entry> … … 5795 5795 <entry><type>timestamp with time zone</type></entry> 5796 5796 <entry>Date et heure actuelle (début de la transaction en cours) ; 5797 voir <xref linkend="functions-datetime-current" >5797 voir <xref linkend="functions-datetime-current"/> 5798 5798 </entry> 5799 5799 <entry></entry> … … 8091 8091 Les <firstterm>fonctions d'agrégat</firstterm> calculent une seule 8092 8092 valeur résultant d'un ensemble de valeurs en entrée. Les fonctions d'agrégats 8093 intégrées sont listées dans <xref linkend="functions-aggregate-table" > et8094 <xref linkend="functions-aggregate-statistics-table" >. Les considérations8093 intégrées sont listées dans <xref linkend="functions-aggregate-table"/> et 8094 <xref linkend="functions-aggregate-statistics-table"/>. Les considérations 8095 8095 spéciales sur la syntaxe des fonctions 8096 8096 d'agrégat sont expliquées dans la <xref linkend="syntax-aggregates"/>. traduc/trunk/manuel/gin.xml
r411 r412 106 106 Returns an array of keys of the query to be executed. n contains 107 107 the strategy number of the operation 108 (see <xref linkend="xindex-strategies" >).108 (see <xref linkend="xindex-strategies"/>). 109 109 Depending on n, query may be different type. 110 110 </para> traduc/trunk/manuel/indexam.xml
r411 r412 277 277 </para> 278 278 279 </para>280 281 279 <para> 282 280 Bien sûr, Le but d'un index est de supporter les parcours de lignes traduc/trunk/manuel/indices.xml
r411 r412 265 265 tsearch2 and intarray modules. For more information see <xref linkend="GIN"/>. 266 266 </para> 267 </note>268 267 269 268 </sect1> traduc/trunk/manuel/information_schema.xml
r404 r412 492 492 493 493 <para> 494 See also under <xref linkend="infoschema-columns" >, a similarly494 See also under <xref linkend="infoschema-columns"/>, a similarly 495 495 structured view, for further information on some of the columns. 496 496 </para> traduc/trunk/manuel/libpq.xml
r404 r412 4278 4278 <para> 4279 4279 LDAP connection parameter lookup uses the connection service file 4280 <filename>pg_service.conf</filename> (see <xref linkend="libpq-pgservice" >).4280 <filename>pg_service.conf</filename> (see <xref linkend="libpq-pgservice"/>). 4281 4281 A line in a <filename>pg_service.conf</filename> stanza that starts with 4282 4282 <literal>ldap://</literal> will be recognized as an LDAP URL and an LDAP traduc/trunk/manuel/monitoring.xml
r404 r412 163 163 164 164 <para> 165 The parameter <xref linkend="guc-stats-command-string" > enables monitoring165 The parameter <xref linkend="guc-stats-command-string"/> enables monitoring 166 166 of the current command being executed by any server process. 167 167 The statistics collector subprocess need not be running to enable this traduc/trunk/manuel/ref/alter_index.xml
r410 r412 207 207 208 208 <simplelist type="inline"> 209 <member><xref linkend="sql-createindex" endterm="sql-createindex-title" ></member>210 <member><xref linkend="sql-reindex" endterm="sql-reindex-title" ></member>209 <member><xref linkend="sql-createindex" endterm="sql-createindex-title"/></member> 210 <member><xref linkend="sql-reindex" endterm="sql-reindex-title"/></member> 211 211 </simplelist> 212 212 </refsect1> traduc/trunk/manuel/ref/copy.xml
r410 r412 104 104 <listitem> 105 105 <para> 106 A <xref linkend="sql-select" endterm="sql-select-title" > or107 <xref linkend="sql-values" endterm="sql-values-title" > command106 A <xref linkend="sql-select" endterm="sql-select-title"/> or 107 <xref linkend="sql-values" endterm="sql-values-title"/> command 108 108 whose results are to be copied. 109 109 Note that parentheses are required around the query. traduc/trunk/manuel/ref/postmaster.xml
r410 r412 13 13 <refnamediv> 14 14 <refname id="postmaster-ref">postmaster</refname> 15 <refpurpose>Serveur de bases de donn ées <productname>PostgreSQL</productname></refpurpose>15 <refpurpose>Serveur de bases de données <productname>PostgreSQL</productname></refpurpose> 16 16 </refnamediv> 17 17 … … 31 31 32 32 <para> 33 <command>postmaster</command> est un alias obsol ète de <command>postgres</command>.33 <command>postmaster</command> est un alias obsolÚte de <command>postgres</command>. 34 34 </para> 35 35 </refsect1> traduc/trunk/manuel/ref/select.xml
r410 r412 225 225 doit être entouré de parenthèses et un alias 226 226 <emphasis>doit</emphasis> lui être fourni. 227 Une commande <xref linkend="sql-values" endterm="sql-values-title" >227 Une commande <xref linkend="sql-values" endterm="sql-values-title"/> 228 228 peut aussi être utilisée ici. 229 229 </para> traduc/trunk/manuel/release.xml
r411 r412 870 870 <para> 871 871 Improve the length output used by 872 <literal>UNION</literal>/<literal>INTERSECT</literal>/<literal>EXCEPT</ltieral>872 <literal>UNION</literal>/<literal>INTERSECT</literal>/<literal>EXCEPT</literal> 873 873 (Tom) 874 874 </para> … … 1050 1050 <listitem> 1051 1051 <para> 1052 Add <command>CREATE</command>/<command>ALTER ROLE PASSWORD NULL</comma bnd>,1052 Add <command>CREATE</command>/<command>ALTER ROLE PASSWORD NULL</command>, 1053 1053 which removes the role's password (Peter) 1054 1054 </para> … … 1346 1346 1347 1347 <para> 1348 The new operators are <literal>& </literal> (and), <literal>|</literal>1348 The new operators are <literal>&</literal> (and), <literal>|</literal> 1349 1349 (or), <literal>~</literal> (not), <literal>+</literal> <type>int8</type>, 1350 1350 <literal>-</literal> <type>int8</type>, and <type>inet</type> <literal>-</literal> traduc/trunk/manuel/syntax.xml
r404 r412 1537 1537 which will be expanded to a list of the elements of the row value, 1538 1538 just as occurs when the <literal>.*</literal> syntax is used at the top level 1539 of a <command>SELECT< command/> list. For example, if table <literal>t</literal> has1539 of a <command>SELECT</command> list. For example, if table <literal>t</literal> has 1540 1540 columns <literal>f1</literal> and <literal>f2</literal>, these are the same: 1541 1541 <programlisting>

