Remove call to difftime() in timestamp support to fix SunOS(Bruce & Thomas)

Changes for Digital Unix

Portability fix for pg_dumpall(Bruce)

Rename pg_attribute.attnvals toattdisbursion(Bruce)

Rename pg_attribute.attnvals toattdispersion(Bruce)

"intro/unix" manual page now "pgintro"(Bruce)

"built-in" manual page now "pgbuiltin"(Bruce)

"drop" manual page now "drop_table"(Bruce)

* allow configuration of maximum number of open files

* Remove pg_listener index

* Remove ANALYZE from VACUUM so it can be run separately without locks

* Gather more accuratedisbursion statistics using indexes

* Gather more accuratedispersion statistics using indexes

* Improve statistics storage in pg_class [performance]

* Improve VACUUM speed with indexes [vacuum]

* -BSD/OS does not support locale because there is no LC_MESSAGES (Bruce)

{

float32data nvals;

nvals =getattdisbursion(relid, (int) attno);

nvals =getattdispersion(relid, (int) attno);

! if (nvals == 0)

*result = 1.0 / 3.0;

else

{

float32data nvals;

nvals =getattdisbursion(relid, (int) attno);

nvals =getattdispersion(relid, (int) attno);

! if (nvals == 0) {

*result = 1.0 / 3.0;

+ }

Received: from renoir.op.net (root@renoir.op.net [207.29.195.4])

by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id TAA00672

for <pgman@candle.pha.pa.us>; Thu, 20 Jan 2000 19:45:30 -0500 (EST)

Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.14 $) with ESMTP id TAA01989 for <pgman@candle.pha.pa.us>; Thu, 20 Jan 2000 19:39:15 -0500 (EST)

Received: from hub.org (hub.org [216.126.84.1]) by renoir.op.net (o1/$Revision: 1.15 $) with ESMTP id TAA01989 for <pgman@candle.pha.pa.us>; Thu, 20 Jan 2000 19:39:15 -0500 (EST)

Received: from localhost (majordom@localhost)

by hub.org (8.9.3/8.9.3) with SMTP id TAA00957;

Thu, 20 Jan 2000 19:35:19 -0500 (EST)

pgaccess-ref.sgml\

pgadmin-ref.sgml\

pg-config-ref.sgml\

pgctl-ref.sgml\

pg_ctl-ref.sgml\

pgtclsh.sgml\

pgtksh.sgml\

postgres-ref.sgml\

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.21 2000/08/26 13:08:15 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.22 2000/10/05 19:48:17 momjian Exp $

Postgres documentation

Complete list of usable sgml source files in this directory.

-->

<!entity pgAccess system "pgaccess-ref.sgml">

<!entity pgAdmin system "pgadmin-ref.sgml">

<!entity pgConfig system "pg-config-ref.sgml">

<!entity pgCtl system "pgctl-ref.sgml">

<!entity pgCtl system "pg_ctl-ref.sgml">

<!entity pgDump system "pg_dump.sgml">

<!entity pgDumpall system "pg_dumpall.sgml">

<!entity pgPasswd system "pg_passwd.sgml">

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.14 2000/07/22 02:39:10 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.15 2000/10/05 19:48:17 momjian Exp $

Postgres documentation

-->

<para>

Removes a table constraint (such as a check constraint,

unique constraint, or foreign key constraint). To

remove a unique constraint, drop a unique index,

remove a unique constraint, drop a unique index.

To remove other kinds of constraints you need to recreate

and reload the table, using other parameters to the

<xref linkend="SQL-CREATETABLE" endterm="SQL-CREATETABLE-title">

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v 1.17 2000/07/22 02:39:10 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v 1.18 2000/10/05 19:48:17 momjian Exp $

Postgres documentation

-->

You must have <firstterm>select access</firstterm> on any table

whose values are read by

<command>COPY</command>, and either

<firstterm>insert or update access</firstterm> to a

<firstterm>insert</firstterm> or<firstterm>update access</firstterm> to a

table into which values are being inserted by <command>COPY</command>.

The backend also needs appropriate Unix permissions for any file read

or written by <command>COPY</command>.

<para>

The actual format for each instance is

<programlisting>

&lt;attr1&gt;&lt;<replaceable class=parameter>separator</replaceable>&gt;&lt;attr2&gt;&lt;<replaceable class=parameter>separator</replaceable>&gt;...&lt;<replaceable class=parameter>separator</replaceable>&gt;&lt;attr<replaceable class="parameter">n</replaceable>&gt;&lt;newline&gt;

&lt;attr1&gt;&lt;<replaceable class=parameter>separator</replaceable>&gt;&lt;attr2&gt;&lt;<replaceable class=parameter>separator</replaceable>&gt;...&lt;<replaceable class=parameter>separator</replaceable>&gt;&lt;attr<replaceable class="parameter">n</replaceable>&gt;&lt;newline&gt;.

</programlisting>

The oid is placed on the beginning of the line

if WITH OIDS is specified.

In the case of <command>COPY BINARY</command>, the first four

bytes in the file will be the number of instances in the file. If

this number is zero, the <command>COPY BINARY</command> command

will read until end offile is encountered. Otherwise, it will

will read until end-of-file is encountered. Otherwise, it will

stop reading when this number of instances has been read.

Remaining data in the file will be ignored.

</para>

COPY country TO <filename>stdout</filename> USING DELIMITERS '|';

</programlisting>

<para>

To copy data from a Unix file into a table"country":

To copy data from a Unix file into a table country:

</para>

<programlisting>

COPY country FROM '/usr1/proj/bray/sql/country_data';

\.

</programlisting>

<para>

The same data, output in binary format on a Linux/i586 machine.

Thefollowing is thesame data, output in binary format on a Linux/i586 machine.

The data is shown after filtering through

the Unix utility <command>od -c</command>. The table has

three fields; the first is <classname>char(2)</classname>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_aggregate.sgml,v 1.11 2000/09/12 20:52:07 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_aggregate.sgml,v 1.12 2000/10/05 19:48:17 momjian Exp $

Postgres documentation

-->

for base types such as <function>min(int4)</function>

and <function>avg(float8)</function> are already provided in the base

distribution. If one defines new types or needs an aggregate function not

already provided then <command>CREATE AGGREGATE</command>

already provided, then <command>CREATE AGGREGATE</command>

can be used to provide the desired features.

</para>

<para>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_database.sgml,v 1.14 2000/05/02 20:02:03 thomas Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_database.sgml,v 1.15 2000/10/05 19:48:17 momjian Exp $

Postgres documentation

-->

<listitem>

<para>

The expansion of the specified <replaceable class="parameter">dbpath</replaceable>

(see below how) failed. Check the path you entered or make sure that the

(see below) failed. Check the path you entered or make sure that the

environment variable you are referencing does exist.

</para>

</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.

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

</para>

</listitem>

</varlistentry>

If the server is compiled with <literal>ALLOW_ABSOLUTE_DBPATHS</literal>

(not so by default), absolute path names, as identified by

a leading slash

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

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

are allowed as well.

</para>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_function.sgml,v 1.17 2000/08/25 15:17:50 thomas Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_function.sgml,v 1.18 2000/10/05 19:48:17 momjian Exp $

Postgres documentation

-->

The data type(s) of the function's arguments, if any.

The input types may be base or complex types, or

<firstterm>opaque</firstterm>.

<literal>opaque</literal> indicates that the function

<literal>Opaque</literal> indicates that the function

accepts arguments of a non-SQL type such as <type>char *</type>.

</para>

</listitem>

<para>

The return data type.

The output type may be specified as a base type, complex type,

<option>setof<replaceable class="parameter">type</replaceable></option>,

<option>setof type</option>,

or <option>opaque</option>.

The <option>setof</option>

modifier indicates that the function will return a set of items,

<listitem>

<para>

This form of the <command>AS</command> clause is used for

dynamically-linked, C language functions when the function name in

dynamicallylinked, C language functions when the function name in

the C language source code is not the same as the name of the SQL

function. The string <replaceable

class="parameter">obj_file</replaceable> is the name of the file

<term><replaceable class="parameter">langname</replaceable></term>

<listitem>

<para>

may be '<literal>sql</literal>',

May be '<literal>sql</literal>',

'<literal>C</literal>', '<literal>newC</literal>',

'<literal>internal</literal>', '<literal>newinternal</literal>',

or '<replaceable class="parameter">plname</replaceable>',

<term>iscachable</term>

<listitem>

<para>

<option>iscachable</option> indicates that the function always

<option>Iscachable</option> indicates that the function always

returns the same result when given the same argument values (i.e.,

it does not do database lookups or otherwise use information not

directly present in its parameter list). The optimizer uses

<para>

The full <acronym>SQL92</acronym> type syntax is allowed for

input arguments and return value. However, some details of the

type specification (e.g. the precision field for

type specification (e.g., the precision field for

<type>numeric</type> types) are the responsibility of the

underlying function implementation and are silently swallowed

(i.e., not recognized or

errors at link time. To get around that, give them different C names

(for example, use the argument types as part of the C names), then

specify those names in the AS clause of <command>CREATE FUNCTION</command>.

If the AS clause is left empty then <command>CREATE FUNCTION</command>

If the AS clause is left empty, then <command>CREATE FUNCTION</command>

assumes the C name of the function is the same as the SQL name.

</para>

<para>

This example creates a function that does type conversion between the

userdefined type complex, and the internal type point. The

user-defined type complex, and the internal type point. The

function is implemented by a dynamically loaded object that was

compiled from C source. For <productname>Postgres</productname> to

find a type conversion function automatically, the sql function has