[COMMITTERS] pgsql-server: Improve pgindent processing of comment after 'else'.

2004-10-07 Thread Bruce Momjian
Log Message:
---
Improve pgindent processing of comment after 'else'.
Improve comment of pg_dump Win32 link workaround.

Modified Files:
--
pgsql-server/src/bin/pg_dump:
Makefile (r1.56 -> r1.57)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/pg_dump/Makefile.diff?r1=1.56&r2=1.57)
pgsql-server/src/tools/pgindent:
pgindent (r1.71 -> r1.72)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/tools/pgindent/pgindent.diff?r1=1.71&r2=1.72)

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[COMMITTERS] pgsql-server: re-add as binary

2004-10-07 Thread Bruce Momjian
Log Message:
---
re-add as binary

Removed Files:
-
pgsql-server/src/port:
win32.ico
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/port/win32.ico)

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


[COMMITTERS] pgsql-server: Add as binary mode

2004-10-07 Thread Bruce Momjian
Log Message:
---
Add as binary mode

Added Files:
---
pgsql-server/src/port:
win32.ico (r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/port/win32.ico?rev=1.3&content-type=text/x-cvsweb-markup)

---(end of broadcast)---
TIP 8: explain analyze is your friend


[COMMITTERS] pgsql-server: Indent comment pushed to new line by else so it is

2004-10-07 Thread Bruce Momjian
Log Message:
---
Indent comment pushed to new line by else so it is indented by BSD
indent.

Modified Files:
--
pgsql-server/src/backend/commands:
vacuum.c (r1.292 -> r1.293)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/commands/vacuum.c.diff?r1=1.292&r2=1.293)
pgsql-server/src/tools/pgindent:
pgindent (r1.72 -> r1.73)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/tools/pgindent/pgindent.diff?r1=1.72&r2=1.73)

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[COMMITTERS] pgsql-server: Back out unindented modification to file.

2004-10-07 Thread Bruce Momjian
Log Message:
---
Back out unindented modification to file.

Modified Files:
--
pgsql-server/src/backend/commands:
vacuum.c (r1.293 -> r1.294)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/commands/vacuum.c.diff?r1=1.293&r2=1.294)

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[COMMITTERS] pgsql-server: Adjust comments previously moved to column 1 by pgident.

2004-10-07 Thread Bruce Momjian
Log Message:
---
Adjust comments previously moved to column 1 by pgident.

Modified Files:
--
pgsql-server/contrib/dbase:
dbf.c (r1.6 -> r1.7)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/dbase/dbf.c.diff?r1=1.6&r2=1.7)
pgsql-server/contrib/fuzzystrmatch:
dmetaphone.c (r1.3 -> r1.4)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/fuzzystrmatch/dmetaphone.c.diff?r1=1.3&r2=1.4)
pgsql-server/contrib/intagg:
int_aggregate.c (r1.12 -> r1.13)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/intagg/int_aggregate.c.diff?r1=1.12&r2=1.13)
pgsql-server/contrib/spi:
refint.c (r1.26 -> r1.27)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/spi/refint.c.diff?r1=1.26&r2=1.27)
timetravel.c (r1.21 -> r1.22)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/spi/timetravel.c.diff?r1=1.21&r2=1.22)
pgsql-server/contrib/tablefunc:
tablefunc.c (r1.32 -> r1.33)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/tablefunc/tablefunc.c.diff?r1=1.32&r2=1.33)
pgsql-server/contrib/xml2:
xslt_proc.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/xml2/xslt_proc.c.diff?r1=1.2&r2=1.3)
pgsql-server/src/backend/access/transam:
xlog.c (r1.170 -> r1.171)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/access/transam/xlog.c.diff?r1=1.170&r2=1.171)
pgsql-server/src/backend/commands:
typecmds.c (r1.63 -> r1.64)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/commands/typecmds.c.diff?r1=1.63&r2=1.64)
pgsql-server/src/backend/optimizer/geqo:
geqo_ox2.c (r1.9 -> r1.10)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/optimizer/geqo/geqo_ox2.c.diff?r1=1.9&r2=1.10)
pgsql-server/src/backend/utils/adt:
acl.c (r1.111 -> r1.112)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/utils/adt/acl.c.diff?r1=1.111&r2=1.112)
inet_net_pton.c (r1.18 -> r1.19)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/utils/adt/inet_net_pton.c.diff?r1=1.18&r2=1.19)
rowtypes.c (r1.6 -> r1.7)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/utils/adt/rowtypes.c.diff?r1=1.6&r2=1.7)
pgsql-server/src/backend/utils/error:
elog.c (r1.151 -> r1.152)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/utils/error/elog.c.diff?r1=1.151&r2=1.152)
pgsql-server/src/bin/pg_ctl:
pg_ctl.c (r1.31 -> r1.32)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/pg_ctl/pg_ctl.c.diff?r1=1.31&r2=1.32)
pgsql-server/src/bin/pg_dump:
pg_backup_tar.c (r1.44 -> r1.45)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/pg_dump/pg_backup_tar.c.diff?r1=1.44&r2=1.45)
pgsql-server/src/bin/psql:
command.c (r1.125 -> r1.126)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/psql/command.c.diff?r1=1.125&r2=1.126)
pgsql-server/src/include/executor:
execdebug.h (r1.23 -> r1.24)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/executor/execdebug.h.diff?r1=1.23&r2=1.24)
pgsql-server/src/pl/plperl:
plperl.c (r1.52 -> r1.53)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plperl/plperl.c.diff?r1=1.52&r2=1.53)
pgsql-server/src/port:
exec.c (r1.28 -> r1.29)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/port/exec.c.diff?r1=1.28&r2=1.29)
getopt.c (r1.6 -> r1.7)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/port/getopt.c.diff?r1=1.6&r2=1.7)
pgsql-server/src/test/regress:
regress.c (r1.60 -> r1.61)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/test/regress/regress.c.diff?r1=1.60&r2=1.61)

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql-server: Prevent install error message when doing cmp on empty

2004-10-07 Thread Bruce Momjian
Log Message:
---
Prevent install error message when doing cmp on empty tree.

Modified Files:
--
pgsql-server/src/include:
Makefile (r1.13 -> r1.14)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/Makefile.diff?r1=1.13&r2=1.14)

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


[COMMITTERS] pgsql-server: Escape single quotes and backslashes used in locales

2004-10-07 Thread Bruce Momjian
Log Message:
---
Escape single quotes and backslashes used in locales placed in
postgresql.conf.

Zhong Xubin

Modified Files:
--
pgsql-server/src/bin/initdb:
initdb.c (r1.56 -> r1.57)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/initdb/initdb.c.diff?r1=1.56&r2=1.57)

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql-server: Update comment to fix nibble mention: * We are not sure

2004-10-07 Thread Bruce Momjian
Log Message:
---
Update comment to fix nibble mention:

 * We are not sure how much precision is in tv_usec, so we
 * swap the high and low 16 bits of 'later' and XOR them with
 * 'earlier'. On the off chance that the result is 0, we
 * loop until it isn't.

Greg Stark

Modified Files:
--
pgsql-server/src/backend/postmaster:
postmaster.c (r1.427 -> r1.428)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/postmaster/postmaster.c.diff?r1=1.427&r2=1.428)

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[COMMITTERS] pgsql-server: Remove unneeded dash.

2004-10-07 Thread Bruce Momjian
Log Message:
---
Remove unneeded dash.

Modified Files:
--
pgsql-server/src/backend/postmaster:
postmaster.c (r1.428 -> r1.429)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/postmaster/postmaster.c.diff?r1=1.428&r2=1.429)

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


[COMMITTERS] pgsql-server: Add one more byte to malloc for null storage.

2004-10-07 Thread Bruce Momjian
Log Message:
---
Add one more byte to malloc for null storage.

Modified Files:
--
pgsql-server/src/bin/initdb:
initdb.c (r1.57 -> r1.58)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/initdb/initdb.c.diff?r1=1.57&r2=1.58)

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[COMMITTERS] pginstaller - web: Fix some wording to be more clear and correct.

2004-10-07 Thread User Mha
Log Message:
---
Fix some wording to be more clear and correct.

Modified Files:
--
web:
FAQ_windows.html (r1.7 -> r1.8)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/web/FAQ_windows.html.diff?r1=1.7&r2=1.8)

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[COMMITTERS] pgsql-server: Fix problems with SQL functions returning rowtypes that

2004-10-07 Thread Tom Lane
Log Message:
---
Fix problems with SQL functions returning rowtypes that have dropped
columns.  The returned tuple needs to have appropriate NULL columns
inserted so that it actually matches the declared rowtype.  It seemed
convenient to use a JunkFilter for this, so I made some cleanups and
simplifications in the JunkFilter code to allow it to support this
additional functionality.  (That in turn exposed a latent bug in
nodeAppend.c, which is that it was returning a tuple slot whose
descriptor didn't match its data.)  Also, move check_sql_fn_retval
out of pg_proc.c and into functions.c, where it seems to more naturally
belong.

Modified Files:
--
pgsql-server/src/backend/catalog:
pg_proc.c (r1.119 -> r1.120)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/catalog/pg_proc.c.diff?r1=1.119&r2=1.120)
pgsql-server/src/backend/executor:
execJunk.c (r1.43 -> r1.44)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/executor/execJunk.c.diff?r1=1.43&r2=1.44)
execMain.c (r1.238 -> r1.239)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/executor/execMain.c.diff?r1=1.238&r2=1.239)
functions.c (r1.89 -> r1.90)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/executor/functions.c.diff?r1=1.89&r2=1.90)
nodeAppend.c (r1.60 -> r1.61)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/executor/nodeAppend.c.diff?r1=1.60&r2=1.61)
pgsql-server/src/backend/optimizer/util:
clauses.c (r1.181 -> r1.182)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/optimizer/util/clauses.c.diff?r1=1.181&r2=1.182)
pgsql-server/src/include/catalog:
pg_proc.h (r1.347 -> r1.348)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/catalog/pg_proc.h.diff?r1=1.347&r2=1.348)
pgsql-server/src/include/executor:
executor.h (r1.113 -> r1.114)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/executor/executor.h.diff?r1=1.113&r2=1.114)
functions.h (r1.22 -> r1.23)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/executor/functions.h.diff?r1=1.22&r2=1.23)
pgsql-server/src/include/nodes:
execnodes.h (r1.119 -> r1.120)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/nodes/execnodes.h.diff?r1=1.119&r2=1.120)

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[COMMITTERS] pgsql-server: Add PLperl workaround for Win32 to the *.xs file.

2004-10-07 Thread Bruce Momjian
Log Message:
---
Add PLperl workaround for Win32 to the *.xs file.

Modified Files:
--
pgsql-server/src/pl/plperl:
SPI.xs (r1.7 -> r1.8)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plperl/SPI.xs.diff?r1=1.7&r2=1.8)

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[COMMITTERS] pgsql-server: Add missing null terminator to escaped string; clean up

2004-10-07 Thread Tom Lane
Log Message:
---
Add missing null terminator to escaped string; clean up unnecessarily
obscurantist coding conventions.

Modified Files:
--
pgsql-server/src/bin/initdb:
initdb.c (r1.58 -> r1.59)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/initdb/initdb.c.diff?r1=1.58&r2=1.59)

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[COMMITTERS] pgsql-server: Move -DPLPERL_HAVE_UID_GID to the plperl Makefile, for

2004-10-07 Thread Bruce Momjian
Log Message:
---
Move  -DPLPERL_HAVE_UID_GID to the plperl Makefile, for Win32 only.

Modified Files:
--
pgsql-server/src/pl/plperl:
GNUmakefile (r1.15 -> r1.16)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plperl/GNUmakefile.diff?r1=1.15&r2=1.16)
SPI.xs (r1.8 -> r1.9)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plperl/SPI.xs.diff?r1=1.8&r2=1.9)
plperl.c (r1.53 -> r1.54)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plperl/plperl.c.diff?r1=1.53&r2=1.54)

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [COMMITTERS] pgsql-server: Add missing null terminator to escaped

2004-10-07 Thread Bruce Momjian

Thanks.  Wonder why my testing worked?  I guess xmalloc was giving me
zeroed memory.

---

Tom Lane wrote:
> Log Message:
> ---
> Add missing null terminator to escaped string; clean up unnecessarily
> obscurantist coding conventions.
> 
> Modified Files:
> --
> pgsql-server/src/bin/initdb:
> initdb.c (r1.58 -> r1.59)
> 
> (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/initdb/initdb.c.diff?r1=1.58&r2=1.59)
> 
> ---(end of broadcast)---
> TIP 9: the planner will ignore your desire to choose an index scan if your
>   joining column's datatypes do not match
> 

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [COMMITTERS] pgsql-server: Add missing null terminator to escaped

2004-10-07 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Thanks.  Wonder why my testing worked?  I guess xmalloc was giving me
> zeroed memory.

One-shot programs like initdb are very likely to see all-zeroed memory,
since that's what the kernel gives you.  It's only after you start
freeing things that you'll get nonzero areas from malloc ...

regards, tom lane

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[COMMITTERS] pginstaller - pginst: Update to work with WiX 2.0.2110.0: * Strict

2004-10-07 Thread User Mha
Log Message:
---
Update to work with WiX 2.0.2110.0:

* Strict checking of short names <= 8 characters, fix all other instances.
* Name and LongName can't both be used when they are identical. Also needed fix in the 
perl utility scripts.
* dash (-) not permitted in identifier.
* FileGroup element removed. Replaced with include files generated using new script 
buildflist.pl.
* Warned about a couple of components (shortcut to contrib docs, some Npgsql files in 
a subdir) that weren't attached to a feature - fixed.

This commit means WiX 2.0.2110 is now required to build the installer (I think).

Modified Files:
--
pginst:
Makefile (r1.20 -> r1.21)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/Makefile.diff?r1=1.20&r2=1.21)
pginst/util:
builddir.pl (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/util/builddir.pl.diff?r1=1.3&r2=1.4)
pginst/wxi:
Makefile (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/wxi/Makefile.diff?r1=1.5&r2=1.6)
pginst/wxs:
pginst.wxs (r1.73 -> r1.74)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/wxs/pginst.wxs.diff?r1=1.73&r2=1.74)

Added Files:
---
pginst/util:
buildflist.pl (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/util/buildflist.pl?rev=1.1&content-type=text/x-cvsweb-markup)

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[COMMITTERS] pginstaller - pginst: Fix psql shortcut when installation runs on a

2004-10-07 Thread User Mha
Log Message:
---
Fix psql shortcut when installation runs on a non-default port. Fixes bug 1000115.

Modified Files:
--
pginst/wxs:
pginst.wxs (r1.74 -> r1.75)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/wxs/pginst.wxs.diff?r1=1.74&r2=1.75)

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[COMMITTERS] pgsql-server: Remove mention of -Q option for bench.

2004-10-07 Thread Bruce Momjian
Log Message:
---
Remove mention of -Q option for bench.

Modified Files:
--
pgsql-server/src/test/bench:
runwisc.sh (r1.6 -> r1.7)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/test/bench/runwisc.sh.diff?r1=1.6&r2=1.7)

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[COMMITTERS] pgbuildfarm - client-code: fix logdir name typo

2004-10-07 Thread User Andrewd
Log Message:
---
fix logdir name typo

Modified Files:
--
client-code:
run_build.pl (r1.7 -> r1.8)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbuildfarm/client-code/run_build.pl.diff?r1=1.7&r2=1.8)

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[COMMITTERS] pgsql-server: Change get_rule_expr so that when the input is a List, it

2004-10-07 Thread Tom Lane
Log Message:
---
Change get_rule_expr so that when the input is a List, it displays the
list elements comma-separated instead of barfing.  This allows elimination
of half a dozen redundant copies of that behavior, and also makes the
world safe again for pg_get_expr() applied to pg_index.indexprs, per gripe
from Alexander Zhiltsov.

Modified Files:
--
pgsql-server/src/backend/utils/adt:
ruleutils.c (r1.181 -> r1.182)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/utils/adt/ruleutils.c.diff?r1=1.181&r2=1.182)

---(end of broadcast)---
TIP 8: explain analyze is your friend


[COMMITTERS] pgsql-server: Remove benchmark comment.

2004-10-07 Thread Bruce Momjian
Log Message:
---
Remove benchmark comment.

Modified Files:
--
pgsql-server/src/test/bench:
runwisc.sh (r1.7 -> r1.8)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/test/bench/runwisc.sh.diff?r1=1.7&r2=1.8)

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[COMMITTERS] pgsql-server: Do proper testing of CIDR bits against network mask, e.g.

2004-10-07 Thread Bruce Momjian
Log Message:
---
Do proper testing of CIDR bits against network mask, e.g. don't allow:

test=# select '204.248.199.1/31'::cidr;

Previous releases erroneously accepted such addresses.

WARN IN RELEASE NOTES

Kevin Brintnall

Modified Files:
--
pgsql-server/src/backend/utils/adt:
network.c (r1.53 -> r1.54)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/utils/adt/network.c.diff?r1=1.53&r2=1.54)

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[COMMITTERS] pgsql-server: Whack some sense into the configuration-file-location

2004-10-07 Thread Tom Lane
Log Message:
---
Whack some sense into the configuration-file-location patch.
Refactor code into something reasonably understandable, cause
use of the feature to not fail in standalone backends or in
EXEC_BACKEND case, fix sloppy guc.c table entries, make the
documentation minimally usable.

Modified Files:
--
pgsql-server/doc/src/sgml:
runtime.sgml (r1.285 -> r1.286)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/runtime.sgml.diff?r1=1.285&r2=1.286)
pgsql-server/doc/src/sgml/ref:
postgres-ref.sgml (r1.43 -> r1.44)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/ref/postgres-ref.sgml.diff?r1=1.43&r2=1.44)
postmaster.sgml (r1.52 -> r1.53)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/ref/postmaster.sgml.diff?r1=1.52&r2=1.53)
pgsql-server/src/backend/bootstrap:
bootstrap.c (r1.193 -> r1.194)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/bootstrap/bootstrap.c.diff?r1=1.193&r2=1.194)
pgsql-server/src/backend/libpq:
hba.c (r1.130 -> r1.131)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/libpq/hba.c.diff?r1=1.130&r2=1.131)
pgsql-server/src/backend/postmaster:
postmaster.c (r1.429 -> r1.430)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/postmaster/postmaster.c.diff?r1=1.429&r2=1.430)
pgsql-server/src/backend/tcop:
postgres.c (r1.433 -> r1.434)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/tcop/postgres.c.diff?r1=1.433&r2=1.434)
pgsql-server/src/backend/utils/misc:
guc-file.l (r1.25 -> r1.26)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/utils/misc/guc-file.l.diff?r1=1.25&r2=1.26)
guc.c (r1.239 -> r1.240)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/utils/misc/guc.c.diff?r1=1.239&r2=1.240)
postgresql.conf.sample (r1.130 -> r1.131)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/utils/misc/postgresql.conf.sample.diff?r1=1.130&r2=1.131)
pgsql-server/src/include/utils:
guc.h (r1.51 -> r1.52)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/utils/guc.h.diff?r1=1.51&r2=1.52)
guc_tables.h (r1.16 -> r1.17)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/utils/guc_tables.h.diff?r1=1.16&r2=1.17)

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[COMMITTERS] pgsql-server: Update CIDR regresion tests to test for network masks

2004-10-07 Thread Bruce Momjian
Log Message:
---
Update CIDR regresion tests to test for network masks inside the last
byte being tested, to catch any future breakage.

Modified Files:
--
pgsql-server/src/test/regress/expected:
inet.out (r1.18 -> r1.19)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/test/regress/expected/inet.out.diff?r1=1.18&r2=1.19)
pgsql-server/src/test/regress/sql:
inet.sql (r1.10 -> r1.11)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/test/regress/sql/inet.sql.diff?r1=1.10&r2=1.11)

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql-server: Add: * Consider parallel processing a single query

2004-10-07 Thread Bruce Momjian
Log Message:
---
Add:

* Consider parallel processing a single query

  This would involve using multiple threads or processes to do optimization,
  sorting, or execution of single query.  The major advantage of such a
  feature would be to allow multiple CPUs to work together to process a
  single query.

Modified Files:
--
pgsql-server/doc:
TODO (r1.1356 -> r1.1357)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/TODO.diff?r1=1.1356&r2=1.1357)

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[COMMITTERS] pgsql-server: Pull comment down into its own paragraph.

2004-10-07 Thread Bruce Momjian
Log Message:
---
Pull comment down into its own paragraph.

Modified Files:
--
pgsql-server/doc:
TODO (r1.1357 -> r1.1358)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/TODO.diff?r1=1.1357&r2=1.1358)

---(end of broadcast)---
TIP 8: explain analyze is your friend


[COMMITTERS] pgsql-server: Tweak HPUX shared-library build flags, per Shinji

2004-10-07 Thread Tom Lane
Log Message:
---
Tweak HPUX shared-library build flags, per Shinji Teragaito.

Modified Files:
--
pgsql-server/src:
Makefile.shlib (r1.78 -> r1.79)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/Makefile.shlib.diff?r1=1.78&r2=1.79)

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]