OSDN Git Service
Peter Eisentraut [Sat, 13 Jan 2001 03:25:48 +0000 (03:25 +0000)]
Windows wants shared libraries in PATH.
Marc G. Fournier [Sat, 13 Jan 2001 03:17:05 +0000 (03:17 +0000)]
check one last time for any erros ...
Peter Eisentraut [Sat, 13 Jan 2001 03:11:12 +0000 (03:11 +0000)]
New shell for the to be written CHECKPOINT documentation, so the summary
shows up in psql now.
Marc G. Fournier [Sat, 13 Jan 2001 03:11:07 +0000 (03:11 +0000)]
ignore his too
Marc G. Fournier [Sat, 13 Jan 2001 03:09:43 +0000 (03:09 +0000)]
and this time?
Marc G. Fournier [Sat, 13 Jan 2001 03:08:02 +0000 (03:08 +0000)]
try this again ...
Peter Eisentraut [Sat, 13 Jan 2001 02:18:31 +0000 (02:18 +0000)]
Clean up garbage.
Peter Eisentraut [Sat, 13 Jan 2001 02:14:32 +0000 (02:14 +0000)]
Surely one README file is enough.
Bruce Momjian [Sat, 13 Jan 2001 01:49:35 +0000 (01:49 +0000)]
Update pgcvslog to fix problem with duplicate narratives.
Marc G. Fournier [Sat, 13 Jan 2001 00:57:06 +0000 (00:57 +0000)]
okay, this appears to work ...
onlly changes aer adding some white space ...
Peter Eisentraut [Fri, 12 Jan 2001 22:36:57 +0000 (22:36 +0000)]
Surely we don't need a 7.0.3 makefile in 7.1.
Peter Eisentraut [Fri, 12 Jan 2001 22:15:32 +0000 (22:15 +0000)]
Update information about compiling extension modules.
Tom Lane [Fri, 12 Jan 2001 21:54:01 +0000 (21:54 +0000)]
Add more critical-section calls: all code sections that hold spinlocks
are now critical sections, so as to ensure die() won't interrupt us while
we are munging shared-memory data structures. Avoid insecure intermediate
states in some code that proc_exit will call, like palloc/pfree. Rename
START/END_CRIT_CODE to START/END_CRIT_SECTION, since that seems to be
what people tend to call them anyway, and make them be called with () like
a function call, in hopes of not confusing pg_indent.
I doubt that this is sufficient to make SIGTERM safe anywhere; there's
just too much code that could get invoked during proc_exit().
Bruce Momjian [Fri, 12 Jan 2001 17:57:57 +0000 (17:57 +0000)]
Update TODO list.
Bruce Momjian [Fri, 12 Jan 2001 17:48:18 +0000 (17:48 +0000)]
Update TODO list.
Philip Warner [Fri, 12 Jan 2001 15:41:29 +0000 (15:41 +0000)]
Fixed handling of renamed columns in PK constraints
Bruce Momjian [Fri, 12 Jan 2001 05:37:37 +0000 (05:37 +0000)]
Add to DROP todo.
Bruce Momjian [Fri, 12 Jan 2001 05:32:38 +0000 (05:32 +0000)]
Update TODO list.
Bruce Momjian [Fri, 12 Jan 2001 05:23:10 +0000 (05:23 +0000)]
Update TODO list.
Tom Lane [Fri, 12 Jan 2001 05:06:40 +0000 (05:06 +0000)]
Bring CREATE TABLE syntax synopsis into line with reality; update a
bunch of old or poorly-worded documentation.
Philip Warner [Fri, 12 Jan 2001 04:32:07 +0000 (04:32 +0000)]
- Check ntuples == 1 for various SELECT statements.
- Fix handling of --tables=* (multiple tables never worked properly, AFAICT)
- strdup() the current user in DB routines
- Check results of IO routines more carefully.
- Check results of PQ routines more carefully.
Have not fixed index output yet.
Tom Lane [Fri, 12 Jan 2001 01:22:21 +0000 (01:22 +0000)]
Preserve constraints and column defaults during CLUSTER.
Wish they were all this easy ...
Marc G. Fournier [Fri, 12 Jan 2001 00:16:26 +0000 (00:16 +0000)]
commit Oleg and Teodor's RD-tree implementation ... this provides the
regression tests for the GiST changes ... this should be integrated into
the regular regression tests similar to Vadim's SPI contrib stuff ...
Marc G. Fournier [Fri, 12 Jan 2001 00:12:58 +0000 (00:12 +0000)]
New feature:
1. Support of variable size keys - new algorithm of insertion to tree
(GLI - gist layrered insertion). Previous algorithm was implemented
as described in paper by Joseph M. Hellerstein et.al
"Generalized Search Trees for Database Systems". This (old)
algorithm was not suitable for variable size keys and could be
not effective ( walking up-down ) in case of multiple levels split
Bug fixed:
1. fixed bug in gistPageAddItem - key values were written to disk
uncompressed. This caused failure if decompression function
does real job.
2. NULLs handling - we keep NULLs in tree. Right way is to remove them,
but we don't know how to inform vacuum about index statistics. This is
just cosmetic warning message (like in case with R-Tree),
but I'm not sure how to recognize real problem if we remove NULLs
and suppress this warning as Tom suggested.
3. various memory leaks
This work was done by Teodor Sigaev (teodor@stack.net) and
Oleg Bartunov (oleg@sai.msu.su).
Peter Eisentraut [Thu, 11 Jan 2001 23:32:03 +0000 (23:32 +0000)]
#ifdef out entire file for newer Cygwin versions.
Peter Eisentraut [Thu, 11 Jan 2001 23:28:34 +0000 (23:28 +0000)]
Add DLLIMPORT to TransactionCommandContext.
Peter Eisentraut [Thu, 11 Jan 2001 23:27:05 +0000 (23:27 +0000)]
Remove useless DLLIMPORT (only needed in header files).
Bruce Momjian [Thu, 11 Jan 2001 21:07:07 +0000 (21:07 +0000)]
Update TODO list.
Marc G. Fournier [Thu, 11 Jan 2001 04:13:30 +0000 (04:13 +0000)]
reduce HISTORY changes from this list too
Marc G. Fournier [Thu, 11 Jan 2001 04:12:32 +0000 (04:12 +0000)]
remove all the TODO updates, which drops of 12k from the file ...
Marc G. Fournier [Thu, 11 Jan 2001 04:00:59 +0000 (04:00 +0000)]
using cvs2cl.pl, generate a list of changes from beta1->beta3 ...
Peter Eisentraut [Wed, 10 Jan 2001 17:07:18 +0000 (17:07 +0000)]
Make checks for global variables (sys_nerr, timezone) safe against getting
optimized away completely.
Hiroshi Inoue [Wed, 10 Jan 2001 01:24:19 +0000 (01:24 +0000)]
Removed a no longer needed SetWaitingForLock() call in
DeadLockCheck().
Tom Lane [Wed, 10 Jan 2001 01:12:28 +0000 (01:12 +0000)]
Do The Right Thing (tm) if asked to cluster a temp table. Previous
code would cluster, but table would magically lose its tempness.
Michael Meskes [Tue, 9 Jan 2001 19:46:05 +0000 (19:46 +0000)]
Synced preproc.y with gram.y.
Peter Eisentraut [Tue, 9 Jan 2001 18:45:41 +0000 (18:45 +0000)]
Remove -L$(libdir) from DLLLIBS to prevent linking with an old version
(i.e., 7.0.3) of libpostgres.a. From Jason Tishler <jt@dothill.com>.
Peter Eisentraut [Tue, 9 Jan 2001 18:40:15 +0000 (18:40 +0000)]
Add configure check for sys_nerr, to end all discussions.
Bruce Momjian [Tue, 9 Jan 2001 18:06:07 +0000 (18:06 +0000)]
Update TODO list.
Bruce Momjian [Tue, 9 Jan 2001 16:07:14 +0000 (16:07 +0000)]
The KAME files md5.* and sha1.* have the following changelog
entry:
----------------------------
revision 1.2
date: 2000/12/04 01:20:38; author: tgl; state: Exp; lines:
+18 -18
Eliminate some of the more blatant platform-dependencies ... it
builds here now, anyway ...
----------------------------
Which basically changes u_int*_t -> uint*_t, so now it does not
compile neither under Debian 2.2 nor under NetBSD 1.5 which
is platform independent<B8> all right. Also it replaces $KAME$
with $Id$ which is Bad Thing. PostgreSQL Id should be added as a
separate line so the file history could be seen.
So here is patch:
* changes uint*_t -> uint*. I guess that was the original
intention
* adds uint64 type to include/c.h because its needed
[somebody should check if I did it right]
* adds back KAME Id, because KAME is the master repository
* removes stupid c++ comments in pgcrypto.c
* removes <sys/types.h> from the code, its not needed
--
marko
Marko Kreen
Bruce Momjian [Tue, 9 Jan 2001 16:05:21 +0000 (16:05 +0000)]
Apply proper sql.sgml change.
Bruce Momjian [Tue, 9 Jan 2001 15:48:18 +0000 (15:48 +0000)]
Attached is a doc patch for doc/src/sgml/sql.sgml.
It adds information about SQL JOIN that is implemented in 7.1.
--
-------- Robert B. Easter
Bruce Momjian [Tue, 9 Jan 2001 15:37:39 +0000 (15:37 +0000)]
Update TODO list.
Bruce Momjian [Tue, 9 Jan 2001 15:26:16 +0000 (15:26 +0000)]
A patch for doc/src/sgml/plsql.sgml to add a little more info about PL/pgSQL
EXECUTE.
--
-------- Robert B. Easter
Bruce Momjian [Tue, 9 Jan 2001 14:23:40 +0000 (14:23 +0000)]
Approaching the current documentation from a position of ignorance, I
find it ambiguous. I propose something along the lines of the
following patch to clarify it. Thanks.
(Alternatively, perhaps the code could maintain a count of nested
calls to SPI_connect/SPI_finish. But I didn't try to write that
patch.)
Ian Lance Taylor
Bruce Momjian [Tue, 9 Jan 2001 14:12:34 +0000 (14:12 +0000)]
Update TODO list.
Bruce Momjian [Tue, 9 Jan 2001 13:52:02 +0000 (13:52 +0000)]
Update TODO list.
Bruce Momjian [Tue, 9 Jan 2001 13:48:03 +0000 (13:48 +0000)]
Update TODO list.
PostgreSQL Daemon [Tue, 9 Jan 2001 13:11:32 +0000 (13:11 +0000)]
jump version to beta3 ... beta2 was created and pulled due to a couple of
large-ish bugs that Tom and Vadim were able to fix, but to avoid any
confusion, beta2 was removed ... and for tag'ng purposes, beta3 is being
created ...
Tatsuo Ishii [Tue, 9 Jan 2001 09:54:11 +0000 (09:54 +0000)]
Add a README file for multi-byte. This file is contributed by
Chih-Chang Hsieh <cch@cc.kmu.edu.tw>, written in traditional Chinese
(Big5).
Hiroshi Inoue [Tue, 9 Jan 2001 09:38:57 +0000 (09:38 +0000)]
Disable query cancel during HandleDeadLock().
Vadim B. Mikheev [Tue, 9 Jan 2001 06:24:33 +0000 (06:24 +0000)]
1. Checkpoint.undo may be after checkpoint itself:
- no more elog(STOP) in StartupXLOG();
- both checkpoint' undo & redo are used to define
oldest on-line log file.
2. Ability to pre-allocate a few log files at checkpoint time
(wal_files option). Off by default.
Bruce Momjian [Tue, 9 Jan 2001 06:16:23 +0000 (06:16 +0000)]
Update TODO list.
Tatsuo Ishii [Tue, 9 Jan 2001 04:40:31 +0000 (04:40 +0000)]
README.mb has been unified into SGML documents.
Tom Lane [Tue, 9 Jan 2001 03:48:51 +0000 (03:48 +0000)]
Fix oversight in planning of GROUP queries: when an expression is used
as both a GROUP BY item and an output expression, the top-level Group
node should just copy up the evaluated expression value from its input,
rather than re-evaluating the expression. Aside from any performance
benefit this might offer, this avoids a crash when there is a sub-SELECT
in said expression.
Tom Lane [Tue, 9 Jan 2001 02:15:16 +0000 (02:15 +0000)]
Fix small but critical typo ...
Tom Lane [Mon, 8 Jan 2001 23:02:36 +0000 (23:02 +0000)]
Prevent vacuumdb from trying to vacuum template0.
Tom Lane [Mon, 8 Jan 2001 22:07:47 +0000 (22:07 +0000)]
Document the system attributes ctid and tableoid, which for some reason
were never yet mentioned anywhere in our documentation. Improve
explanations of the other system attributes, too.
Tom Lane [Mon, 8 Jan 2001 21:30:37 +0000 (21:30 +0000)]
Document that we don't support ORDER BY with general expressions on
the output of UNION/INTERSECT/EXCEPT.
Peter Eisentraut [Mon, 8 Jan 2001 21:01:54 +0000 (21:01 +0000)]
Add rudimentary section about controlling kernel's file and process limits.
Bruce Momjian [Mon, 8 Jan 2001 20:54:24 +0000 (20:54 +0000)]
Remove compiler warning about uninitialized warnings.
Tom Lane [Mon, 8 Jan 2001 20:32:27 +0000 (20:32 +0000)]
check for failure after vacuuming each DB, not only the last one.
Tom Lane [Mon, 8 Jan 2001 18:34:44 +0000 (18:34 +0000)]
Add some debugging support code (ifdef'd out in normal use).
Tom Lane [Mon, 8 Jan 2001 18:31:49 +0000 (18:31 +0000)]
LockBuffer should not elog while holding buffer's cntx_lock.
Hiroshi Inoue [Mon, 8 Jan 2001 03:14:58 +0000 (03:14 +0000)]
Keep relations open until they are no longer needed.
Tom Lane [Mon, 8 Jan 2001 00:31:43 +0000 (00:31 +0000)]
Make outfuncs/readfuncs treat OIDs properly as unsigned values. Clean up
inconsistent coding practices for handling Index values and booleans,
too.
Tom Lane [Sun, 7 Jan 2001 22:14:31 +0000 (22:14 +0000)]
Correct nasty error in heap_update: it was releasing the buffer refcount
before calling RelationInvalidateHeapTuple(), which is bad because the
latter needs to look at the tuple data, which is in the shared disk
buffer. If another backend manages to recycle the buffer while this
is going on, we will compute the wrong hashindex for the tuple or
maybe even crash outright. Must hold buffer refcount until afterwards.
(This bug is not in 7.0.*; seems to be have introduced during WAL changes.)
Tom Lane [Sun, 7 Jan 2001 04:30:41 +0000 (04:30 +0000)]
Clear QueryCancel and ProcDiePending at start of proc_exit, to ensure
that leftover cancel/die requests cannot interfere with exit activities.
Tom Lane [Sun, 7 Jan 2001 04:17:29 +0000 (04:17 +0000)]
Fix recent breakage of query-cancel logic, see my pghackers message
of 6 Jan 2001 21:55.
PostgreSQL Daemon [Sun, 7 Jan 2001 02:23:25 +0000 (02:23 +0000)]
tag configure as beta2 ..
Tom Lane [Sun, 7 Jan 2001 01:14:35 +0000 (01:14 +0000)]
Resultmap updates for OpenBSD, per report from bpalmer@crimelabs.net.
Tom Lane [Sun, 7 Jan 2001 01:08:48 +0000 (01:08 +0000)]
Modify readfuncs so that recursive use of stringToNode will not crash
and burn. Just for added luck, change reading of CONST nodes so that
we do not need to consult pg_type rows while reading them; this means
that no database access occurs during stringToNode. This requires
changing the order in which const-node fields are written, which means
an initdb is forced.
Tom Lane [Sun, 7 Jan 2001 00:05:22 +0000 (00:05 +0000)]
Clean up checking of relkind for ALTER TABLE and LOCK TABLE commands.
Disallow cases like adding constraints to sequences :-(, and eliminate
now-unnecessary search of pg_rewrite to decide if a relation is a view.
Tom Lane [Sat, 6 Jan 2001 21:59:39 +0000 (21:59 +0000)]
Log memory context stats to stderr when reporting a 'Memory exhausted'
error, so as to provide a starting point for debugging.
Tom Lane [Sat, 6 Jan 2001 21:53:18 +0000 (21:53 +0000)]
Fix memory leak in relcache handling of rules: allocate rule parsetrees
in per-entry sub-memory-context, where they were supposed to go, rather
than in CacheMemoryContext where the code was putting them. Must've
suffered a severe brain fade when I wrote this :-(
Peter Eisentraut [Sat, 6 Jan 2001 21:24:01 +0000 (21:24 +0000)]
Use more portable syntax for 'find'.
Peter Eisentraut [Sat, 6 Jan 2001 20:57:26 +0000 (20:57 +0000)]
Polish help output. Allow --help to work with BSD getopts.
Tom Lane [Sat, 6 Jan 2001 17:43:01 +0000 (17:43 +0000)]
No need for screen_size to be static.
Peter Eisentraut [Sat, 6 Jan 2001 16:54:16 +0000 (16:54 +0000)]
Simplify rules to build man pages so they run a lot faster and create less
noise.
Tatsuo Ishii [Sat, 6 Jan 2001 12:38:28 +0000 (12:38 +0000)]
Update multibyte Japanese doc for 7.1.
Peter Eisentraut [Sat, 6 Jan 2001 12:26:08 +0000 (12:26 +0000)]
EXECUTE documentation, from "Robert B. Easter" <reaster@comptechnews.com>.
I threw in spell check run over the whole file.
Peter Eisentraut [Sat, 6 Jan 2001 11:58:56 +0000 (11:58 +0000)]
Update section on SQL syntax. (Still a lot to be done though.) Add
appendix with comprehensive list of key words.
Peter Eisentraut [Sat, 6 Jan 2001 10:50:02 +0000 (10:50 +0000)]
Simplify the rules that explicitly allowed TYPE as a type name (which is
no longer the case). Add AND and TRAILING to ColLabel. All key words
except AS are now at least ColLabel's.
Tom Lane [Sat, 6 Jan 2001 04:14:35 +0000 (04:14 +0000)]
Bring CREATE RULE reference page into some semblance of agreement with
what's actually implemented.
Tatsuo Ishii [Sat, 6 Jan 2001 03:33:17 +0000 (03:33 +0000)]
Fix copy to make it more robust against unexpected character
sequences. This is done by disabling multi-byte awareness when it's
not necessary. This is kind of a workaround, not a perfect solution.
However, there is no ideal way to parse broken multi-byte character
sequences. So I guess this is the best way what we could do right
now...
Hiroshi Inoue [Sat, 6 Jan 2001 01:48:59 +0000 (01:48 +0000)]
init_irels() is changed to be called in RelationCacheInitializePhase2()
so that transactional control could guarantee the consistency.
Tom Lane [Sat, 6 Jan 2001 01:43:01 +0000 (01:43 +0000)]
Fix NOT NULL option for plpgsql variables (doesn't look like it
could ever have worked...)
Tom Lane [Sat, 6 Jan 2001 01:39:01 +0000 (01:39 +0000)]
Fix misplaced strdup(), which could lead to error messages referencing
deallocated memory later on.
Tom Lane [Fri, 5 Jan 2001 22:54:37 +0000 (22:54 +0000)]
Rename and document some invalidation routines to make it clearer that
they don't themselves flush any cache entries, only add to to-do lists
that will be processed later.
Tom Lane [Fri, 5 Jan 2001 06:34:23 +0000 (06:34 +0000)]
Remove not-really-standard implementation of CREATE TABLE's UNDER clause,
and revert documentation to describe the existing INHERITS clause
instead, per recent discussion in pghackers. Also fix implementation
of SQL_inheritance SET variable: it is not cool to look at this var
during the initial parsing phase, only during parse_analyze(). See
recent bug report concerning misinterpretation of date constants just
after a SET TIMEZONE command. gram.y really has to be an invariant
transformation of the query string to a raw parsetree; anything that
can vary with time must be done during parse analysis.
Tom Lane [Fri, 5 Jan 2001 02:58:16 +0000 (02:58 +0000)]
Disallow creation of a child table by a user who does not own the parent
table, per pghackers discussion around 22-Dec-00.
Bruce Momjian [Thu, 4 Jan 2001 18:51:18 +0000 (18:51 +0000)]
Update TODO list.
Peter Eisentraut [Thu, 4 Jan 2001 17:58:48 +0000 (17:58 +0000)]
Allow NetBSD's libedit to be used instead of GNU Readline. (This simply
amounts to checking for -ledit instead of -lreadline.)
Peter Eisentraut [Thu, 4 Jan 2001 17:25:09 +0000 (17:25 +0000)]
Correct path where to check for password file existance.
Bruce Momjian [Thu, 4 Jan 2001 08:24:59 +0000 (08:24 +0000)]
Update TODO list.
Bruce Momjian [Thu, 4 Jan 2001 08:15:19 +0000 (08:15 +0000)]
Update TODO list.
Bruce Momjian [Thu, 4 Jan 2001 08:13:26 +0000 (08:13 +0000)]
Update TODO list.
Tom Lane [Thu, 4 Jan 2001 02:38:02 +0000 (02:38 +0000)]
Clean up some unnecessary fragility in EXECUTE command.
Tom Lane [Thu, 4 Jan 2001 02:36:52 +0000 (02:36 +0000)]
Repair guaranteed core dump in SPI_exec(). Guess this routine wasn't
used before ...
Hiroshi Inoue [Thu, 4 Jan 2001 02:24:22 +0000 (02:24 +0000)]
I neglected to remove a debug message,sorry.
Tom Lane [Thu, 4 Jan 2001 01:23:47 +0000 (01:23 +0000)]
pg_dump failed to handle backslashes embedded in function definitions
(and most other places where it needed to output a string literal, too,
except for data INSERT statements). Per bug report from Easter, 12/1/00.