<Step Performance="required">

<para>

Several regression tests could fail if the user's locale collation

scheme is different from that of standardC locale.

scheme is different from that ofthestandard<literal>C</literal> locale.

</para>

<para>

If you configure and compile <ProductName>Postgres</ProductName>

with the <option>--enable-locale</option> option then

set locale environment to C (or unset all LC_* variables)

with <option>--enable-locale</option> then you should

set the locale environment to <quote><literal>C</literal></quote>

(or unset all <quote>LC_*</quote> variables)

by putting these additional lines to your login environment

before starting postmaster:

before starting <application>postmaster</application>:

<ProgramListing>

LC_COLLATE=C

LC_CTYPE=C

<sect1>

<sect1 id="copyright">

<title>Copyrights and Trademarks</title>

<para>

<sect1>

<sect1 id="terminology">

<title>Terminology</title>

<para>

</para>

</sect1>

<sect1>

<sect1 id="notation">

<title>Notation</title>

<para>

<chapter>

<chapter id="release">

<title>Release Notes</title>

<sect1>

longer are restricted by simple table-level locking;

we have something better than row-level locking.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term>

Hot backups from <application>pg_dump</application>

</term>

<listitem>

<para>

Another big benefit of MVCC is that<application>pg_dump</application>

blocking active transactions.

<application>pg_dump</application> takes advantage of the new

the database stays online and available for queries.

</para>

</listitem>

</varlistentry>

<para>

We now have CASE, INTERSECT, and EXCEPT statement

support. We have new LIMIT/OFFSET, SET TRANSACTION ISOLATION LEVEL,

SELECT ... FOR UPDATE, and an improved LOCK command.

SELECT ... FOR UPDATE, and an improved LOCKTABLEcommand.

</para>

</listitem>

</varlistentry>

<command>SELECT</command> it doesn't mean that this row really exists

at the time it is returned (i.e. sometime after the statement or

transaction began) nor that the row is protected from deletion or

updation by concurrent transactions before the current transaction does

update by concurrent transactions before the current transaction does

a commit or rollback.

</para>

<chapter>

<chapter id="syntax">

<title>SQL Syntax</title>

<abstract>