> * Make LENGTH() of CHAR() not count trailing spaces
>

< * Allow clients to query WITH HOLD cursors and prepared statements
> * Allow clients to query a list of WITH HOLD cursors and prepared statements

<   manuals (Rory)
>   manuals
496c496
< * Jan is Jan Wieck <JanWieck@Yahoo.com> of PeerDirect Corp.
> * Jan is Jan Wieck <JanWieck@Yahoo.com> of Afilias, Inc.

make sure the $Id tags are converted to $PostgreSQL as well ...

< A dash (-) marks changes that will appear in the upcoming 7.4 release.
> A dash (-) marks changes that will appear in the upcoming 7.5 release.
437c437
< * Use background process to write dirty shared buffers to disk
> * -Use background process to write dirty shared buffers to disk

< * -Allow elog() to return error codes, module name, file name, line
<   number, not just messages (Tom)
< * -Add error codes (Tom)
< * -Make error messages more consistent
40d35
< * -Add GUC log_statement_and_duration to print statement and >= min duration
51d45
< * -Allow easy display of usernames in a group
53d46
< * -Add start time to pg_stat_activity
55d47
< * -Have standalone backend read postgresql.conf (Tom)
59d50
< * -Allow CIDR format to be used in pg_hba.conf
74d64
< * -Add IPv6 capability to INET/CIDR types
77d66
< * -Change NUMERIC data type to use base 10,000 internally
82d70
< * -Add GUC variables to control floating number output digits (Pedro Ferreira)
90,92d77
< * -Allow current datestyle to restrict dates;  prevent month/day swapping
<   from making invalid dates valid
< * -Prevent month/day swapping of ISO dates to make invalid dates valid
102d86
< 	o -Allow arrays to be ORDER'ed
104d87
< 	o -Support construction of array result values in expressions (Joe)
128d110
< * -Remove Cyrillic recode support
146,147d127
< * -Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops)
<   fails index can't store constant parameters
155d134
< * -Add btree index support for reltime, tinterval, regproc (Tom)
157d135
< * -Certain indexes will not shrink, e.g. indexes on ever-increasing
161d138
< * -Allow LIKE indexing optimization for non-ASCII locales using special index
173d149
< * -Improve concurrency of hash indexes (Tom)
181d156
< * -Allow LIMIT/OFFSET to use expressions (Tom)
187d161
< * -Return proper effected tuple count from complex commands [return]
191d164
< * -Make a transaction-safe TRUNCATE (Rod)
196,197d168
< * -Allow UPDATE to use SET col = DEFAULT
< * -Add config variable to prevent auto-adding missing FROM-clause tables
199d169
< * -Have SELECT '13 minutes'::interval display zero seconds in ISO datestyle
224,225d193
< 	o -Add ALTER TABLE tab SET WITHOUT OIDS (Rod)
< 	o -Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values
237d204
< 	o -Allow CLUSTER to cluster all tables (Alvaro Herrera)
248d214
< 	o -MOVE 0 should not move to end of cursor (Bruce)
252d217
< 	o -Allow cursors outside transactions
264,265d228
< 	o -Allow EXPLAIN EXECUTE to see prepared plans
<  	o -Allow SHOW of some non-modifiable variables, like pg_controldata
280d242
< 	o -Allow array declarations and other data types in PL/PgSQL DECLARE
282,283d243
< 	o -Make PL/PgSQL %TYPE schema-aware
< 	o -Allow PL/PgSQL to support array element assignment (Joe)
294,298d253
< * -Allow psql to show transaction status if backend protocol changes made
< * -Add schema, cast, and conversion backslash commands to psql (Christopher)
< * -Allow pg_dump to dump a specific schema (Neil Conway)
< * -Allow psql to do table completion for SELECT * FROM schema_part and
<   table completion for SELECT * FROM schema_name.
300,302d254
< * -Allow SSL-enabled clients to turn off SSL transfers
< * -Modify pg_get_triggerdef() to take a boolean to pretty-print,
<   and use that as part of pg_dump along with psql
327d278
< 	o -Add SQLSTATE
330d280
< 	o -Make casts work in variable initializations
334,336d283
< 	o -Allow multi-threaded use of SQLCA
< 	o -Understand structure definitions outside a declare section
< 	o -Allow :var[:index] or :var[<integer>] as cvariable for an array var
356d302
< * -Support statement-level triggers (Neil)
460,461d405
< * -Add checkpoint_min_warning postgresql.conf option to warn about checkpoints
<   that are too frequent (Bruce)
472,476d415
< * -Improve Subplan list handling
< * -Allow Subplans to use efficient joins(hash, merge) with upper variable
< * -Add hash for evaluating GROUP BY aggregates (Tom)
< * -Allow merge and hash joins on expressions not just simple variables (Tom)
< * -Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS (Tom)
480d418
< * -Inline simple SQL functions to avoid overhead (Tom)
495d432
< * -Get faster regex() code from Henry Spencer <henry@zoo.utoronto.ca>
511,512d447
< * -Modify regression tests to prevent failures do to minor numeric rounding
< * -Add OpenBSD's getpeereid() call for local socket authentication
537,542d471
< 	o -Show transaction status in psql
< 	o -Allow binding of query parameters, support for prepared queries
< 	o -Remove hard-coded limits on user/db/password names
< 	o -Remove unused elements of startup packet (unused, tty, passlength)
< 	o -Fix COPY/fastpath protocol
< 	o -Error codes
544d472
< 	o -Special passing of binary values in platform-neutral format (bytea?)
547d474
< 	o -Report server version number, database encoding, client encoding

> * Add GUC setting to make created tables default to WITHOUT OIDS

< 	o --Add ALTER TABLE tab SET WITHOUT OIDS (Rod)
> 	o -Add ALTER TABLE tab SET WITHOUT OIDS (Rod)

> * Ignore temporary tables from other session when processing inheritance

> * Add free-behind capability for large sequential scans (fadvise)

> * Have psql '\i ~/<tab><tab>' actually load files it displays from home dir

> * Have psql \dn show only visible schemas using current_schemas()

> * Use more reliable method for CREATE DATABASE to get a consistent copy of db
>

> * Allow CREATE TABLE foo (f1 INT CHECK (f1 > 0) CHECK (f1 < 10)) to work
>   by searching for non-conflicting constraint names, and prefix with table name

> * Change LIMIT/OFFSET to use int8

> * Allow more ISOLATION LEVELS to be accepted, but issue a warning for them

< 	o Queries across databases or servers (two-phase commit) [2phase]
> 	o Queries across databases or servers (two-phase commit)

> 	o Queries across databases or servers (two-phase commit) [2phase]

> * Allow functions to have a search path specified at creation time

< 	o Allow BINARY option to SELECT, just like DECLARE

< * Allow INET subnet tests to use indexes
> * Allow INET subnet tests using non-constants to be indexed

< * Allow INET subnet tests using non-constants
> * Allow INET subnet tests to use indexes
101a102
> 	o Allow MIN()/MAX() on arrays
144c145
< * Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops)
> * -Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops)
166c167
< * Improve handling of index scans for NULL
> * Allow use of indexes to search for NULLs
203a205
> * Add optional textual message to NOTIFY
252c254
< 	o Add SET SCHEMA
> 	o Add SET PATH for schemas
297a300
> * Allow fastpast to pass values in portable format
344a348
> * Allow statement-level triggers to access modified rows
526d529
< 	o Add optional textual message to NOTIFY
530d532
< 	o Allow fastpast to pass values in portable format
533c535
< 	o Special passing of binary values in platform-neutral format (bytea?)
> 	o -Special passing of binary values in platform-neutral format (bytea?)

> * Allow pg_dump to dump CREATE CONVERSION (Christopher)

> * Prevent libpq's PQfnumber() from lowercasing the column name
572d572
< * Vadim is Vadim B. Mikheev <vadim4o@email.com> of Sector Data

>   to allow fast COUNT(*) queries with no WHERE clause(?) [count]

> 	o Allow PL/pgSQL to handle %TYPE arrays, e.g. tab.col%TYPE[]

> * Have VACUUM FULL use REINDEX rather than index vacuum

> * COMMENT ON [ CAST | CONVERSION | OPERATOR CLASS | LARGE OBJECT | LANGUAGE ]
>   (Christopher)

> * COMMENT ON [ CAST | CONVERSION | OPERATOR CLASS | LARGE OBJECT ] (Christopher)

<
346a346
> * Remove CREATE CONSTRAINT TRIGGER

< 	o Sample implementation in contrib/rserv
29c28,29
< * Create native Win32 port [win32]
> * Create native Win32 port, http://momjian.postgresql.org/main/writings/pgsql/win32.html
>
367c367,368
< * Two-phase commit to implement distributed transactions
> * Add two-phase commit to all distributed transactions with
>   offline/readonly server status or administrator notification for failure

> * Use background process to write dirty shared buffers to disk

< * Consider using MVCC to cache count(*) queries with no WHERE clause
> * Use a fixed row count and a +/- count with MVCC visibility rules
>   to allow fast COUNT(*) queries with no WHERE clause(?)

< 	o Fixed PL/Tcl's spi_prepare to accept full qualified type names in
< 	  the parameter type list

> 	o Fixed PL/Tcl's spi_prepare to accept full qualified type names in
> 	  the parameter type list

> * Have SHOW ALL and pg_settings show descriptions for server-side variables(Joe)

> * Allow LISTEN/NOTIFY to store info in memory rather than tables

* Allow major upgrades without dump/reload, perhaps using pg_upgrade

> * Issue NOTICE if foreign key data type doesn't match primary key