<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_group.sgml,v 1.12 2003/09/09 18:28:52 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_group.sgml,v 1.13 2003/09/12 00:12:47 tgl Exp $

PostgreSQL documentation

-->

</refsect1>

<refsect1>

<title>Parameter</title>

<title>Parameters</title>

<variablelist>

<varlistentry>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_language.sgml,v 1.3 2003/09/09 18:28:52 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_language.sgml,v 1.4 2003/09/12 00:12:47 tgl Exp $

PostgreSQL documentation

-->

</refsect1>

<refsect1>

<title>Parameter</title>

<title>Parameters</title>

<variablelist>

<varlistentry>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_schema.sgml,v 1.3 2003/09/09 18:28:52 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_schema.sgml,v 1.4 2003/09/12 00:12:47 tgl Exp $

PostgreSQL documentation

-->

</refsect1>

<refsect1>

<title>Parameter</title>

<title>Parameters</title>

<variablelist>

<varlistentry>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/cluster.sgml,v 1.28 2003/09/09 18:28:52 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/cluster.sgml,v 1.29 2003/09/12 00:12:47 tgl Exp $

PostgreSQL documentation

-->

</refsect1>

<refsect1>

<title>Parameter</title>

<title>Parameters</title>

<variablelist>

<varlistentry>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/clusterdb.sgml,v 1.13 2003/09/09 18:28:52 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/clusterdb.sgml,v 1.14 2003/09/12 00:12:47 tgl Exp $

PostgreSQL documentation

-->

<application>clusterdb</application> is a wrapper around the SQL

command <xref linkend="SQL-CLUSTER" endterm="sql-cluster-title">.

There is no effective difference between clustering databases via

this or other methods. The database server must be running at the

targeted host. Also, any default settings and environment

variables used by the <application>libpq</application> front-end

library will apply.

this utility and via other methods for accessing the server.

</para>

<para>

In case of difficulty, see <xref linkend="SQL-CLUSTER"

endterm="sql-cluster-title"> and <xref linkend="APP-PSQL"> for

discussions of potential problems and error messages.

The database server must be running at the

targeted host. Also, any default connection settings and environment

variables used by the <application>libpq</application> front-end

library will apply.

</para>

</refsect1>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/commit.sgml,v 1.17 2003/09/09 18:28:52 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/commit.sgml,v 1.18 2003/09/12 00:12:47 tgl Exp $

PostgreSQL documentation

-->

<refnamediv>

<refname>COMMIT</refname>

<refpurpose>commit the current transaction</refpurpose>

</refnamediv>

</refnamediv>

<indexterm zone="sql-commit">

<primary>COMMIT</primary>

</indexterm>

</programlisting>

</para>

</refsect1>

<refsect1>

<title>Compatibility</title>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_database.sgml,v 1.35 2003/08/31 17:32:22 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_database.sgml,v 1.36 2003/09/12 00:12:47 tgl Exp $

PostgreSQL documentation

-->

<productname>PostgreSQL</productname> database.

</para>

<para>

To create a database, you must be a superuser or have the special

<literal>CREATEDB</> privilege.

See <xref linkend="SQL-CREATEUSER" endterm="SQL-CREATEUSER-title">.

</para>

<para>

Normally, the creator becomes the owner of the new database.

Superusers can create databases owned by other users using the

a leading slash

(e.g., <filename>/usr/local/pgsql/data</filename>),

are allowed as well.

In either case, the final path name must be absolute and must not

contain any single quotes.

</para>

<para>

</refsect1>

<refsect1>

<title>Parameter</title>

<title>Parameters</title>

<variablelist>

<varlistentry>

</refsect1>

<refsect1>

<title>Diagnostics</title>

<variablelist>

<varlistentry>

<term><computeroutput>CREATE DATABASE</computeroutput></term>

<listitem>

<para>

Message returned if the database was successfully created.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><computeroutput>ERROR: user '<replaceable class="parameter">username</replaceable>' is not allowed to create/drop databases</computeroutput></term>

<listitem>

<para>

You must have the special <literal>CREATEDB</> privilege to create databases.

See <xref linkend="SQL-CREATEUSER" endterm="SQL-CREATEUSER-title">.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><computeroutput>ERROR: createdb: database "<replaceable class="parameter">name</replaceable>" already exists</computeroutput></term>

<listitem>

<para>

This occurs if a database with the specified name already

exists.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><computeroutput>ERROR: database path may not contain single quotes</computeroutput></term>

<listitem>

<para>

The database location

<replaceable class="parameter">dbpath</replaceable> cannot contain

single quotes. This is required so that the shell commands that

create the database directory can execute safely.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><computeroutput>ERROR: CREATE DATABASE: may not be called in a transaction block</computeroutput></term>

<listitem>

<para>

If you have an explicit transaction block in progress you cannot call

<command>CREATE DATABASE</command>. You must finish the transaction first.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><computeroutput>ERROR: Unable to create database directory '<replaceable>path</replaceable>'.</computeroutput></term>

<term><computeroutput>ERROR: Could not initialize database directory.</computeroutput></term>

<listitem>

<para>

These are most likely related to insufficient permissions on the data

directory, a full disk, or other file system problems. The user under

which the database server is running must have access to the location.

</para>

</listitem>

</varlistentry>

<title>Notes</title>

</variablelist>

</refsect1>

<para>

<command>CREATE DATABASE</> cannot be executed inside a transaction

block.

</para>

<refsect1>

<title>Notes</title>

<para>

Errors along the line of <quote>could not initialize database directory</>

are most likely related to insufficient permissions on the data

directory, a full disk, or other file system problems. When using an

alternate location, the user under

which the database server is running must have access to the location.

</para>

<para>

Use <xref linkend="SQL-DROPDATABASE" endterm="SQL-DROPDATABASE-title"> to remove a database.

<para>

There are security issues involved with using alternate database

locations specified with absolute path names. See <xref

locations specified with absolute path names; this is why the feature

is not enabled by default. See <xref

linkend="manage-ag-alternate-locs"> for more information.

</para>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.34 2003/08/31 17:32:22 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.35 2003/09/12 00:12:47 tgl Exp $

PostgreSQL documentation

-->

</variablelist>

</refsect1>

<refsect1>

<title>Diagnostics</title>

<variablelist>

<varlistentry>

<term><computeroutput>CREATE SEQUENCE</computeroutput></term>

<listitem>

<para>

Message returned if the sequence was successfully created.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><computeroutput>ERROR: Relation '<replaceable class="parameter">seqname</replaceable>' already exists</computeroutput></term>

<listitem>

<para>

A sequence, table, view, or index of the specified name already exists.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><computeroutput>ERROR: DefineSequence: MINVALUE (<replaceable class="parameter">start</replaceable>) can't be >= MAXVALUE (<replaceable class="parameter">max</replaceable>)</computeroutput></term>

<term><computeroutput>ERROR: DefineSequence: START value (<replaceable class="parameter">start</replaceable>) can't be < MINVALUE (<replaceable class="parameter">min</replaceable>)</computeroutput></term>

<listitem>

<para>

The specified starting value is out of range.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><computeroutput>ERROR: DefineSequence: MINVALUE (<replaceable class="parameter">min</replaceable>) can't be >= MAXVALUE (<replaceable class="parameter">max</replaceable>)</computeroutput></term>

<listitem>

<para>

The minimum and maximum values are inconsistent.

</para>

</listitem>

</varlistentry>

</variablelist>

</refsect1>

<refsect1>

<title>Notes</title>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_view.sgml,v 1.23 2003/08/31 17:32:22 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_view.sgml,v 1.24 2003/09/12 00:12:47 tgl Exp $

PostgreSQL documentation

-->

</variablelist>

</refsect1>

<refsect1>

<title>Diagnostics</title>

<variablelist>

<varlistentry>

<term><computeroutput>CREATE VIEW</computeroutput></term>

<listitem>

<para>

Message returned if the view was successfully created.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><computeroutput>WARNING: Attribute '<replaceable class="parameter">column</replaceable>' has an unknown type</computeroutput></term>

<listitem>

<para>

The view will be created having a column with an unknown type if

you do not specify it. For example, the following command gives

this warning:

<programlisting>

CREATE VIEW vista AS SELECT 'Hello World'

</programlisting>

whereas this command does not:

<programlisting>

CREATE VIEW vista AS SELECT text 'Hello World'

</programlisting>

</para>

</listitem>

</varlistentry>

</variablelist>

</refsect1>

<refsect1>

<title>Notes</title>

<para>

Use the <command>DROP VIEW</command> statement to drop views.

</para>

<para>

Be careful that the names and types of the view's columns will be

assigned the way you want. For example,

<programlisting>

CREATE VIEW vista AS SELECT 'Hello World';

</programlisting>

is bad form in two ways: the column name defaults to <literal>?column?</>,

and the column datatype defaults to <type>unknown</>. If you want a

string literal in a view's result, use something like

<programlisting>

CREATE VIEW vista AS SELECT text 'Hello World' AS hello;

</programlisting>

</para>

</refsect1>

<refsect1>