]> granicus.if.org Git - postgresql/log
postgresql
22 years agoUpdates to reflect availability of autocommit option.
Tom Lane [Fri, 30 Aug 2002 22:45:25 +0000 (22:45 +0000)]
Updates to reflect availability of autocommit option.

22 years agoAUTOCOMMIT mode is now an available backend GUC variable; setting it
Tom Lane [Fri, 30 Aug 2002 22:18:07 +0000 (22:18 +0000)]
AUTOCOMMIT mode is now an available backend GUC variable; setting it
to false provides more SQL-spec-compliant behavior than we had before.
I am not sure that setting it false is actually a good idea yet; there
is a lot of client-side code that will probably be broken by turning
autocommit off.  But it's a start.

Loosely based on a patch by David Van Wie.

22 years agoFix for breakage of C-coded SRFs, from Joe Conway.
Tom Lane [Fri, 30 Aug 2002 19:56:49 +0000 (19:56 +0000)]
Fix for breakage of C-coded SRFs, from Joe Conway.

22 years agoAdd attisinherited column to pg_attribute; use it to guard against
Tom Lane [Fri, 30 Aug 2002 19:23:20 +0000 (19:23 +0000)]
Add attisinherited column to pg_attribute; use it to guard against
column additions, deletions, and renames that would let a child table
get out of sync with its parent.  Patch by Alvaro Herrera, with some
kibitzing by Tom Lane.

22 years agoBack out unintented tab change.
Bruce Momjian [Fri, 30 Aug 2002 18:15:23 +0000 (18:15 +0000)]
Back out unintented tab change.

22 years agoRemove pgaccess from Makefile.
Bruce Momjian [Fri, 30 Aug 2002 18:14:21 +0000 (18:14 +0000)]
Remove pgaccess from Makefile.

22 years agoRun autoconf.
Bruce Momjian [Fri, 30 Aug 2002 17:16:42 +0000 (17:16 +0000)]
Run autoconf.

22 years agoUpdate documentation for --with-perl.
Bruce Momjian [Fri, 30 Aug 2002 17:14:30 +0000 (17:14 +0000)]
Update documentation for --with-perl.

22 years agoImprove wording after wal_files removal.
Bruce Momjian [Fri, 30 Aug 2002 16:53:34 +0000 (16:53 +0000)]
Improve wording after wal_files removal.

22 years agoComplete TODO item:
Bruce Momjian [Fri, 30 Aug 2002 16:50:50 +0000 (16:50 +0000)]
Complete TODO item:

* Remove wal_files postgresql.conf option because WAL files are
  now recycled

22 years agoRemove pgaccess from CVS. It has its own home now.
Bruce Momjian [Fri, 30 Aug 2002 16:48:44 +0000 (16:48 +0000)]
Remove pgaccess from CVS.  It has its own home now.

22 years agoRe-enable perl configure tests for psql help file generation.
Bruce Momjian [Fri, 30 Aug 2002 16:23:21 +0000 (16:23 +0000)]
Re-enable perl configure tests for psql help file generation.

22 years agoBack out password packet length check.
Bruce Momjian [Fri, 30 Aug 2002 16:00:41 +0000 (16:00 +0000)]
Back out password packet length check.

Improve wording of pre-7.3 syntax mention.

22 years agoperl5 interface moved to gborg
Marc G. Fournier [Fri, 30 Aug 2002 13:06:22 +0000 (13:06 +0000)]
perl5 interface moved to gborg

22 years agolibpgeasy moved to gborg ...
Marc G. Fournier [Fri, 30 Aug 2002 13:03:11 +0000 (13:03 +0000)]
libpgeasy moved to gborg ...

22 years agoFix off-by-one allocation error in PasswordFromFile(), per Gordon Runkle.
Tom Lane [Fri, 30 Aug 2002 05:28:50 +0000 (05:28 +0000)]
Fix off-by-one allocation error in PasswordFromFile(), per Gordon Runkle.

22 years agoAdd comment on old sytax for SELECT FOR UPDATE/LIMIT and COPY.
Bruce Momjian [Fri, 30 Aug 2002 03:18:23 +0000 (03:18 +0000)]
Add comment on old sytax for SELECT FOR UPDATE/LIMIT and COPY.

22 years agoRevert _LARGEFILE64_SOURCE addition; good try but doesn't work,
Tom Lane [Fri, 30 Aug 2002 02:01:34 +0000 (02:01 +0000)]
Revert _LARGEFILE64_SOURCE addition; good try but doesn't work,
at least not on HPUX 10.20, and there's no reason to think it
is needed on later versions.

22 years agointagg subdirectory was missing.
Tom Lane [Fri, 30 Aug 2002 01:44:00 +0000 (01:44 +0000)]
intagg subdirectory was missing.

22 years agoGroup-manipulating code neglected to fill in array element type,
Tom Lane [Fri, 30 Aug 2002 01:01:02 +0000 (01:01 +0000)]
Group-manipulating code neglected to fill in array element type,
which is now required.

22 years agoPL/pgSQL functions can return sets. Neil Conway's patch, modified so
Tom Lane [Fri, 30 Aug 2002 00:28:41 +0000 (00:28 +0000)]
PL/pgSQL functions can return sets.  Neil Conway's patch, modified so
that the functionality is available to anyone via ReturnSetInfo, rather
than hard-wiring it to PL/pgSQL.

22 years agoFix a bug introduced in 7.2.
Hiroshi Inoue [Thu, 29 Aug 2002 23:39:05 +0000 (23:39 +0000)]
Fix a bug introduced in 7.2.

22 years ago> > > > If you want to put in security restrictions that are actually useful,
Bruce Momjian [Thu, 29 Aug 2002 23:06:32 +0000 (23:06 +0000)]
> > > > If you want to put in security restrictions that are actually useful,
> > > > where is the code to verify that PGPASSWORDFILE points at a
> > > > non-world-readable file?  That needs to be there now, not later, or
> > > > we'll have people moaning about backward compatibility when we finally
> > > > do plug that hole.

Alvaro Herrera

22 years agoSir Mordred The Traitor <mordred@s-mail.com> writes:
Bruce Momjian [Thu, 29 Aug 2002 23:05:44 +0000 (23:05 +0000)]
Sir Mordred The Traitor <mordred@s-mail.com> writes:
> Upon invoking a polygon(integer, circle) function a
> src/backend/utils/adt/geo_ops.c:circle_poly() function will gets
> called, which suffers from a buffer overflow.
>
> 2) A src/backend/adt/utils/geo_ops.c:path_encode() fails to detect a
> buffer overrun condition. It is called in multiple places, the most
> interesting are path_out() and poly_out() functions.

> 5) A src/backend/utils/adt/geo_ops.c:path_add() also fails to detect
> a simple buffer overrun.

I've attached a patch which should fix these problems.

Neil Conway

22 years agoAdd cube changes file.
Bruce Momjian [Thu, 29 Aug 2002 23:05:03 +0000 (23:05 +0000)]
Add cube changes file.

22 years agoThe changes I have made are described in CHANGES. This was based on
Bruce Momjian [Thu, 29 Aug 2002 23:03:58 +0000 (23:03 +0000)]
The changes I have made are described in CHANGES. This was based on
diffs to 7.3-devel and may not be applicable to 7.2. I have included a
change covered by a previous bugfix patch I submitted (the problem with
-.1 not being accepted by cube_in). It does not include a fix for the
potential buffer overrun issue I reported for cube_yyerror in
cubeparse.y.

Bruno Wolff III

22 years agoMake pg_resetxlog options parsing more standard and prepare messages for
Peter Eisentraut [Thu, 29 Aug 2002 22:19:03 +0000 (22:19 +0000)]
Make pg_resetxlog options parsing more standard and prepare messages for
translation.

22 years agoCreate "po" subdirectory before writing there.
Peter Eisentraut [Thu, 29 Aug 2002 22:13:01 +0000 (22:13 +0000)]
Create "po" subdirectory before writing there.

22 years agoWorkaround for broken large file support on HP-UX
Peter Eisentraut [Thu, 29 Aug 2002 22:09:22 +0000 (22:09 +0000)]
Workaround for broken large file support on HP-UX

22 years agoPrevent problem with extra-long password packets from allocating lots of
Bruce Momjian [Thu, 29 Aug 2002 21:50:36 +0000 (21:50 +0000)]
Prevent problem with extra-long password packets from allocating lots of
memory.

Neil Conway

22 years agoThis patch reserves the last superuser_reserved_connections slots for
Bruce Momjian [Thu, 29 Aug 2002 21:02:12 +0000 (21:02 +0000)]
This patch reserves the last superuser_reserved_connections slots for
connections by the superuser only.

This patch replaces the last patch I sent a couple of days ago.

It closes a connection that has not been authorised by a superuser if it would
leave less than the GUC variable ReservedBackends
(superuser_reserved_connections in postgres.conf) backend process slots free
in the SISeg. This differs to the first patch which only reserved the last
ReservedBackends slots in the procState array. This has made the free slot
test more expensive due to the use of a lock.

After thinking about a comment on the first patch I've also made it a fatal
error if the number of reserved slots is not less than the maximum number of
connections.

Nigel J. Andrews

22 years agoplease apply small patch for README.tsearch.
Bruce Momjian [Thu, 29 Aug 2002 19:55:26 +0000 (19:55 +0000)]
please apply small patch for README.tsearch.

I've documented space usage and using CLUSTER command

Oleg Bartunov

22 years agoThe unit for statement_timeout is s/1000, not s/1000000
Bruce Momjian [Thu, 29 Aug 2002 19:53:58 +0000 (19:53 +0000)]
The unit for statement_timeout is s/1000, not s/1000000

Manfred Koizar

22 years agoBack out patch, that was alpha, which I think still needs just -O.
Bruce Momjian [Thu, 29 Aug 2002 19:35:47 +0000 (19:35 +0000)]
Back out patch, that was alpha, which I think still needs just -O.

22 years agoChange FreeBSD to use -O2, important for MemSet.
Bruce Momjian [Thu, 29 Aug 2002 19:35:07 +0000 (19:35 +0000)]
Change FreeBSD to use -O2, important for MemSet.

22 years agoAdjust nodeFunctionscan.c to reset transient memory context between calls
Tom Lane [Thu, 29 Aug 2002 17:14:33 +0000 (17:14 +0000)]
Adjust nodeFunctionscan.c to reset transient memory context between calls
to the table function, thus preventing memory leakage accumulation across
calls.  This means that SRFs need to be careful to distinguish permanent
and local storage; adjust code and documentation accordingly.  Patch by
Joe Conway, very minor tweaks by Tom Lane.

22 years agoPush down outer qualification clauses into UNION and INTERSECT subqueries.
Tom Lane [Thu, 29 Aug 2002 16:03:49 +0000 (16:03 +0000)]
Push down outer qualification clauses into UNION and INTERSECT subqueries.
Per pghackers discussion from back around 1-August.

22 years agoCause REINDEX to regard TOAST tables as regular relations, not system
Tom Lane [Thu, 29 Aug 2002 15:56:20 +0000 (15:56 +0000)]
Cause REINDEX to regard TOAST tables as regular relations, not system
tables that need special defenses.  I believe this is okay even for
TOAST tables that belong to system tables.

22 years agochkpass_rout returns text so change PG_RETURN_CSTRING to PG_RETURN_TEXT_P.
D'Arcy J.M. Cain [Thu, 29 Aug 2002 12:18:20 +0000 (12:18 +0000)]
chkpass_rout returns text so change PG_RETURN_CSTRING to PG_RETURN_TEXT_P.
This is currently a cosmetic difference but I make the change now in case
the macros diverge one day.

22 years agoRemove MULTIBYTE
Tatsuo Ishii [Thu, 29 Aug 2002 08:03:22 +0000 (08:03 +0000)]
Remove MULTIBYTE

22 years agoRemove #ifdef MULTIBYTE per hackers list discussion.
Tatsuo Ishii [Thu, 29 Aug 2002 07:22:30 +0000 (07:22 +0000)]
Remove #ifdef MULTIBYTE per hackers list discussion.

22 years agoRephrase 'Cannot insert into a view' and related messages, per
Tom Lane [Thu, 29 Aug 2002 06:05:27 +0000 (06:05 +0000)]
Rephrase 'Cannot insert into a view' and related messages, per
pghackers discussion around 31-Jul-02.

22 years agoA few more fixes for the <replaceable>able> fiasco.
Tom Lane [Thu, 29 Aug 2002 05:17:55 +0000 (05:17 +0000)]
A few more fixes for the <replaceable>able> fiasco.

22 years agoupdate mbregress expected files
Tatsuo Ishii [Thu, 29 Aug 2002 04:43:55 +0000 (04:43 +0000)]
update mbregress expected files

22 years agoProduce a somewhat-useful error message, namely
Tom Lane [Thu, 29 Aug 2002 04:38:04 +0000 (04:38 +0000)]
Produce a somewhat-useful error message, namely
ERROR:  Cannot display a value of type RECORD
rather than a random integer when someone tries to SELECT a tuple
value.  Per pghackers discussion around 26-May-02.

22 years agoFOUND patch was a bit over-enthusiastic: SQL commands that are not
Tom Lane [Thu, 29 Aug 2002 04:12:03 +0000 (04:12 +0000)]
FOUND patch was a bit over-enthusiastic: SQL commands that are not
INSERT, UPDATE, or DELETE shouldn't change FOUND.  IMHO anyway.
Also, try to make documentation a little clearer.

22 years agoRemove support for version-0 FE/BE protocol, per pghackers discussion.
Tom Lane [Thu, 29 Aug 2002 03:22:01 +0000 (03:22 +0000)]
Remove support for version-0 FE/BE protocol, per pghackers discussion.
This breaks support for 6.2 or older client libraries.

22 years agoFix ruleutils to dump column definition lists for anonymous record types
Tom Lane [Thu, 29 Aug 2002 01:19:41 +0000 (01:19 +0000)]
Fix ruleutils to dump column definition lists for anonymous record types
defined in the FROM clause.  From Joe Conway, with some tweaks.

22 years agoCode review for standalone composite types, query-specified composite
Tom Lane [Thu, 29 Aug 2002 00:17:06 +0000 (00:17 +0000)]
Code review for standalone composite types, query-specified composite
types, SRFs.  Not happy with memory management yet, but I'll commit these
other changes.

22 years agoImprove description of tablefunc.
Tom Lane [Wed, 28 Aug 2002 22:05:46 +0000 (22:05 +0000)]
Improve description of tablefunc.

22 years agoInitial Spanish translation from Karim Mribti <karim@inlosa.com>
Peter Eisentraut [Wed, 28 Aug 2002 21:01:14 +0000 (21:01 +0000)]
Initial Spanish translation from Karim Mribti <karim@inlosa.com>

22 years agoUpdates from Dennis Bjorklund
Peter Eisentraut [Wed, 28 Aug 2002 20:58:45 +0000 (20:58 +0000)]
Updates from Dennis Bjorklund

22 years agoBreak up the long usage messages in pg_dump and pg_restore and
Peter Eisentraut [Wed, 28 Aug 2002 20:57:22 +0000 (20:57 +0000)]
Break up the long usage messages in pg_dump and pg_restore and
unify the wording, to make life easier for translators.

from Dennis Bjorklund

22 years agoRemove TIOGA files from CVS current; they remain in repositiry.
Bruce Momjian [Wed, 28 Aug 2002 20:55:23 +0000 (20:55 +0000)]
Remove TIOGA files from CVS current;  they remain in repositiry.

22 years agoThis trivial patches fixes the error message returned by CREATE INDEX
Bruce Momjian [Wed, 28 Aug 2002 20:46:47 +0000 (20:46 +0000)]
This trivial patches fixes the error message returned by CREATE INDEX
when it finds an existing relation with the same name as the
to-be-created index.

Old error message:

nconway=# create table foo (a int);
CREATE TABLE
nconway=# create index foo on foo (a);
ERROR:  index named "foo" already exists

I replaced 'index' with 'relation' in the error message.

Neil Conway

22 years agobackend where a statically sized buffer is written to. Most of these
Bruce Momjian [Wed, 28 Aug 2002 20:46:24 +0000 (20:46 +0000)]
backend where a statically sized buffer is written to. Most of these
should be pretty safe in practice, but it's probably better to be safe
than sorry.

I was actually looking for cases where NAMEDATALEN is assumed to be
32, but only found one. That's fixed too, as well as a few bits of
code cleanup.

Neil Conway

22 years agoThis is a quick patch to fix a crash in pgquery_dictresult() introduced
Bruce Momjian [Wed, 28 Aug 2002 20:18:58 +0000 (20:18 +0000)]
This is a quick patch to fix a crash in pgquery_dictresult() introduced
recently. I just ran into it while running a set of python test scripts,
and I'm not sure who the normal maintainer is for interfaces/python.

John Nield

22 years agoThe following small patch provides a couple of minor updates (against
Bruce Momjian [Wed, 28 Aug 2002 20:18:29 +0000 (20:18 +0000)]
The following small patch provides a couple of minor updates (against
CVS HEAD):

Amended "strings" regression test. TOAST tests now insert two values
with storage set to "external", to exercise properly the TOAST slice
routines which fetch only a subset of the chunks.

Changed now-misleading comment on AlterTableCreateToastTable in
tablecmds.c, because both columns of the index on a toast table are now
used.

John Gray

22 years agoAdd mention of foreign key dependency and SERIAL in 7.2 data restores.
Bruce Momjian [Wed, 28 Aug 2002 20:17:44 +0000 (20:17 +0000)]
Add mention of foreign key dependency and SERIAL in 7.2 data restores.

Note can probably be removed after a couple of releases.

Rod Taylor

22 years agoDump ALTER DATABASE/USER ... SET ...
Peter Eisentraut [Wed, 28 Aug 2002 18:25:05 +0000 (18:25 +0000)]
Dump ALTER DATABASE/USER ... SET ...

22 years agoRemove:
Bruce Momjian [Wed, 28 Aug 2002 16:45:11 +0000 (16:45 +0000)]
Remove:

< * Remove PGPASSWORD because it is insecure on some OS's, in 7.4

22 years agoUpdate info about relkind and pg_type entries for composite-types patch.
Tom Lane [Wed, 28 Aug 2002 15:02:55 +0000 (15:02 +0000)]
Update info about relkind and pg_type entries for composite-types patch.

22 years agoAllow FOR UPDATE to appear after LIMIT/OFFSET to match MySQL syntax and as
Bruce Momjian [Wed, 28 Aug 2002 14:35:37 +0000 (14:35 +0000)]
Allow FOR UPDATE to appear after LIMIT/OFFSET to match MySQL syntax and as
a more logical ordering.

22 years agoFix compile warning.
Tom Lane [Tue, 27 Aug 2002 21:50:23 +0000 (21:50 +0000)]
Fix compile warning.

22 years agoFlush output streams before calling pg_dump subprocess.
Peter Eisentraut [Tue, 27 Aug 2002 21:33:41 +0000 (21:33 +0000)]
Flush output streams before calling pg_dump subprocess.

22 years agoAdd:
Bruce Momjian [Tue, 27 Aug 2002 21:16:13 +0000 (21:16 +0000)]
Add:

>  o Add SET SCHEMA

22 years agoDisable use of -c and -a together in pg_dump; they don't make sense together.
Bruce Momjian [Tue, 27 Aug 2002 21:04:58 +0000 (21:04 +0000)]
Disable use of -c and -a together in pg_dump;  they don't make sense together.

22 years agoBring comments back in sync with code.
Tom Lane [Tue, 27 Aug 2002 20:54:47 +0000 (20:54 +0000)]
Bring comments back in sync with code.

22 years agoThrow error on pg_atoi(''), regression adjustments.
Bruce Momjian [Tue, 27 Aug 2002 20:29:11 +0000 (20:29 +0000)]
Throw error on pg_atoi(''), regression adjustments.

22 years agoEnable locale, so case conversion (identifier processing) and number
Peter Eisentraut [Tue, 27 Aug 2002 20:16:49 +0000 (20:16 +0000)]
Enable locale, so case conversion (identifier processing) and number
formatting (\timing) works correctly.  Change "Total time" to "Time"
since there is nothing that "total" refers to.  Remove non-multibyte
code.

22 years agoReimplement pg_dumpall in C. Currently no change in functionality,
Peter Eisentraut [Tue, 27 Aug 2002 18:57:26 +0000 (18:57 +0000)]
Reimplement pg_dumpall in C.  Currently no change in functionality,
except that it's more robust, reconnects less often, and is NLS'ed.

22 years agoAdd '+' mention in \? help. More clean of \? to do.
Bruce Momjian [Tue, 27 Aug 2002 18:28:29 +0000 (18:28 +0000)]
Add '+' mention in \? help.  More clean of \? to do.

22 years agoMake change for pg_locks table.
Bruce Momjian [Tue, 27 Aug 2002 18:06:00 +0000 (18:06 +0000)]
Make change for pg_locks table.

22 years agoThe attached patch implements the password packet length sanity check
Bruce Momjian [Tue, 27 Aug 2002 16:21:51 +0000 (16:21 +0000)]
The attached patch implements the password packet length sanity check
(using an elog(LOG) ), as well as includes a few more comment fixes.

Neil Conway

22 years agoAdd:
Bruce Momjian [Tue, 27 Aug 2002 16:19:46 +0000 (16:19 +0000)]
Add:

> * Allow free space map to be auto-sized or warn when it is too small

22 years agoAdd error code emails.
Bruce Momjian [Tue, 27 Aug 2002 15:31:32 +0000 (15:31 +0000)]
Add error code emails.

22 years agoAdd most of Neil Conway's cleanups.
Bruce Momjian [Tue, 27 Aug 2002 15:15:23 +0000 (15:15 +0000)]
Add most of Neil Conway's cleanups.

22 years agoMore connection timeout cleanups.
Bruce Momjian [Tue, 27 Aug 2002 15:02:50 +0000 (15:02 +0000)]
More connection timeout cleanups.

22 years agoCleanup of libpq connection timeout code.
Bruce Momjian [Tue, 27 Aug 2002 14:49:52 +0000 (14:49 +0000)]
Cleanup of libpq connection timeout code.

22 years agoAdd:
Bruce Momjian [Tue, 27 Aug 2002 14:17:14 +0000 (14:17 +0000)]
Add:

> * Allow REINDEX to rebuild all indexes, remove /contrib/reindex
>  o Allow CLUSTER to cluster all tables, remove clusterdb

22 years agoAdd fsm sizes.
Bruce Momjian [Tue, 27 Aug 2002 14:06:05 +0000 (14:06 +0000)]
Add fsm sizes.

22 years agoPREPARE/EXECUTE statements. Patch by Neil Conway, some kibitzing
Tom Lane [Tue, 27 Aug 2002 04:55:12 +0000 (04:55 +0000)]
PREPARE/EXECUTE statements.  Patch by Neil Conway, some kibitzing
from Tom Lane.

22 years agoDone:
Bruce Momjian [Tue, 27 Aug 2002 04:30:24 +0000 (04:30 +0000)]
Done:

>  o -Cluster all tables at once using pg_index.indisclustered set during

22 years agoAdd to mmap discussion.
Bruce Momjian [Tue, 27 Aug 2002 04:09:01 +0000 (04:09 +0000)]
Add to mmap discussion.

22 years agoThis patch updates the lock listing code to use Joe Conway's new
Bruce Momjian [Tue, 27 Aug 2002 04:00:28 +0000 (04:00 +0000)]
This patch updates the lock listing code to use Joe Conway's new
anonymous return type SRF code. It gets rid of the superflous
'pg_locks_result' that Bruce/Tom had commented on. Otherwise, no
changes in functionality.

Neil Conway

22 years agoThis is a 2 line patch to src/interfaces/perl5/GNUMakefile that fixes
Bruce Momjian [Tue, 27 Aug 2002 03:57:11 +0000 (03:57 +0000)]
This is a 2 line patch to src/interfaces/perl5/GNUMakefile that fixes
the 'override CPPFLAGS' to include the source directory during compile,
and makes the install target look in the proper place for the man page.

Changes are only required when building outside the source directory.

J. R. Nield

22 years agoThis patches replaces a few more usages of strcpy() and sprintf() when
Bruce Momjian [Tue, 27 Aug 2002 03:56:35 +0000 (03:56 +0000)]
This patches replaces a few more usages of strcpy() and sprintf() when
copying into a fixed-size buffer (in this case, a buffer of
NAMEDATALEN bytes). AFAICT nothing to worry about here, but worth
fixing anyway...

Neil Conway

22 years agoCleanup of SGML
Bruce Momjian [Tue, 27 Aug 2002 03:55:17 +0000 (03:55 +0000)]
Cleanup of SGML

22 years agoI attach a little patch to make CLUSTER set and reset the indisclustered
Bruce Momjian [Tue, 27 Aug 2002 03:38:28 +0000 (03:38 +0000)]
I attach a little patch to make CLUSTER set and reset the indisclustered
bit on the indexes.

I also attach clusterdb and clusterdb.sgml; both of them are blatant
rips of vacuumdb and vacuumdb.sgml, but get the job done.  Please review
them, as I'm probably making a lot of mistakes with SGML and I can't
compile it here.

vacuumdb itself is not very comfortable to use when the databases have
passwords, because it has to connect once for each table (I can probably
make it connect only once for each database; should I?).  Because of
this I added a mention of PGPASSWORDFILE in the documentation, but I
don't know if that is the correct place for that.

Alvaro Herrera

22 years agoAdd to skip list in check_guc
Bruce Momjian [Tue, 27 Aug 2002 03:06:16 +0000 (03:06 +0000)]
Add to skip list in check_guc

22 years agoComment cleanup.
Bruce Momjian [Tue, 27 Aug 2002 03:02:31 +0000 (03:02 +0000)]
Comment cleanup.

22 years agoScript cleanups.
Bruce Momjian [Tue, 27 Aug 2002 03:01:13 +0000 (03:01 +0000)]
Script cleanups.

22 years agoClean up script.
Bruce Momjian [Tue, 27 Aug 2002 02:54:39 +0000 (02:54 +0000)]
Clean up script.

22 years agoAdd check_guc utility to compare guc.c and postgresql.conf.sample.
Bruce Momjian [Tue, 27 Aug 2002 02:52:42 +0000 (02:52 +0000)]
Add check_guc utility to compare guc.c and postgresql.conf.sample.

22 years agoFix units in postgresql.conf.
Bruce Momjian [Tue, 27 Aug 2002 02:50:41 +0000 (02:50 +0000)]
Fix units in postgresql.conf.

22 years agoAdd OS X link line example for external functions.
Bruce Momjian [Mon, 26 Aug 2002 23:22:47 +0000 (23:22 +0000)]
Add OS X link line example for external functions.

22 years agoAdd discussion of pre-write pages to WAL.
Bruce Momjian [Mon, 26 Aug 2002 23:14:15 +0000 (23:14 +0000)]
Add discussion of pre-write pages to WAL.

22 years agoAdd:
Bruce Momjian [Mon, 26 Aug 2002 23:13:37 +0000 (23:13 +0000)]
Add:

>   partial page writes [wal]

22 years agoAdd:
Bruce Momjian [Mon, 26 Aug 2002 23:02:21 +0000 (23:02 +0000)]
Add:

> * Add CORRESPONDING BY to UNION/INTERSECT/EXCEPT

22 years agoAdd units to postgresql.conf file.
Bruce Momjian [Mon, 26 Aug 2002 22:23:07 +0000 (22:23 +0000)]
Add units to postgresql.conf file.