Re: [COMMITTERS] pgsql: Add INET/CIDR operators: and, or, not, plus int8, minus int8, and

2006-02-11 Thread Tom Lane
[EMAIL PROTECTED] (Bruce Momjian) writes: > Log Message: > --- > Add INET/CIDR operators: and, or, not, plus int8, minus int8, and inet > minus inet. Shouldn't this commit have included a catversion.h bump? regards, tom lane ---(end of broa

[COMMITTERS] pgsql: Update catalog version for INET additions.

2006-02-11 Thread Bruce Momjian
Log Message: --- Update catalog version for INET additions. Modified Files: -- pgsql/src/include/catalog: catversion.h (r1.313 -> r1.314) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.313&r2=1.314) ---

Re: [COMMITTERS] pgsql: Add INET/CIDR operators: and, or, not, plus

2006-02-11 Thread Bruce Momjian
Tom Lane wrote: > [EMAIL PROTECTED] (Bruce Momjian) writes: > > Log Message: > > --- > > Add INET/CIDR operators: and, or, not, plus int8, minus int8, and inet > > minus inet. > > Shouldn't this commit have included a catversion.h bump? Yes, just done. I mentioned it in the posting but f

[COMMITTERS] pgsql: Allow VACUUM to complete faster by avoiding scanning the indexes

2006-02-11 Thread Bruce Momjian
Log Message: --- Allow VACUUM to complete faster by avoiding scanning the indexes when no rows were removed from the heap by the VACUUM. Simon Riggs Modified Files: -- pgsql/src/backend/access/gist: gistvacuum.c (r1.11 -> r1.12) (http://developer.postgresq

Re: [COMMITTERS] pgsql: Allow VACUUM to complete faster by avoiding scanning the indexes

2006-02-11 Thread Tom Lane
[EMAIL PROTECTED] (Bruce Momjian) writes: > Log Message: > --- > Allow VACUUM to complete faster by avoiding scanning the indexes when no > rows were removed from the heap by the VACUUM. I didn't see that go by, and request it be reverted. This has consequences that I do not think Simon u

[COMMITTERS] pgsql: Revert based on Tom's recommendation: > Allow VACUUM to complete

2006-02-11 Thread Bruce Momjian
Log Message: --- Revert based on Tom's recommendation: > Allow VACUUM to complete faster by avoiding scanning the indexes when no > rows were removed from the heap by the VACUUM. Modified Files: -- pgsql/src/backend/access/gist: gistvacuum.c (r1.12 -> r1.13)

[COMMITTERS] pgfouine - pgfouine: PHP 5.1 fixes

2006-02-11 Thread User Gsmet
Log Message: --- PHP 5.1 fixes Modified Files: -- pgfouine/include/reporting: HtmlWithGraphsReportAggregator.class.php (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/HtmlWithGraphsReportAggregator.class.php.d

[COMMITTERS] pgfouine - pgfouine: PHP 5.1 fixes

2006-02-11 Thread User Gsmet
Log Message: --- PHP 5.1 fixes Modified Files: -- pgfouine/include/listeners/error: NormalizedErrorsListener.class.php (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/listeners/error/NormalizedErrorsListener.class.php.d

[COMMITTERS] pgfouine - pgfouine: changed error_reporting level for php 4.4

2006-02-11 Thread User Gsmet
Log Message: --- changed error_reporting level for php 4.4 Modified Files: -- pgfouine: pgfouine.php (r1.24 -> r1.25) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/pgfouine.php.diff?r1=1.24&r2=1.25) ---(end of broad

[COMMITTERS] pgfouine - pgfouine: let's release 0.4.99 for PHP 5.1 users

2006-02-11 Thread User Gsmet
Log Message: --- let's release 0.4.99 for PHP 5.1 users Modified Files: -- pgfouine: pgfouine.spec (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/pgfouine.spec.diff?r1=1.4&r2=1.5) pgfouine.php (r1.25 -> r1.26)

[COMMITTERS] pgfouine - www: New Directory

2006-02-11 Thread User Gsmet
Update of /cvsroot/pgfouine/www/reports In directory pgfoundry.org:/tmp/cvs-serv93976/reports Log Message: Directory /cvsroot/pgfouine/www/reports added to the repository ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please sen

[COMMITTERS] pgfouine - www: updated website

2006-02-11 Thread User Gsmet
Log Message: --- updated website Modified Files: -- www: tutorial.html (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/www/tutorial.html.diff?r1=1.1&r2=1.2) reports.html (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/

[COMMITTERS] pgfouine - www:

2006-02-11 Thread User Gsmet
Log Message: --- Modified Files: -- www: index.html (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/www/index.html.diff?r1=1.8&r2=1.9) ---(end of broadcast)--- TIP 9: In versions below 8

[COMMITTERS] pgfouine - www: fixed last example

2006-02-11 Thread User Gsmet
Log Message: --- fixed last example Modified Files: -- www: reports.html (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/www/reports.html.diff?r1=1.2&r2=1.3) ---(end of broadcast)--- TIP

[COMMITTERS] pgfouine - www: reorganized samples

2006-02-11 Thread User Gsmet
Log Message: --- reorganized samples Removed Files: - www: sample_only_select.html (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/www/sample_only_select.html) sample_default.html (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/

Re: [COMMITTERS] pgsql: Add INET/CIDR operators: and, or, not, plus

2006-02-11 Thread Tom Lane
Actually this patch has got some worse problems: regression=# select '127.0.0.1'::inet + 256; ?column? --- 127.0.2.1 (1 row) which is wrong; if that's not obvious try regression=# select ('127.0.0.1'::inet + 256) - 256; ?column? --- 127.0.1.1 (1 row) or regression=# sel

[COMMITTERS] pgsql: Fix incorrect addition, subtraction, and overflow checking in new

2006-02-11 Thread Tom Lane
Log Message: --- Fix incorrect addition, subtraction, and overflow checking in new inet operators. Modified Files: -- pgsql/src/backend/utils/adt: network.c (r1.64 -> r1.65) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/network.c.d

[COMMITTERS] pgsql: o Improve psql's handling of multi-line statements Currently,

2006-02-11 Thread Bruce Momjian
Log Message: --- o Improve psql's handling of multi-line statements Currently, while \e saves a single statement as one entry, interactive statements are saved one line at a time. Ideally all statements would be saved like \e does. Sergey E. Koposov Modified File

[COMMITTERS] pgsql: Done: > o -Allow ALTER TABLE ...

2006-02-11 Thread Bruce Momjian
Log Message: --- Done: > o -Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME Modified Files: -- pgsql/doc: TODO (r1.1762 -> r1.1763) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1762&r2=1.1763) pgsql/doc/src/FAQ: T

[COMMITTERS] pgsql: Allow ALTER TABLE ...

2006-02-11 Thread Bruce Momjian
Log Message: --- Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME Joachim Wieland Modified Files: -- pgsql/doc/src/sgml: ddl.sgml (r1.52 -> r1.53) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ddl.sgml.diff?r1=1.52&r2=1.53) pgsql/doc/

[COMMITTERS] pgsql: Done: < o Improve psql's handling of multi-line statements > o

2006-02-11 Thread Bruce Momjian
Log Message: --- Done: < o Improve psql's handling of multi-line statements > o -Improve psql's handling of multi-line statements Modified Files: -- pgsql/doc: TODO (r1.1761 -> r1.1762) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO

[COMMITTERS] pgsql: Skip ambulkdelete scan if there's nothing to delete and the index

2006-02-11 Thread Tom Lane
Log Message: --- Skip ambulkdelete scan if there's nothing to delete and the index is not partial. None of the existing AMs do anything useful except counting tuples when there's nothing to delete, and we can get a tuple count from the heap as long as it's not a partial index. (hash actua

[COMMITTERS] pgsql: Actually there's a better way to do this, which is to count

2006-02-11 Thread Tom Lane
Log Message: --- Actually there's a better way to do this, which is to count tuples during the vacuumcleanup scan that we're going to do anyway. Should save a few cycles (one calculation per page, not per tuple) as well as not having to depend on assumptions about heap and index being in s

Re: [COMMITTERS] pgsql: Allow ALTER TABLE ...

2006-02-11 Thread Tom Lane
[EMAIL PROTECTED] (Bruce Momjian) writes: > Log Message: > --- > Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME This patch appears seriously broken, in particular every routine I looked at contained incorrect locking assumptions. Nor do I care for using pg_depend for the purposes it's

[COMMITTERS] pgfouine - www:

2006-02-11 Thread User Gsmet
Log Message: --- Modified Files: -- www: index.html (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/www/index.html.diff?r1=1.9&r2=1.10) ---(end of broadcast)--- TIP 6: explain analyze i

[COMMITTERS] python - fe: Use the UnicodeType as the base for the String typing.

2006-02-11 Thread James William Pye
Log Message: --- Use the UnicodeType as the base for the String typing. Modified Files: -- fe/src: abstract.py (r1.1.1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/fe/src/abstract.py.diff?r1=1.1.1.1&r2=1.2) ---(end

[COMMITTERS] python - fe: Use "x is [not] None" conditionals to help speed things

2006-02-11 Thread James William Pye
Log Message: --- Use "x is [not] None" conditionals to help speed things along. Modified Files: -- fe/src: tracenull.py (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/fe/src/tracenull.py.diff?r1=1.3&r2=1.4) ---(e

[COMMITTERS] pgsql: Please find enclosed a patch that lets you use \c to connect

2006-02-11 Thread Bruce Momjian
Log Message: --- Please find enclosed a patch that lets you use \c to connect (optionally) to a new host and port without exiting psql. This eliminates, IMHO, a surprise in that you can now connect to PostgreSQL on a differnt machine from the one where you started your session. This should

[COMMITTERS] pgsql: Restore previous psql behavior of not printing useless trailing

2006-02-11 Thread Tom Lane
Log Message: --- Restore previous psql behavior of not printing useless trailing spaces after the data in the last column on a line. Modified Files: -- pgsql/src/bin/psql: print.c (r1.82 -> r1.83) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/ps

[COMMITTERS] pgsql: Undo changes of trailing space in recently-committed expected

2006-02-11 Thread Tom Lane
Log Message: --- Undo changes of trailing space in recently-committed expected files. This is mostly just over-compulsiveness on my part, but the exercise did reveal one real bug: errors.out has a space difference now where it should not. Modified Files: -- pgsql/src/test/r

[COMMITTERS] pgsql: I've created a new shared catalog table pg_shdescription to store

2006-02-11 Thread Bruce Momjian
Log Message: --- I've created a new shared catalog table pg_shdescription to store comments on cluster global objects like databases, tablespaces, and roles. It touches a lot of places, but not much in the way of big changes. The only design decision I made was to duplicate the query and

[COMMITTERS] pgsql: New Directory

2006-02-11 Thread Bruce Momjian
Update of /cvsroot/pgsql/contrib/pg_freespacemap In directory postgresql.org:/var/tmp/cvs-serv69212/pg_freespacemap Log Message: Directory /cvsroot/pgsql/contrib/pg_freespacemap added to the repository ---(end of broadcast)--- TIP 4: Have you searc

[COMMITTERS] pgsql: Fix more fallout from line-wrap patch, to wit, arbitrarily

2006-02-11 Thread Tom Lane
Log Message: --- Fix more fallout from line-wrap patch, to wit, arbitrarily changing the API of PQdsplen without bothering to fix its callers. Although ReportSyntaxErrorPosition could probably do with more smarts about handling control characters, for the moment I'll just get it back to ha

[COMMITTERS] python - fe: Clients can get PANIC ereports too.

2006-02-11 Thread James William Pye
Log Message: --- Clients can get PANIC ereports too. These are just as FATAL as 'FATAL'. Modified Files: -- fe/src: tracenull.py (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/fe/src/tracenull.py.diff?r1=1.4&r2=1.5)

[COMMITTERS] pgsql: Add contrib/pg_freespacemap to display free space map

2006-02-11 Thread Bruce Momjian
Log Message: --- Add contrib/pg_freespacemap to display free space map information. Mark Kirkwood Modified Files: -- pgsql/contrib: Makefile (r1.61 -> r1.62) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/Makefile.diff?r1=1.61&r2=1.62) R

[COMMITTERS] pgsql: Done: > * -Add system view to show free space map contents

2006-02-11 Thread Bruce Momjian
Log Message: --- Done: > * -Add system view to show free space map contents Modified Files: -- pgsql/doc: TODO (r1.1763 -> r1.1764) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1763&r2=1.1764) pgsql/doc/src/FAQ: TODO.htm

[COMMITTERS] pgsql: Add psql option: -1 or --single-transaction Simon Riggs

2006-02-11 Thread Bruce Momjian
Log Message: --- Add psql option: -1 or --single-transaction Simon Riggs Modified Files: -- pgsql/doc/src/sgml/ref: pg_restore.sgml (r1.56 -> r1.57) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/pg_restore.sgml.diff?r1=1.56&r2

[COMMITTERS] pgsql: As part of previous commit, add pg_restore option: -1 or

2006-02-11 Thread Bruce Momjian
Log Message: --- As part of previous commit, add pg_restore option: -1 or --single-transaction Simon Riggs Modified Files: -- pgsql/src/bin/pg_dump: pg_restore.c (r1.74 -> r1.75) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg

[COMMITTERS] pgsql: Allow to_char() to print localized month and day names.

2006-02-11 Thread Bruce Momjian
Log Message: --- Allow to_char() to print localized month and day names. Euler Taveira de Oliveira Modified Files: -- pgsql/doc/src/sgml: func.sgml (r1.305 -> r1.306) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.305&r2

[COMMITTERS] pgsql: Done: > * -Allow to_char() to print localized month names

2006-02-11 Thread Bruce Momjian
Log Message: --- Done: > * -Allow to_char() to print localized month names Modified Files: -- pgsql/doc: TODO (r1.1764 -> r1.1765) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1764&r2=1.1765) pgsql/doc/src/FAQ: TODO.html

[COMMITTERS] pgsql: Clean up plpgsql grammar to make sure that check_assignable() is

2006-02-11 Thread Tom Lane
Log Message: --- Clean up plpgsql grammar to make sure that check_assignable() is applied consistently. This is mostly cosmetic right at the moment because check_assignable() does nothing for ROW or RECORD datums, but that might not always be so. This also syncs several different places t

[COMMITTERS] pgsql: Use 0x01 for newlines in saved history.

2006-02-11 Thread Bruce Momjian
Log Message: --- Use 0x01 for newlines in saved history. It was determined to be not used by multi-byte sequences, but futher invesetigation might prove this to be false. Modified Files: -- pgsql/src/bin/psql: input.c (r1.47 -> r1.48) (http://developer.pos

[COMMITTERS] python - fe: Fix dead-end detection.

2006-02-11 Thread James William Pye
Log Message: --- Fix dead-end detection. This resolves Proboscis' failure to detect the death of the remote end[1]. This can occur if the backend segfaults out; while this won't normally happen, if it does, Python's process use will go through the roof in an infinite loop. An earlier patch

[COMMITTERS] pgsql: Allow PL/pgSQL FOR statement to return values to scalars as well

2006-02-11 Thread Bruce Momjian
Log Message: --- Allow PL/pgSQL FOR statement to return values to scalars as well as records and row types. Pavel Stehule Modified Files: -- pgsql/doc/src/sgml: plpgsql.sgml (r1.84 -> r1.85) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/pl

[COMMITTERS] pgsql: Add MSVC support for utility commands and pg_dump.

2006-02-11 Thread Bruce Momjian
Log Message: --- Add MSVC support for utility commands and pg_dump. Hiroshi Saito Modified Files: -- pgsql/doc/src/sgml: install-win32.sgml (r1.26 -> r1.27) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/install-win32.sgml.diff?r1=1.26&r2=1

[COMMITTERS] dbi-link - dbi-link: Makefile.PL opens the door to tests.

2006-02-11 Thread User Dfetter
Log Message: --- Makefile.PL opens the door to tests. Kudos to Fred Moyer for coming up with this. Added Files: --- dbi-link: Makefile.PL (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbi-link/dbi-link/Makefile.PL?rev=1.1&content-type=text/x-cvsweb-marku

[COMMITTERS] pgsql: Apply code-reviewed version of for-scalar-list patch: mostly,

2006-02-11 Thread Tom Lane
Log Message: --- Apply code-reviewed version of for-scalar-list patch: mostly, fixing it to report reasonable errors in error cases. Modified Files: -- pgsql/doc/src/sgml: plpgsql.sgml (r1.85 -> r1.86) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/s

[COMMITTERS] pgsql: Done: > * -Add COMMENT ON for all cluster global objects (roles,

2006-02-11 Thread Bruce Momjian
Log Message: --- Done: > * -Add COMMENT ON for all cluster global objects (roles, databases Modified Files: -- pgsql/doc: TODO (r1.1765 -> r1.1766) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1765&r2=1.1766) pgsql/doc/src/FAQ:

[COMMITTERS] pgsql: List psql tab completion for various default keywords.

2006-02-11 Thread Bruce Momjian
Log Message: --- List psql tab completion for various default keywords. Joachim Wieland Modified Files: -- pgsql/src/bin/psql: tab-complete.c (r1.146 -> r1.147) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/tab-complete.c.diff?r1=1.146&r2=

[COMMITTERS] pgsql: When performing a parallel build (make -j N) with ./configure

2006-02-11 Thread Bruce Momjian
Log Message: --- When performing a parallel build (make -j N) with ./configure --enable-depend it often tries to create the .deps directory twice and bails out when it already exists due to a race condition of if doesn't exist, then create. This patch prevents mkdir from returning an error