]> granicus.if.org Git - postgresql/log
postgresql
21 years agoDunno why this got committed with DOS newlines, but fix that, and
Tom Lane [Thu, 13 Nov 2003 22:13:39 +0000 (22:13 +0000)]
Dunno why this got committed with DOS newlines, but fix that, and
add a header comment/copyright notice.

21 years agoSilly to copy sprompt.c from src/port when we're linking libpgport anyway.
Tom Lane [Thu, 13 Nov 2003 20:30:37 +0000 (20:30 +0000)]
Silly to copy sprompt.c from src/port when we're linking libpgport anyway.

21 years agopgindent new initdb.c from Tom.
Bruce Momjian [Thu, 13 Nov 2003 20:12:47 +0000 (20:12 +0000)]
pgindent new initdb.c from Tom.

21 years agoRegenerate text files.
Peter Eisentraut [Thu, 13 Nov 2003 18:03:11 +0000 (18:03 +0000)]
Regenerate text files.

21 years agoAdd final port reports.
Peter Eisentraut [Thu, 13 Nov 2003 18:01:45 +0000 (18:01 +0000)]
Add final port reports.

21 years agoAdd owner description to initdb C code.
Bruce Momjian [Thu, 13 Nov 2003 15:01:40 +0000 (15:01 +0000)]
Add owner description to initdb C code.

Andrew Dunstan

21 years ago2nd try for the ARC strategy.
Jan Wieck [Thu, 13 Nov 2003 14:57:15 +0000 (14:57 +0000)]
2nd try for the ARC strategy.

I added a couple more Assertions while tracking down the exact
cause of the former bug.

All 93 regression tests pass now.

Jan

21 years agoARC strategy backed out ... sorry
Jan Wieck [Thu, 13 Nov 2003 05:34:58 +0000 (05:34 +0000)]
ARC strategy backed out ... sorry

Jan

21 years agoUpdate for 7.4 release.
Bruce Momjian [Thu, 13 Nov 2003 04:23:03 +0000 (04:23 +0000)]
Update for 7.4 release.

21 years agoUpdate MSWIN FAQ
Bruce Momjian [Thu, 13 Nov 2003 03:53:00 +0000 (03:53 +0000)]
Update MSWIN FAQ

Christopher Kings-Lynne

21 years agoAdd to Win32 discussion.
Bruce Momjian [Thu, 13 Nov 2003 03:45:33 +0000 (03:45 +0000)]
Add to Win32 discussion.

21 years agoAdd fflush() calls so that I'm-about-to-do-this messages actually
Tom Lane [Thu, 13 Nov 2003 01:36:00 +0000 (01:36 +0000)]
Add fflush() calls so that I'm-about-to-do-this messages actually
come out before the action is done.

21 years agoFix lack of optreset.
Tom Lane [Thu, 13 Nov 2003 01:09:24 +0000 (01:09 +0000)]
Fix lack of optreset.

21 years agoReplacement of the buffer replacement strategy with an ARC
Jan Wieck [Thu, 13 Nov 2003 00:40:02 +0000 (00:40 +0000)]
Replacement of the buffer replacement strategy with an ARC
algorithm adopted for PostgreSQL.

Jan

21 years agoAcceptResult() was missing a case for PGRES_EMPTY_QUERY --- probably
Tom Lane [Wed, 12 Nov 2003 22:53:16 +0000 (22:53 +0000)]
AcceptResult() was missing a case for PGRES_EMPTY_QUERY --- probably
my fault.  Adding it fixes bogus message display when reading a block
comment at the end of a script file.

21 years agoDocumentation cleanup
Peter Eisentraut [Wed, 12 Nov 2003 22:47:47 +0000 (22:47 +0000)]
Documentation cleanup

21 years agoCross-data-type comparisons are now indexable by btrees, pursuant to my
Tom Lane [Wed, 12 Nov 2003 21:15:59 +0000 (21:15 +0000)]
Cross-data-type comparisons are now indexable by btrees, pursuant to my
pghackers proposal of 8-Nov.  All the existing cross-type comparison
operators (int2/int4/int8 and float4/float8) have appropriate support.
The original proposal of storing the right-hand-side datatype as part of
the primary key for pg_amop and pg_amproc got modified a bit in the event;
it is easier to store zero as the 'default' case and only store a nonzero
when the operator is actually cross-type.  Along the way, remove the
long-since-defunct bigbox_ops operator class.

21 years agoHere's some improvements. I just ended up referring people to Jason's
Bruce Momjian [Wed, 12 Nov 2003 04:14:30 +0000 (04:14 +0000)]
Here's some improvements.  I just ended up referring people to Jason's
website for install as service, because it's a quite a long and complex
process.

Christopher Kings-Lynne

21 years agoAdd:
Bruce Momjian [Wed, 12 Nov 2003 04:10:43 +0000 (04:10 +0000)]
Add:

> * Ignore temporary tables from other session when processing inheritance

21 years agoHere's a patch that adds some text mentioning that
Bruce Momjian [Wed, 12 Nov 2003 04:08:07 +0000 (04:08 +0000)]
Here's a patch that adds some text mentioning that
RESTRICT is not deferrable to the create table reference
page.

Stephan Szabo

21 years agoTypo fix in comment from David Wheeler
Bruce Momjian [Wed, 12 Nov 2003 03:27:26 +0000 (03:27 +0000)]
Typo fix in comment from David Wheeler

21 years agoUpdate:
Bruce Momjian [Wed, 12 Nov 2003 00:25:35 +0000 (00:25 +0000)]
Update:

> * Add free-behind capability for large sequential scans (fadvise)

21 years agoCleanup for recent .exe Win32 fix.
Bruce Momjian [Wed, 12 Nov 2003 00:04:10 +0000 (00:04 +0000)]
Cleanup for recent .exe Win32 fix.

21 years agoUpdate /port C header descriptions.
Bruce Momjian [Tue, 11 Nov 2003 23:52:45 +0000 (23:52 +0000)]
Update /port C header descriptions.

21 years agoAdd .exe to Win32 stat calls. Don't symlink postmaster on Win32.
Bruce Momjian [Tue, 11 Nov 2003 03:53:33 +0000 (03:53 +0000)]
Add .exe to Win32 stat calls.  Don't symlink postmaster on Win32.

21 years agoAdd system_views.sql to CVS.
Bruce Momjian [Tue, 11 Nov 2003 02:00:00 +0000 (02:00 +0000)]
Add system_views.sql to CVS.

21 years agoMove system_views.sql into backend/catalog, per Tom.
Bruce Momjian [Tue, 11 Nov 2003 01:58:23 +0000 (01:58 +0000)]
Move system_views.sql into backend/catalog, per Tom.

21 years ago* ioctlsocket_ret
Bruce Momjian [Tue, 11 Nov 2003 01:09:42 +0000 (01:09 +0000)]
* ioctlsocket_ret
        - is not initialized to 1 (at least in the WIN_32 code I started with!)

Claudio Natoli

21 years agoUpdated version of initdb with "rmdir/del" call on Win32.
Bruce Momjian [Mon, 10 Nov 2003 22:52:10 +0000 (22:52 +0000)]
Updated version of initdb with "rmdir/del" call on Win32.

Other cleanups as discussed.

21 years agoAdd C version of initdb, from Andrew Dunstan.
Bruce Momjian [Mon, 10 Nov 2003 22:51:16 +0000 (22:51 +0000)]
Add C version of initdb, from Andrew Dunstan.

This is his original version with a binary rmdir() we might need in the
future.

I will commit an update version with cleanups shortly.

21 years agoUpdate freenode mention.
Bruce Momjian [Mon, 10 Nov 2003 22:47:35 +0000 (22:47 +0000)]
Update freenode mention.

21 years agoUpdate release notes for polymorphic functions.
Bruce Momjian [Mon, 10 Nov 2003 22:27:00 +0000 (22:27 +0000)]
Update release notes for polymorphic functions.

21 years agoUpdate IRC to mention freenet instead of openprojects.
Bruce Momjian [Mon, 10 Nov 2003 21:56:08 +0000 (21:56 +0000)]
Update IRC to mention freenet instead of openprojects.

21 years agoRe-added forgotten cache.
Michael Meskes [Mon, 10 Nov 2003 20:28:30 +0000 (20:28 +0000)]
Re-added forgotten cache.

21 years agoRemove rcsid CVS header variable --- not used.
Bruce Momjian [Mon, 10 Nov 2003 19:40:46 +0000 (19:40 +0000)]
Remove rcsid CVS header variable --- not used.

21 years agoAdd operator strategy and comparison-value datatype fields to ScanKey.
Tom Lane [Sun, 9 Nov 2003 21:30:38 +0000 (21:30 +0000)]
Add operator strategy and comparison-value datatype fields to ScanKey.
Remove the 'strategy map' code, which was a large amount of mechanism
that no longer had any use except reverse-mapping from procedure OID to
strategy number.  Passing the strategy number to the index AM in the
first place is simpler and faster.
This is a preliminary step in planned support for cross-datatype index
operations.  I'm committing it now since the ScanKeyEntryInitialize()
API change touches quite a lot of files, and I want to commit those
changes before the tree drifts under me.

21 years agoAdd:
Bruce Momjian [Sun, 9 Nov 2003 04:23:50 +0000 (04:23 +0000)]
Add:

> * Have psql '\i ~/<tab><tab>' actually load files it displays from home dir

21 years agoI have attached a more comprehensive MSWIN FAQ patch. Basically, the
Bruce Momjian [Sun, 9 Nov 2003 03:47:51 +0000 (03:47 +0000)]
I have attached a more comprehensive MSWIN FAQ patch.  Basically, the
instructions were way out of date and incorrect.  Installing Postgres
from Cygwin is easier these days than the FAQ would imply.

This patch already includes Andrew's previous patch.

Christopher Kings-Lynne

21 years agoAdd:
Bruce Momjian [Sun, 9 Nov 2003 03:41:25 +0000 (03:41 +0000)]
Add:

> * Have psql \dn show only visible schemas using current_schemas()

21 years agoFix typo on autovacuum readme.
Bruce Momjian [Sun, 9 Nov 2003 03:15:46 +0000 (03:15 +0000)]
Fix typo on autovacuum readme.

21 years agoAdd:
Bruce Momjian [Sun, 9 Nov 2003 00:41:14 +0000 (00:41 +0000)]
Add:

> * Use more reliable method for CREATE DATABASE to get a consistent copy of db
>

21 years agoAllow tab completion for ALTER TABLE dbname <tab><tab> to show new
Bruce Momjian [Sat, 8 Nov 2003 20:54:24 +0000 (20:54 +0000)]
Allow tab completion for ALTER TABLE dbname <tab><tab> to show new
RENAME TO option.

21 years agoCorrect misspellings of REFERENCES.
Tom Lane [Sat, 8 Nov 2003 20:43:52 +0000 (20:43 +0000)]
Correct misspellings of REFERENCES.

21 years agoRestore compatibility with Tcl 8.0.* --- from ljb.
Tom Lane [Sat, 8 Nov 2003 20:34:36 +0000 (20:34 +0000)]
Restore compatibility with Tcl 8.0.* --- from ljb.

21 years agoDon't need hack copy of system() anymore in OS X 10.3.
Tom Lane [Sat, 8 Nov 2003 20:14:51 +0000 (20:14 +0000)]
Don't need hack copy of system() anymore in OS X 10.3.

21 years agoMade sure an internal array is not treated as a user defined one.
Michael Meskes [Sat, 8 Nov 2003 19:46:27 +0000 (19:46 +0000)]
Made sure an internal array is not treated as a user defined one.

21 years agoFix process-status handling for OS X 10.3.
Tom Lane [Sat, 8 Nov 2003 19:07:24 +0000 (19:07 +0000)]
Fix process-status handling for OS X 10.3.

21 years agoAdjust file so psql help picks it up properly.
Peter Eisentraut [Sat, 8 Nov 2003 11:06:37 +0000 (11:06 +0000)]
Adjust file so psql help picks it up properly.

patch by Kris Jurka

21 years agoCause stats processes to detach from shared memory when started, so that
Tom Lane [Fri, 7 Nov 2003 21:55:50 +0000 (21:55 +0000)]
Cause stats processes to detach from shared memory when started, so that
they do not prevent the postmaster from deleting the shmem segment during
a post-backend-crash restart cycle.  Per recent discussion.

21 years agozero_damaged_pages must absolutely NOT be marked GUC_DISALLOW_IN_FILE,
Tom Lane [Fri, 7 Nov 2003 21:27:38 +0000 (21:27 +0000)]
zero_damaged_pages must absolutely NOT be marked GUC_DISALLOW_IN_FILE,
else it cannot be used to handle failures detected during WAL replay.
Fortunately this flag isn't actually enforced yet, but get it right.

21 years agoTypo fix.
Bruce Momjian [Fri, 7 Nov 2003 17:02:09 +0000 (17:02 +0000)]
Typo fix.

21 years agoAdd:
Bruce Momjian [Fri, 7 Nov 2003 15:31:14 +0000 (15:31 +0000)]
Add:
> * Allow CREATE TABLE foo (f1 INT CHECK (f1 > 0) CHECK (f1 < 10)) to work
>   by searching for non-conflicting constraint names, and prefix with table name

21 years agoMinor copy-editing.
Tom Lane [Thu, 6 Nov 2003 22:21:47 +0000 (22:21 +0000)]
Minor copy-editing.

21 years agoImplement isolation levels read uncommitted and repeatable read as acting
Peter Eisentraut [Thu, 6 Nov 2003 22:08:15 +0000 (22:08 +0000)]
Implement isolation levels read uncommitted and repeatable read as acting
like the next higher one.

21 years agoMake the detection of nsgmls more robust for funny shells.
Peter Eisentraut [Thu, 6 Nov 2003 10:30:42 +0000 (10:30 +0000)]
Make the detection of nsgmls more robust for funny shells.

21 years agoFix for this problem:
Tom Lane [Wed, 5 Nov 2003 22:00:46 +0000 (22:00 +0000)]
Fix for this problem:

regression=# select 1 from tenk1 ta cross join tenk1 tb for update;
ERROR:  no relation entry for relid 3

7.3 said "SELECT FOR UPDATE cannot be applied to a join", which was better
but still wrong, considering that 7.2 took the query just fine.  Fix by
making transformForUpdate() ignore JOIN and other special RTE types,
rather than trying to mark them FOR UPDATE.  The actual error message now
only appears if you explicitly name the join in FOR UPDATE.

21 years agoAdded missing methods
Dave Cramer [Wed, 5 Nov 2003 11:57:53 +0000 (11:57 +0000)]
Added missing methods

21 years agoAdd -O to really trigger compiler bug.
Peter Eisentraut [Wed, 5 Nov 2003 07:42:31 +0000 (07:42 +0000)]
Add -O to really trigger compiler bug.

21 years agoCheck off UnixWare.
Peter Eisentraut [Wed, 5 Nov 2003 00:10:06 +0000 (00:10 +0000)]
Check off UnixWare.

21 years agoAdd detection of compiler bug.
Peter Eisentraut [Wed, 5 Nov 2003 00:09:08 +0000 (00:09 +0000)]
Add detection of compiler bug.

21 years agoMinor copy-editing.
Tom Lane [Wed, 5 Nov 2003 00:05:32 +0000 (00:05 +0000)]
Minor copy-editing.

21 years agoSome copy-editing for 7.4 release notes.
Tom Lane [Tue, 4 Nov 2003 20:54:13 +0000 (20:54 +0000)]
Some copy-editing for 7.4 release notes.

21 years agoGive the full syntax rules for subscripting and field selection in the
Tom Lane [Tue, 4 Nov 2003 19:18:15 +0000 (19:18 +0000)]
Give the full syntax rules for subscripting and field selection in the
proper place, namely the syntax discussion of value expressions.

21 years agoUpdate keywords table.
Peter Eisentraut [Tue, 4 Nov 2003 12:59:54 +0000 (12:59 +0000)]
Update keywords table.

21 years agoUpdate install-sh and mkinstalldirs from master source (Automake). They
Peter Eisentraut [Tue, 4 Nov 2003 10:59:58 +0000 (10:59 +0000)]
Update install-sh and mkinstalldirs from master source (Automake).  They
have included a few fixes over the years to make them more robust and
faster.

21 years agoAdd note to update config.guess and config.sub at the start of beta.
Peter Eisentraut [Tue, 4 Nov 2003 10:33:28 +0000 (10:33 +0000)]
Add note to update config.guess and config.sub at the start of beta.

21 years agoNew config.guess and config.sub from upstream.
Peter Eisentraut [Tue, 4 Nov 2003 10:31:33 +0000 (10:31 +0000)]
New config.guess and config.sub from upstream.

21 years agoRemove unused graphics files.
Peter Eisentraut [Tue, 4 Nov 2003 10:25:07 +0000 (10:25 +0000)]
Remove unused graphics files.

21 years agoAdd report about HP-UX 11.00.
Peter Eisentraut [Tue, 4 Nov 2003 10:08:54 +0000 (10:08 +0000)]
Add report about HP-UX 11.00.

21 years agoRandom copy-editing.
Peter Eisentraut [Tue, 4 Nov 2003 09:55:39 +0000 (09:55 +0000)]
Random copy-editing.

21 years agoImprove message wording for spinlocks-missing compilation error.
Peter Eisentraut [Tue, 4 Nov 2003 09:53:36 +0000 (09:53 +0000)]
Improve message wording for spinlocks-missing compilation error.

21 years agoCopy-editing.
Tom Lane [Tue, 4 Nov 2003 00:34:45 +0000 (00:34 +0000)]
Copy-editing.

21 years agopatch for rs.previous and test case as well as patch for allowing server and port...
Dave Cramer [Mon, 3 Nov 2003 15:28:26 +0000 (15:28 +0000)]
patch for rs.previous and test case as well as patch for allowing server and port to be specified in test cases

21 years agoaccept url and fk action fix from Kris Jurka
Dave Cramer [Mon, 3 Nov 2003 15:22:07 +0000 (15:22 +0000)]
accept url and fk action fix from Kris Jurka

21 years agoFixed potentially uninitialized memory bug in compatlib.
Michael Meskes [Mon, 3 Nov 2003 14:44:28 +0000 (14:44 +0000)]
Fixed potentially uninitialized memory bug in compatlib.

21 years agoTag HEAD as 7.5devel.
Tom Lane [Mon, 3 Nov 2003 14:42:08 +0000 (14:42 +0000)]
Tag HEAD as 7.5devel.

21 years agofix typo. (role_columns_grants -> role_column_grants)
Tatsuo Ishii [Mon, 3 Nov 2003 12:31:52 +0000 (12:31 +0000)]
fix typo. (role_columns_grants -> role_column_grants)

21 years agotag it Release Candidate 1, as previously discussed REL7_4_RC1
PostgreSQL Daemon [Mon, 3 Nov 2003 05:27:18 +0000 (05:27 +0000)]
tag it Release Candidate 1, as previously discussed

21 years agoAdjust data types in some of the UNION tests to avoid potentially
Tom Lane [Sun, 2 Nov 2003 22:35:26 +0000 (22:35 +0000)]
Adjust data types in some of the UNION tests to avoid potentially
platform-dependent results, as per example from Larry Rosenman.

21 years agoProvide a way to run the parallel regression tests with a user-specified
Tom Lane [Sun, 2 Nov 2003 21:56:15 +0000 (21:56 +0000)]
Provide a way to run the parallel regression tests with a user-specified
limit on the number of simultaneous connections.  Andrew Dunstan, with
review by Tom Lane.

21 years agoFix language.
Peter Eisentraut [Sun, 2 Nov 2003 12:59:54 +0000 (12:59 +0000)]
Fix language.

21 years agoMake spelling consistent.
Peter Eisentraut [Sun, 2 Nov 2003 12:59:28 +0000 (12:59 +0000)]
Make spelling consistent.

21 years agopg_dumpall doesn't use psql anymore.
Peter Eisentraut [Sun, 2 Nov 2003 12:58:39 +0000 (12:58 +0000)]
pg_dumpall doesn't use psql anymore.

21 years agoPut --describe-config in the right place.
Peter Eisentraut [Sun, 2 Nov 2003 12:58:11 +0000 (12:58 +0000)]
Put --describe-config in the right place.

21 years agoFix name in supported platforms list.
Peter Eisentraut [Sun, 2 Nov 2003 12:57:48 +0000 (12:57 +0000)]
Fix name in supported platforms list.

21 years agoComplete options help and put it in less random order.
Peter Eisentraut [Sun, 2 Nov 2003 12:55:24 +0000 (12:55 +0000)]
Complete options help and put it in less random order.

21 years agoCall domains "domains", not "derived types".
Peter Eisentraut [Sun, 2 Nov 2003 12:53:57 +0000 (12:53 +0000)]
Call domains "domains", not "derived types".

21 years agoUpdate ports list.
Peter Eisentraut [Sun, 2 Nov 2003 08:54:09 +0000 (08:54 +0000)]
Update ports list.

21 years agoUnset CFLAGS before reading template. This should be more robust.
Peter Eisentraut [Sat, 1 Nov 2003 20:48:51 +0000 (20:48 +0000)]
Unset CFLAGS before reading template.  This should be more robust.

When --enable-debug is used, then the default CFLAGS for non-GCC is just
-g without -O.

Backpatch enhancement of Autoconf inline test that detects problems with
the HP C compiler.

21 years agoFix CFLAGS logic.
Peter Eisentraut [Sat, 1 Nov 2003 20:45:30 +0000 (20:45 +0000)]
Fix CFLAGS logic.

21 years agoMore whitespace fixes. Do people write the expected files by hand?
Peter Eisentraut [Sat, 1 Nov 2003 03:18:20 +0000 (03:18 +0000)]
More whitespace fixes.  Do people write the expected files by hand?

21 years agoFix hidden whitespace differences between expected and result files.
Peter Eisentraut [Sat, 1 Nov 2003 03:07:07 +0000 (03:07 +0000)]
Fix hidden whitespace differences between expected and result files.

21 years agoSpell checking, consistent terminology.
Peter Eisentraut [Sat, 1 Nov 2003 01:56:29 +0000 (01:56 +0000)]
Spell checking, consistent terminology.

21 years agoUpdate future-tense comments in README to present tense. Noted by
Tom Lane [Fri, 31 Oct 2003 22:48:08 +0000 (22:48 +0000)]
Update future-tense comments in README to present tense.  Noted by
Neil Conway.

21 years agoRewrite GiST documentation into something actually useful.
Tom Lane [Fri, 31 Oct 2003 22:41:21 +0000 (22:41 +0000)]
Rewrite GiST documentation into something actually useful.

Christopher Kings-Lynne

21 years agoFix broken markup.
Tom Lane [Fri, 31 Oct 2003 22:22:10 +0000 (22:22 +0000)]
Fix broken markup.

21 years agoTranslation update
Peter Eisentraut [Fri, 31 Oct 2003 22:14:15 +0000 (22:14 +0000)]
Translation update

21 years agoWhen a superuser does GRANT or REVOKE on an object he doesn't own,
Tom Lane [Fri, 31 Oct 2003 20:00:49 +0000 (20:00 +0000)]
When a superuser does GRANT or REVOKE on an object he doesn't own,
process the command as though it were issued by the object owner.
This prevents creating weird scenarios in which the same privileges
may appear to flow from different sources, and ensures that a superuser
can in fact revoke all privileges if he wants to.  In particular this
means that the regression tests work when run by a superuser other than
the original bootstrap userid.  Per report from Larry Rosenman.

21 years agonew protocol, faster startup.
Bruce Momjian [Fri, 31 Oct 2003 19:51:14 +0000 (19:51 +0000)]
new protocol, faster startup.

21 years agoUpdate for polymorphic functions, needs more work.
Bruce Momjian [Fri, 31 Oct 2003 19:49:40 +0000 (19:49 +0000)]
Update for polymorphic functions, needs more work.