types in a category --- it was taking the last preferred type among the
inputs, rather than the first one as intended.

src/interfaces/odbc/GNUmakefile.

flawed because the timestamp file is already updated when Makefile.global
is remade, and the rule for config.h never gets run.

database' was way too small to make a chapter).  Add a section about
using JOIN syntax to direct the planner.

Index: TODO
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/TODO,v
retrieving revision 1.305
diff -r1.305 TODO
3c3
< Last updated:		Fri Dec 15 17:40:22 EST 2000
---
> Last updated:		Fri Dec 15 17:44:57 EST 2000
312a313
> 	* Mark is Mark Hollomon <mhh@mindspring.com>
326a328
> ›5~

Index: TODO
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/TODO,v
retrieving revision 1.304
diff -r1.304 TODO
3c3
< Last updated:		Fri Dec 15 17:03:28 EST 2000
---
> Last updated:		Fri Dec 15 17:40:22 EST 2000
318a319
> 	* Ross is Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>

Index: TODO
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/TODO,v
retrieving revision 1.303
diff -r1.303 TODO
3c3
< Last updated:		Fri Dec 15 16:46:43 EST 2000
---
> Last updated:		Fri Dec 15 17:03:28 EST 2000
319a320
>  	* Stephan is Stephan Szabo <sszabo@megazone23.bigpanda.com>

Index: TODO
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/TODO,v
retrieving revision 1.302
diff -r1.302 TODO
3c3
< Last updated:		Tue Dec 12 23:01:53 EST 2000
---
> Last updated:		Fri Dec 15 16:46:43 EST 2000

Index: TODO
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/TODO,v
retrieving revision 1.301
diff -r1.301 TODO
306d305
< 	* Bryan is Bryan Henderson<bryanh@giraffe.netgate.net>
308d306
< 	* David is David Hartwig <daveh@insightdist.com>
311c309,310
< 	* Hiroshi is Hiroshi Inoue<Inoue@tpf.co.jp>
---
> 	* Hiroshi is Hiroshi Inoue <Inoue@tpf.co.jp>
> 	* Karel is Karel Zak <zakkr@zf.jcu.cz>
314c313
< 	* Massimo Dal Zotto <dz@cs.unitn.it>
---
> 	* Massimo is Massimo Dal Zotto <dz@cs.unitn.it>
318c317
< 	* Philip Warner <pjw@rhyme.com.au>
---
> 	* Philip is Philip Warner <pjw@rhyme.com.au>
321d319
< 	* Stefan Simkovics <ssimkovi@rainbow.studorg.tuwien.ac.at>
326c324
< 	* Vadim is "Vadim B. Mikheev" <vadim4o@email.com>
---
> 	* Vadim is Vadim B. Mikheev <vadim4o@email.com>

WARNING.  Fix German FAQ mention about warning.

insensitive to the order of arguments.  Per pghackers discussion 12/10/00.

> Date: Thu, 14 Dec 2000 12:44:47 +0100 (CET)
> From: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
> To: pgsql-bugs@postgresql.org
> Subject: [BUGS] to_char() causes backend to close connection
>
> Hi, this query gives different strange results:
>
> select to_char(now()::abstime,'YYMMDDHH24MI');
>
> I get e.g. a "backend closed the channel unexpectedly..." error with
> successful or failed resetting attempt (indeterministic)

 Again thanks Kovacs, you found really designing bug, that appear
if anyone write bad format template to "number" version of to_char()
(as you with 'DD').

                                        Karel

if we set autocommit off and issued COMMIT (or ROLLBACK) on a connection
new transaction is not started

Max Khon

(intermediate .o file gets deleted and rebuild on next make invocation).

backend crash.

Trying to connect to template0 left a global referenced buffer
because the scan of pg_database wasn't ended properly before
elog(FATAL).

Jan

comparison does not consider paths different when they differ only in
uninteresting aspects of sort order.  (We had a special case of this
consideration for indexscans already, but generalize it to apply to
ordered join paths too.)  Be stricter about what is a canonical pathkey
to allow faster pathkey comparison.  Cache canonical pathkeys and
dispersion stats for left and right sides of a RestrictInfo's clause,
to avoid repeated computation.  Total speedup will depend on number of
tables in a query, but I see about 4x speedup of planning phase for
a sample seven-table query.

OIDs rather than names.  Aside from being simpler and faster, this way
doesn't blow up in the face of 'create temp table foo () inherits (foo)'.
Which is a rather odd thing to do, but it seems some people want to.

output first outer tuple before advancing...

Index: TODO
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/TODO,v
retrieving revision 1.300
diff -r1.300 TODO
3c3
< Last updated:		Tue Dec 12 23:01:04 EST 2000
---
> Last updated:		Tue Dec 12 23:01:53 EST 2000
21d20
< * test to show diffs for TODO changes

Index: TODO
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/TODO,v
retrieving revision 1.299
diff -r1.299 TODO
3c3
< Last updated:		Tue Dec 12 15:27:50 EST 2000
---
> Last updated:		Tue Dec 12 23:01:04 EST 2000
20a21
> * test to show diffs for TODO changes

avoid repeated evaluations in cost_qual_eval().  This turns out to save
a useful fraction of planning time.  No change to external representation
of RestrictInfo --- although that node type doesn't appear in stored
rules anyway.

the first paragraph:

    As an example, say we wish to find all the records that
    are in the  temperature  range  of  other records. In
    effect, we need to compare the temp_lo and temp_hi
    attributes of each EMP instance to the temp_lo and
    temp_hi  attributes of all other EMP instances.

I believe that EMP should read WEATHER, as the example query that
follows joins WEATHER to itself.

EMP is often used in Oracle examples.

Regards,
Graham

Other RULE cleanups

ISO-compliant UNION/INTERSECT/EXCEPT.  Revise discussion of rule
rewriter to reflect new subselect-in-FROM implementation of views.
Miscellaneous other cleanups.