[COMMITTERS] pgsql: Support rewritten-based full vacuum as VACUUM FULL.

2010-01-05 Thread Takahiro Itagaki
Log Message: --- Support rewritten-based full vacuum as VACUUM FULL. Traditional VACUUM FULL was renamed to VACUUM FULL INPLACE. Also added a new option -i, --inplace for vacuumdb to perform FULL INPLACE vacuuming. Since the new VACUUM FULL uses CLUSTER infrastructure, we cannot use it for

[COMMITTERS] pg-migrator - pg_migrator: Support new backend API to preserve

2010-01-05 Thread User Bmomjian
Log Message: --- Support new backend API to preserve relfilenodes, avoiding complex toast renaming for 8.5. Modified Files: -- pg_migrator: INSTALL (r1.52 -> r1.53) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pg-migrator/pg_migrator/INSTALL?r1=1.52&r2=1.53

[COMMITTERS] pg-migrator - pg_migrator: Support new backend API to preserve

2010-01-05 Thread User Bmomjian
Log Message: --- Support new backend API to preserve relfilenodes, avoiding complex toast renaming for 8.5. Modified Files: -- pg_migrator/func: Makefile (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pg-migrator/pg_migrator/func/Makefile?r1=1.

[COMMITTERS] pgsql: binary upgrade: Preserve relfilenodes for views and composite

2010-01-05 Thread Bruce Momjian
Log Message: --- binary upgrade: Preserve relfilenodes for views and composite types --- even though we don't store data in, them, they do consume relfilenodes. Bump catalog version. Modified Files: -- pgsql/src/backend/catalog: heap.c (r1.365 -> r1.366)

[COMMITTERS] pgsql: Remove erroneous comma added to pg_dumpall tablespace query when

2010-01-05 Thread Bruce Momjian
Log Message: --- Remove erroneous comma added to pg_dumpall tablespace query when running with PG version 8.2-8.4. Modified Files: -- pgsql/src/bin/pg_dump: pg_dumpall.c (r1.130 -> r1.131) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_d

[COMMITTERS] pgsql: Update catalog version for recent relfilenode patch, so

2010-01-05 Thread Bruce Momjian
Log Message: --- Update catalog version for recent relfilenode patch, so pg_migrator can identify the new API. Modified Files: -- pgsql/src/include/catalog: catversion.h (r1.567 -> r1.568) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/

[COMMITTERS] pgsql: Preserve relfilenodes: Add support to pg_dump --binary-upgrade

2010-01-05 Thread Bruce Momjian
Log Message: --- Preserve relfilenodes: Add support to pg_dump --binary-upgrade to preserve all relfilenodes, for use by pg_migrator. Modified Files: -- pgsql/src/backend/catalog: heap.c (r1.364 -> r1.365) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/sr

[COMMITTERS] pgsql: pg_dump --only-analyze Implement pg_dump --only-analyze for use

2010-01-05 Thread Bruce Momjian
Log Message: --- pg_dump --only-analyze Implement pg_dump --only-analyze for use by pg_migrator to only analyze all databases. Modified Files: -- pgsql/doc/src/sgml/ref: vacuumdb.sgml (r1.45 -> r1.46) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src

[COMMITTERS] pgsql: Remove tabs in SGML.

2010-01-05 Thread Bruce Momjian
Log Message: --- Remove tabs in SGML. Move OIDCHARS to proper include file. Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.242 -> r1.243) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml?r1=1.242&r2=1.243) pgsql/src/backe

[COMMITTERS] pgsql: Use OIDCHARS: Use OIDCHARS for oid character length, rather than

2010-01-05 Thread Bruce Momjian
Log Message: --- Use OIDCHARS: Use OIDCHARS for oid character length, rather than '10', in tablespace code. Modified Files: -- pgsql/src/backend/commands: tablespace.c (r1.66 -> r1.67) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/ta

[COMMITTERS] pgsql: Adjust headers to allow pgbench to be built with PGXS.

2010-01-05 Thread Takahiro Itagaki
Log Message: --- Adjust headers to allow pgbench to be built with PGXS. Modified Files: -- pgsql/contrib/pgbench: pgbench.c (r1.95 -> r1.96) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/pgbench/pgbench.c?r1=1.95&r2=1.96) -- Sent via pgsql-commi

[COMMITTERS] pgsql: Add verification of variable names in pgbench.

2010-01-05 Thread Takahiro Itagaki
Log Message: --- Add verification of variable names in pgbench. Variables must consist of only alphabets, numerals and underscores. We had allowed to set variables with invalid names, but could not refer them in queries. Thanks to Robert Haas for the review. Modified Files: -

[COMMITTERS] pgsql: Add support for doing FULL JOIN ON FALSE.

2010-01-05 Thread Tom Lane
Log Message: --- Add support for doing FULL JOIN ON FALSE. While this is really a rather peculiar variant of UNION ALL, and so wouldn't likely get written directly as-is, it's possible for it to arise as a result of simplification of less-obviously-silly queries. In particular, now that w

[COMMITTERS] pgsql: Add support for doing FULL JOIN ON FALSE.

2010-01-05 Thread Tom Lane
Log Message: --- Add support for doing FULL JOIN ON FALSE. While this is really a rather peculiar variant of UNION ALL, and so wouldn't likely get written directly as-is, it's possible for it to arise as a result of simplification of less-obviously-silly queries. In particular, now that w

[COMMITTERS] pgsql: Support ALTER TABLESPACE name SET/RESET ( tablespace_options ).

2010-01-05 Thread Robert Haas
Log Message: --- Support ALTER TABLESPACE name SET/RESET ( tablespace_options ). This patch only supports seq_page_cost and random_page_cost as parameters, but it provides the infrastructure to scalably support many more. In particular, we may want to add support for effective_io_concurren

[COMMITTERS] pgsql: Fix genbki.pl and Gen_fmgrtab.pl to use PID-specific temp file

2010-01-05 Thread Tom Lane
Log Message: --- Fix genbki.pl and Gen_fmgrtab.pl to use PID-specific temp file names, so that it's safe if a parallel make chooses to run two concurrent copies. Also, work around a memory leak in some versions of Perl. Modified Files: -- pgsql/src/backend/catalog:

Re: [COMMITTERS] pgsql: And another one

2010-01-05 Thread Magnus Hagander
This kind of commit message is pretty much useless. If you want to do a git blame/cvs annotate/whatever later, it gives exactly zero information. Isn't it better to just reuse the previous commit message? That will also allow tools to group the commits together (if you're lucky, they might even sh

[COMMITTERS] pgsql: And another one

2010-01-05 Thread Michael Meskes
Log Message: --- And another one Modified Files: -- pgsql/src/interfaces/ecpg/include: pgtypes_numeric.h (r1.16 -> r1.17) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/include/pgtypes_numeric.h?r1=1.16&r2=1.17) pgsql/src/interfaces

[COMMITTERS] pgsql: And another one of the same problem.

2010-01-05 Thread Michael Meskes
Log Message: --- And another one of the same problem. Modified Files: -- pgsql/src/interfaces/ecpg/include: sqltypes.h (r1.10 -> r1.11) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/include/sqltypes.h?r1=1.10&r2=1.11) pgsql/src/int

[COMMITTERS] pgsql: And then forgot to commit the fixed files.

2010-01-05 Thread Michael Meskes
Log Message: --- And then forgot to commit the fixed files. ARGH! Modified Files: -- pgsql/src/interfaces/ecpg/test/expected: compat_informix-sqlda.c (r1.5 -> r1.6) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/compat_inf

[COMMITTERS] pgsql: Ah, should read the file completely.

2010-01-05 Thread Michael Meskes
Log Message: --- Ah, should read the file completely. I got so used to git that I almost forgot about the cvs stuff. Modified Files: -- pgsql/src/interfaces/ecpg/include: sqlda.h (r1.5 -> r1.6) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces

[COMMITTERS] pgsql: Thrid try.

2010-01-05 Thread Michael Meskes
Log Message: --- Thrid try. It seems my two checkouts need some cleaning up. Modified Files: -- pgsql/src/interfaces/ecpg/test/expected: compat_informix-sqlda.c (r1.3 -> r1.4) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected

[COMMITTERS] pgsql: Still not correct.

2010-01-05 Thread Michael Meskes
Log Message: --- Still not correct. Modified Files: -- pgsql/src/interfaces/ecpg/test/expected: compat_informix-sqlda.c (r1.2 -> r1.3) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/compat_informix-sqlda.c?r1=1.2&r2=1.3)

[COMMITTERS] pgsql: Adjusted CVS headers.

2010-01-05 Thread Michael Meskes
Log Message: --- Adjusted CVS headers. Modified Files: -- pgsql/src/interfaces/ecpg/test/expected: compat_informix-sqlda.c (r1.1 -> r1.2) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/compat_informix-sqlda.c?r1=1.1&r2=1.2

[COMMITTERS] pgsql: Applied patch by Boszormenyi Zoltan to add sqlda

2010-01-05 Thread Michael Meskes
Log Message: --- Applied patch by Boszormenyi Zoltan to add sqlda support to ecpg in both native and compatiblity mode. Modified Files: -- pgsql/src/interfaces/ecpg/ecpglib: Makefile (r1.65 -> r1.66) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/inte

[COMMITTERS] plproxy - plproxy: Regression tests for SQL/MED.

2010-01-05 Thread User Mpihlak
Log Message: --- Regression tests for SQL/MED. Added Files: --- plproxy/expected: plproxy_sqlmed.out (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plproxy/plproxy/expected/plproxy_sqlmed.out?rev=1.1&content-type=text/x-cvsweb-markup) plproxy/sql:

[COMMITTERS] plproxy - plproxy: Enable pl/proxy clusters to be defined by SQL/MED

2010-01-05 Thread User Mpihlak
Log Message: --- Enable pl/proxy clusters to be defined by SQL/MED facilities. Provide a plproxy foreign data wrapper and a function for validating cluster definitions. It is still possible to define clusters using configuration functions, however SQL/MED cluster definition takes precedence

[COMMITTERS] pgsql: Move the default configuration for the MSVC build system to

2010-01-05 Thread Magnus Hagander
Log Message: --- Move the default configuration for the MSVC build system to config_default.pl, and allow using config.pl to override the defaults. config.pl is removed from the repository, so changes there will no longer show up when doing diff, and will not prevent switching branches and

[COMMITTERS] pgsql: Disable linker warning 4197 on Win64, that is caused by the fact

2010-01-05 Thread Magnus Hagander
Log Message: --- Disable linker warning 4197 on Win64, that is caused by the fact that we export symbols both using __declspec(dllexport) (via the PGDLLIMPORT macro) and using full-dll-export. This works without warning on Win32, but not on Win64. In passing, fix the fact that the framewor

[COMMITTERS] pgsql: Use _mm_pause() for win64 spin_delay(), per note from Tsutomu

2010-01-05 Thread Magnus Hagander
Log Message: --- Use _mm_pause() for win64 spin_delay(), per note from Tsutomu Yamada. Modified Files: -- pgsql/src/include/storage: s_lock.h (r1.170 -> r1.171) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/s_lock.h?r1=1.170&r2=1.171)