git.postgresql.org Git - postgresql.git/log
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
Add:
> * Ignore temporary tables from other session when processing inheritance
Here's a patch that adds some text mentioning that
RESTRICT is not deferrable to the create table reference
page.
Stephan Szabo
Typo fix in comment from David Wheeler
Update:
> * Add free-behind capability for large sequential scans (fadvise)
Cleanup for recent .exe Win32 fix.
Update /port C header descriptions.
Add .exe to Win32 stat calls. Don't symlink postmaster on Win32.
Add system_views.sql to CVS.
Move system_views.sql into backend/catalog, per Tom.
* ioctlsocket_ret
- is not initialized to 1 (at least in the WIN_32 code I started with!)
Claudio Natoli
Updated version of initdb with "rmdir/del" call on Win32.
Other cleanups as discussed.
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.
Update freenode mention.
Update release notes for polymorphic functions.
Update IRC to mention freenet instead of openprojects.
Re-added forgotten cache.
Remove rcsid CVS header variable --- not used.
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.
Add:
> * Have psql '\i ~/<tab><tab>' actually load files it displays from home dir
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
Add:
> * Have psql \dn show only visible schemas using current_schemas()
Fix typo on autovacuum readme.
Add:
> * Use more reliable method for CREATE DATABASE to get a consistent copy of db
>
Allow tab completion for ALTER TABLE dbname <tab><tab> to show new
RENAME TO option.
Tom Lane [Sat, 8 Nov 2003 20:43:52 +0000 (20:43 +0000)]
Correct misspellings of REFERENCES.
Tom Lane [Sat, 8 Nov 2003 20:34:36 +0000 (20:34 +0000)]
Restore compatibility with Tcl 8.0.* --- from ljb.
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.
Made sure an internal array is not treated as a user defined one.
Tom Lane [Sat, 8 Nov 2003 19:07:24 +0000 (19:07 +0000)]
Fix process-status handling for OS X 10.3.
Adjust file so psql help picks it up properly.
patch by Kris Jurka
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.
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.
Typo fix.
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
Tom Lane [Thu, 6 Nov 2003 22:21:47 +0000 (22:21 +0000)]
Minor copy-editing.
Implement isolation levels read uncommitted and repeatable read as acting
like the next higher one.
Make the detection of nsgmls more robust for funny shells.
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.
Dave Cramer [Wed, 5 Nov 2003 11:57:53 +0000 (11:57 +0000)]
Added missing methods
Add -O to really trigger compiler bug.
Check off UnixWare.
Add detection of compiler bug.
Tom Lane [Wed, 5 Nov 2003 00:05:32 +0000 (00:05 +0000)]
Minor copy-editing.
Tom Lane [Tue, 4 Nov 2003 20:54:13 +0000 (20:54 +0000)]
Some copy-editing for 7.4 release notes.
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.
Update keywords table.
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.
Add note to update config.guess and config.sub at the start of beta.
New config.guess and config.sub from upstream.
Remove unused graphics files.
Add report about HP-UX 11.00.
Random copy-editing.
Improve message wording for spinlocks-missing compilation error.
Tom Lane [Tue, 4 Nov 2003 00:34:45 +0000 (00:34 +0000)]
Copy-editing.
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
Dave Cramer [Mon, 3 Nov 2003 15:22:07 +0000 (15:22 +0000)]
accept url and fk action fix from Kris Jurka
Fixed potentially uninitialized memory bug in compatlib.
Tom Lane [Mon, 3 Nov 2003 14:42:08 +0000 (14:42 +0000)]
Tag HEAD as 7.5devel.
fix typo. (role_columns_grants -> role_column_grants)
tag it Release Candidate 1, as previously discussed
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.
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.
Fix language.
Make spelling consistent.
pg_dumpall doesn't use psql anymore.
Put --describe-config in the right place.
Fix name in supported platforms list.
Complete options help and put it in less random order.
Call domains "domains", not "derived types".
Update ports list.
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.
Fix CFLAGS logic.
More whitespace fixes. Do people write the expected files by hand?
Fix hidden whitespace differences between expected and result files.
Spell checking, consistent terminology.
Tom Lane [2003年10月31日 22:48:08 +0000 (22:48 +0000)]
Update future-tense comments in README to present tense. Noted by
Neil Conway.
Tom Lane [2003年10月31日 22:41:21 +0000 (22:41 +0000)]
Rewrite GiST documentation into something actually useful.
Christopher Kings-Lynne
Tom Lane [2003年10月31日 22:22:10 +0000 (22:22 +0000)]
Fix broken markup.
Translation update
Tom Lane [2003年10月31日 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.
new protocol, faster startup.
Update for polymorphic functions, needs more work.
MAC OS X => Mac OS X
Release updates suggested by Tom.
Tom Lane [2003年10月31日 17:43:10 +0000 (17:43 +0000)]
Minor cleanup of PQunescapeBytea(). Avoid unportable assumptions about
behavior of malloc and realloc when request size is 0. Fix escape
sequence recognizer so that only valid 3-digit octal sequences are
treated as escape sequences ... isdigit() is not a correct test.
Jan Wieck [2003年10月31日 14:27:57 +0000 (14:27 +0000)]
Moved the recently added test for foreign key disabled by rewrite
rule into the rule.sql since it affects the latter if run in paralell.
Jan
If EOF is found inside a string/comment/etc. stop parsing.
Remove <note> take, use another paragraph for description.
Update HISTORY.
Update with more comments.
Jan Wieck [2003年10月31日 03:58:21 +0000 (03:58 +0000)]
Fix for possible referential integrity violation when a qualified ON INSERT
rule split the query into one INSERT and one UPDATE where the UPDATE
then hit's the just created row without modifying the key fields again.
In this special case, the new key slipped in totally unchecked.
Jan
Tom Lane [2003年10月31日 03:58:15 +0000 (03:58 +0000)]
Small fix to Christopher's recent improvements --- underscore is not
a special character in regexes, but it is for LIKE, so NOT LIKE 'pg_%'
is incorrect. Need NOT LIKE 'pg\_%'.
Tom Lane [2003年10月31日 00:18:55 +0000 (00:18 +0000)]
Use Tcl ByteArray objects to avoid unwanted character set translation
in libpgtcl's lo_read/lo_write commands. Also, deal correctly with
failure return from lo_read(). ljb and Tom Lane.
Tom Lane [2003年10月30日 21:37:38 +0000 (21:37 +0000)]
Further work on tab completion code: arrange for system catalogs to be
offered for completion only when the input-so-far is at least 'pg_'.
This seems to be the best compromise behavior emerging from yesterday's
discussion. While at it, refactor code to eliminate repetitive use of
nearly identical queries, which was exceedingly tedious to maintain.
Also const-ify code more thoroughly in hopes of moving constant data into
text segment, and remove unnecessary length limit on queries.
Fix markup by using <note> for comments.
More SGML cleanup.
SGML cleanup.
Update SGML release notes with Peter's direction. Does not compile
because of section adjustments still needed.
Mark release note comments as new subsections rather than footnotes, per
Peter.
Remove "Changes" section and pull all sections below it up one level.
More comment additions.
This is the main PostgreSQL git repository.
RSS
Atom