some other examples for CREATE DATABASE.

Gavin Sherry

Alvaro

> * Add session start time and last statement time to pg_stat_activity

<   rather than in /contrib
>   rather than in /contrib (Matthew)
515a516
> * Matthew T. O'Connor <matthew@zeut.net>

Pavel Stehule

< * Allow moving sequences and toast tables to other tablespaces

> * Allow moving sequences and toast tables to other tablespaces

section where a instr function parameter is mistyped as varchar. It
works properly when changed to integer.

Michael Glaesemann

Gavin Sherry

> * Add NOVICE output level for helpful messages like automatic sequence/index creation

environment variables.

probably should have been to begin with; this is to cover cases like
needing to recreate the per-db directory during WAL replay.
Also, fix heap_create to force pg_class.reltablespace to be zero instead
of the database's default tablespace; this makes the world safe for
CREATE DATABASE to handle all tables in the default tablespace alike,
as per previous discussion.  And force pg_class.reltablespace to zero
when creating a relation without physical storage (eg, a view); this
avoids possibly having dangling references in this column after a
subsequent DROP TABLESPACE.

shift support code into heapam.c accordingly.  This is in service of
soon-to-be-committed ALTER TABLE SET TABLESPACE code that will want to
use this same record type for both heaps and indexes.

Theoretically I should have forced initdb for this, but in practice there
is no change in xlog contents because CVS tip will never really emit this
record type anyhow...

control-z requirement.

than 'datetime BC zone', because the former is accepted by the timestamptz
input converter while the latter may not be depending on spacing.  This
is not a loss of compatibility w.r.t. 7.4 and before, because until very
recently there was never a case where we'd output both zone and 'BC'.

> * Allow moving system tables to other tablespaces, where possible

> * Allow changing of already-created database and schema tablespaces

> *  Add an option to sync() before fsync()'ing checkpoint files

<
> * Use a phantom command counter for nested subtransactions to reduce
>   tuple overhead

Add new postgresql.conf variables to point to data, pg_hba.conf, and
pg_ident.conf files.

Needs more documentation.

> * Add include functionality to postgresql.conf
>

since the person or script starting the postmaster has to be trusted
anyway.

accurate matching of our time zone to the system's zone.  This method is
able to distinguish Antarctica/Casey from Australia/Perth, as in Chris
K-L's recent example; and it is not materially slower than before, because
the extra checks generally don't get done against very many time zones.

It seems possible that with this test we'd be able to correctly identify
Windows timezones without looking at the timezone name, but I do not
have the ability to try it.

Also a quick but half-baked attempt to make trim_trailing_separator
do the right thing with path consisting only of '/' --- still needs
work for Windows I think.

This is required by SQL spec to avoid failures in cases like
  SELECT sum(win)/sum(lose) FROM ... GROUP BY ... HAVING sum(lose) > 0;
AFAICT we have gotten this wrong since day one.  Kudos to Holger Jakobs
for being the first to notice.

definitions more frequently.

OS thread tests fail.