OSDN Git Service
Bruce Momjian [Thu, 3 Jun 1999 20:45:08 +0000 (20:45 +0000)]
cleanup
Bruce Momjian [Thu, 3 Jun 1999 20:44:28 +0000 (20:44 +0000)]
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
^^^^ required
Also note that SET TRANSACTION ISOLATION LEVEL change
isolevel for _current_ transaction, in accordance with
standard, not for session (ALTER SESSION is used in Oracle,
but it's not implemented currently).
And I would don't mention SET XACTISOLEVEL TO ...
form at all.
Please update set.sgml - I failed to understand all these
SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">
now.
for Vadim
Bruce Momjian [Thu, 3 Jun 1999 20:42:18 +0000 (20:42 +0000)]
Thanks for this, but SET TRANSACTION ISOLATION LEVEL
should be described like SET TIME ZONE: TO is not allowed, as well
as DEFAULT option. There are only two forms:
for Vadim.
Bruce Momjian [Thu, 3 Jun 1999 20:40:50 +0000 (20:40 +0000)]
Update of release notes with new items.
Bruce Momjian [Thu, 3 Jun 1999 19:52:09 +0000 (19:52 +0000)]
Add mention of FOR UPDATE and LIMIT/OFFSET>
Bruce Momjian [Thu, 3 Jun 1999 19:18:00 +0000 (19:18 +0000)]
Update lock sgml/man/psql help pages.
Bruce Momjian [Thu, 3 Jun 1999 18:38:00 +0000 (18:38 +0000)]
Add SET TRANSACTION ISOLATION LEVEL and SET NAMES mention.
Bruce Momjian [Thu, 3 Jun 1999 18:25:27 +0000 (18:25 +0000)]
Update psql help so it looks better.
Bruce Momjian [Thu, 3 Jun 1999 18:18:43 +0000 (18:18 +0000)]
Update SET commands for psql \h, man pages, and sgml.
Thomas G. Lockhart [Thu, 3 Jun 1999 16:13:54 +0000 (16:13 +0000)]
Minor markup fixes.
Thomas G. Lockhart [Thu, 3 Jun 1999 16:13:35 +0000 (16:13 +0000)]
Make separate subsection for Vadim's MVCC notes.
Add timing info for v6.5 on my linux box.
Thomas G. Lockhart [Thu, 3 Jun 1999 16:11:58 +0000 (16:11 +0000)]
Fix markup and formatting.
Thomas G. Lockhart [Thu, 3 Jun 1999 16:05:38 +0000 (16:05 +0000)]
Installation notes for v6.5.
Generated from install.sgml and installation.sgml.
Vadim B. Mikheev [Thu, 3 Jun 1999 13:33:13 +0000 (13:33 +0000)]
1. Additional fix against ERROR: Child itemid marked as unused
in CommitTransaction().
2. Changes in GetSnapshotData().
Vadim B. Mikheev [Thu, 3 Jun 1999 13:25:54 +0000 (13:25 +0000)]
Unuseful tuple.t_data->t_infomask & HEAP_XMIN_COMMITTED in
vc_scanheap().
Vadim B. Mikheev [Thu, 3 Jun 1999 07:11:50 +0000 (07:11 +0000)]
Notes in Migration to v6.5 section.
Vadim B. Mikheev [Thu, 3 Jun 1999 04:41:41 +0000 (04:41 +0000)]
1. MyProc->xid assignment is moved to GetNewTransactionId so newer
transactions will not assume that MyProc transaction was committed
before snapshot calculations. With old MyProc->xid assignment
(in xact.c:StartTransaction()) there was ability to see the same
row twice (I used gdb for this)!...
2. Assignments of InvalidTransactionId to MyProc->xid and MyProc->xmin
are moved from xact.c:CommitTransaction() to
xact.c:RecordTransactionCommit() - this invalidation must be done
before releasing transaction locks or bad (too high) XmaxRecent value
might be used by vacuum ("ERROR: Child itemid marked as unused"
reported by "Hiroshi Inoue" <Inoue@tpf.co.jp>; once again, gdb
allowed me reproduce this error).
Thomas G. Lockhart [Thu, 3 Jun 1999 04:21:51 +0000 (04:21 +0000)]
Markup changes for v6.5 release.
Clean out duplicate stuff in odbc.sgml resulting from a faulty patch.
Thomas G. Lockhart [Thu, 3 Jun 1999 04:20:32 +0000 (04:20 +0000)]
CGM format from Hannu. Seem to have lost the .ag original :(
Thomas G. Lockhart [Thu, 3 Jun 1999 04:18:58 +0000 (04:18 +0000)]
New versions of hardcopy for 6.5 release.
Tom Lane [Thu, 3 Jun 1999 04:01:16 +0000 (04:01 +0000)]
pg_dump failed on any database containing large objects,
because it ignored the LOs themselves but failed to ignore the indexes
on the LOs. How long has this been broken??
Tom Lane [Thu, 3 Jun 1999 03:17:37 +0000 (03:17 +0000)]
Ensure consistent results when FormSortKeys fails to find
all the expected keys (it was returning uninitialized memory).
Tom Lane [Thu, 3 Jun 1999 01:28:24 +0000 (01:28 +0000)]
Ooops ... dllist.c can't use Assert() when it is compiled into
libpq ...
Jan Wieck [Wed, 2 Jun 1999 11:52:29 +0000 (11:52 +0000)]
Changed "current." into "old." in rule string backparsing
Jan
Bruce Momjian [Wed, 2 Jun 1999 03:37:15 +0000 (03:37 +0000)]
The INET and CIDR types mistakenly compared 198.68.123.0/24 and
198.68.123.0/27 the same when indexing them.
D'Arcy
Thomas G. Lockhart [Tue, 1 Jun 1999 17:26:18 +0000 (17:26 +0000)]
Make sure that only one intro is included in the integrated doc.
Multiple intros cause trouble since they have some section elements
(e.g. "y2k.sgml") in common leading to duplicate labels.
Include emacs formatting hints in the intro*.sgml sources.
Vadim B. Mikheev [Tue, 1 Jun 1999 09:35:39 +0000 (09:35 +0000)]
typedef struct LTAG
{
Oid relId;
Oid dbId;
union
{
BlockNumber blkno;
TransactionId xid;
} objId;
>
> Added:
> /*
> * offnum should be part of objId.tupleId above, but would increase
> * sizeof(LOCKTAG) and so moved here; currently used by userlocks only.
> */
> OffsetNumber offnum;
uint16 lockmethod; /* needed by userlocks */
} LOCKTAG;
gmake clean required...
User locks are ready for 6.5 release...
Bruce Momjian [Tue, 1 Jun 1999 02:43:37 +0000 (02:43 +0000)]
forgot to attach the patch. :(
Vince.
Bruce Momjian [Tue, 1 Jun 1999 02:37:33 +0000 (02:37 +0000)]
commented out PgConnection& references for now. May be using them
later.
Vince.
Tom Lane [Mon, 31 May 1999 23:48:04 +0000 (23:48 +0000)]
Fix some latent bugs in dllist.c (carelessness about setting
all fields that should be set). Add a MoveToFront primitive to speed up
one of the hotspots in SearchSysCache.
Tom Lane [Mon, 31 May 1999 22:53:59 +0000 (22:53 +0000)]
Clean up memory leaks in LO operations by freeing LO's private
memory context at transaction commit or abort.
Tom Lane [Mon, 31 May 1999 19:32:47 +0000 (19:32 +0000)]
Generate a more specific error message when an operator used
in an index doesn't have a restriction selectivity estimator.
Tom Lane [Mon, 31 May 1999 18:28:52 +0000 (18:28 +0000)]
Round up shmem size estimate to 1Kb boundary.
Tom Lane [Mon, 31 May 1999 17:01:52 +0000 (17:01 +0000)]
Correct serious bug in hashtable expansion routine: under the
right circumstances it would leave old and new bucket headers pointing to
the same list of records.
Bruce Momjian [Mon, 31 May 1999 16:18:53 +0000 (16:18 +0000)]
NT similar file update.
Vadim B. Mikheev [Mon, 31 May 1999 01:48:13 +0000 (01:48 +0000)]
Release XactLockTable share lock immediately after this lock is acquired
(no sense to hold it) or we'll be out of lock entries.
Great thanks to Hiroshi Inoue.
Tom Lane [Sun, 30 May 1999 15:32:45 +0000 (15:32 +0000)]
Clean up uninitialized-variable warning from egcs.
(Curious that gcc doesn't complain about this code...).
Tom Lane [Sun, 30 May 1999 15:22:34 +0000 (15:22 +0000)]
egcs thinks omitting the return type in a function declaration
is poor coding style. I agree.
Tom Lane [Sun, 30 May 1999 15:17:58 +0000 (15:17 +0000)]
Replace static rcsid[] strings by IDENTIFICATION comments in
file headers, to conform to established Postgres coding style and avoid
warnings from gcc.
Tom Lane [Sun, 30 May 1999 00:06:44 +0000 (00:06 +0000)]
configure.in forgot to do AC_LANG_C to reselect C-based tests
after checking for presence of C++ compiler. Odd we hadn't seen any
reports of problems before...
Tom Lane [Sat, 29 May 1999 16:26:42 +0000 (16:26 +0000)]
Turns out that configure's test for HPUXMATHLIB didn't work
when used with egcs --- now it does.
Vadim B. Mikheev [Sat, 29 May 1999 10:25:33 +0000 (10:25 +0000)]
1. Run all pg_dump queries in single serializable transaction.
2. Get rid of locking when updating statistics in vacuum.
3. Use QuerySnapshot in COPY TO and call SetQuerySnashot
in main tcop loop before FETCH and COPY TO.
Vadim B. Mikheev [Sat, 29 May 1999 06:14:43 +0000 (06:14 +0000)]
Fix xid table sizing.
Tom Lane [Sat, 29 May 1999 03:58:43 +0000 (03:58 +0000)]
Missing semicolons in non-HAS_TEST_AND_SET code paths :-(
Tom Lane [Sat, 29 May 1999 03:17:20 +0000 (03:17 +0000)]
Avoid redundant SysCache searches in coerce_type, for another
few percent speedup in INSERT...
Tom Lane [Sat, 29 May 1999 01:48:06 +0000 (01:48 +0000)]
new_relation_targetlist used to cause about 8 separate (and
redundant) SearchSysCache searches per table column in an INSERT, which
accounted for a good percentage of the CPU time for INSERT ... VALUES().
Now it only does two searches in the typical case.
Tom Lane [Sat, 29 May 1999 01:45:21 +0000 (01:45 +0000)]
Clean up inefficient and just plain bad code in some hot-spot
cache access routines.
Tom Lane [Fri, 28 May 1999 17:03:31 +0000 (17:03 +0000)]
Repair performance problem in SI segment manipulations: iterating
through MAXBACKENDS array entries used to be fine when MAXBACKENDS = 64.
It's not so cool with MAXBACKENDS = 1024 (or more!), especially not in a
frequently-used routine like SIDelExpiredDataEntries. Repair by making
procState array size be the soft MaxBackends limit rather than the hard
limit, and by converting SIGetProcStateLimit() to a macro.
Bruce Momjian [Fri, 28 May 1999 14:24:24 +0000 (14:24 +0000)]
Clean up mention of gmake vs. make.
Bruce Momjian [Fri, 28 May 1999 04:54:34 +0000 (04:54 +0000)]
Update pygresql version stamp.
Tom Lane [Fri, 28 May 1999 01:54:53 +0000 (01:54 +0000)]
When closure of the backend connection is detected during pqFlush,
do the right thing: look for a NOTICE message from the backend before we
close our side of the socket. 6.4 libpq did not reliably print the backend's
hara-kiri message, 'The Postmaster has informed me ...', because it only
did the right thing if connection closure was detected during a read
attempt instead of a write attempt.
Bruce Momjian [Thu, 27 May 1999 16:29:05 +0000 (16:29 +0000)]
Make pg_dump dump ACL's by default, print warning on use of -z, and add
new -x option to skip acl dump.
Thomas G. Lockhart [Thu, 27 May 1999 16:06:33 +0000 (16:06 +0000)]
More info is in sgml and html docs so this is now obsolete.
Thomas G. Lockhart [Thu, 27 May 1999 16:05:38 +0000 (16:05 +0000)]
FAQs contributed for this release.
Thomas G. Lockhart [Thu, 27 May 1999 15:49:15 +0000 (15:49 +0000)]
Markup fixes.
Thomas G. Lockhart [Thu, 27 May 1999 15:49:08 +0000 (15:49 +0000)]
Markup fixes.
Update for v6.5 release.
Thomas G. Lockhart [Thu, 27 May 1999 15:48:14 +0000 (15:48 +0000)]
Significant updates from Vince Vielhaber.
Thomas G. Lockhart [Thu, 27 May 1999 15:47:28 +0000 (15:47 +0000)]
Remove disclaimer about exact numeric types. They work now!
Thomas G. Lockhart [Thu, 27 May 1999 15:46:22 +0000 (15:46 +0000)]
Refresh FreeBSD info.
Thomas G. Lockhart [Thu, 27 May 1999 15:44:54 +0000 (15:44 +0000)]
Significant update from Vince Vielhaber.
Bruce Momjian [Thu, 27 May 1999 15:13:43 +0000 (15:13 +0000)]
Update release notes for 6.5.
Bruce Momjian [Thu, 27 May 1999 15:05:57 +0000 (15:05 +0000)]
Clean up release sgml file.
Bruce Momjian [Thu, 27 May 1999 14:28:40 +0000 (14:28 +0000)]
I am not sure if libpq++ will compile with non g++ compilers,
but the Makefile does break non g++.
<<mak.patch>>
Andreas
Bruce Momjian [Thu, 27 May 1999 04:09:45 +0000 (04:09 +0000)]
Fix for crypt memory leak, from James Thompson
Tom Lane [Wed, 26 May 1999 22:57:39 +0000 (22:57 +0000)]
Patch from Andreas: when CREATE TABLE is followed by CREATE INDEX
before any tuples are loaded, preserve the default '1000 tuples' table
size estimate.
Tom Lane [Wed, 26 May 1999 21:51:13 +0000 (21:51 +0000)]
Fix pg_dump to use the same maximum-query-size constant as
the backend does. Remove unnecessary limitation on field size in
dumpClasses_dumpData (ie, -d or -D case).
Bruce Momjian [Wed, 26 May 1999 20:55:06 +0000 (20:55 +0000)]
Fix compile of plpgsql by adding 'extern int yylineno.'
Bruce Momjian [Wed, 26 May 1999 20:08:06 +0000 (20:08 +0000)]
Display numeric precision on \d.
Bruce Momjian [Wed, 26 May 1999 19:45:53 +0000 (19:45 +0000)]
Allow GROUPs to be dumped properly.
Thomas G. Lockhart [Wed, 26 May 1999 17:30:30 +0000 (17:30 +0000)]
Add chapters on CVS access, MVCC, SQL theory to the docs.
Add an appendix with more details on date/time attributes and handling.
Update most references to Postgres version numbers to 6.5,
*except* for the porting list which will require a report
from a successful installation to be updated.
Thomas G. Lockhart [Wed, 26 May 1999 17:27:39 +0000 (17:27 +0000)]
Chapter on multi-version concurrency control from Vadim.
Some wording changes from Vadim's original text doc.
Processes cleanly, but may need fixup.
Thomas G. Lockhart [Wed, 26 May 1999 17:26:32 +0000 (17:26 +0000)]
Add new reference pages for postmaster and postgres.
Normalize markup for vacuumdb; content is the same.
Thomas G. Lockhart [Wed, 26 May 1999 17:25:38 +0000 (17:25 +0000)]
First copy from the man pages.
postgres-ref.sgml is not yet marked up.
Bruce Momjian [Wed, 26 May 1999 16:19:48 +0000 (16:19 +0000)]
Fix for NT from Horak Daniel
Bruce Momjian [Wed, 26 May 1999 16:06:45 +0000 (16:06 +0000)]
Disable use of -o and -d pg_dump options together. Can't set oids in
inserts. Change some variables to bool to be clearer.
Bruce Momjian [Wed, 26 May 1999 15:20:04 +0000 (15:20 +0000)]
Add fix for 0x7fU constants to pgindent
Bruce Momjian [Wed, 26 May 1999 14:50:38 +0000 (14:50 +0000)]
Allow pg_dump -v display proper table/sequence count display.
Bruce Momjian [Wed, 26 May 1999 12:57:23 +0000 (12:57 +0000)]
Make functions static or NOT_USED as appropriate.
Marc G. Fournier [Wed, 26 May 1999 01:22:24 +0000 (01:22 +0000)]
Give BEOS a chance ...
Bruce Momjian [Tue, 25 May 1999 22:43:53 +0000 (22:43 +0000)]
Another pgindent run. Sorry folks.
Bruce Momjian [Tue, 25 May 1999 22:04:56 +0000 (22:04 +0000)]
Make 0x007f -> (unsigned)0x7f to make pgindent happy.
Vadim B. Mikheev [Tue, 25 May 1999 18:31:28 +0000 (18:31 +0000)]
Get rid of page-level locking in btree-s.
BT_READ/BT_WRITE are BUFFER_LOCK_SHARE/BUFFER_LOCK_EXCLUSIVE now.
Also get rid of #define BT_VERSION_1 - we use version 1 as default
for near two years now.
Vadim B. Mikheev [Tue, 25 May 1999 18:20:31 +0000 (18:20 +0000)]
Get rid of page-level locking in btree-s.
LockBuffer is used to acquire read/write access
to index pages. Pages are released before leaving
index internals.
Bruce Momjian [Tue, 25 May 1999 16:15:34 +0000 (16:15 +0000)]
pgindent run over code.
Michael Meskes [Tue, 25 May 1999 13:36:15 +0000 (13:36 +0000)]
*** empty log message ***
Jan Wieck [Tue, 25 May 1999 13:16:10 +0000 (13:16 +0000)]
Bugfix - Range table entries that are unused after rewriting should
not be marked inFromCl any longer. Otherwise the planner gets confused
and joins over them where in fact it does not have to.
Adjust hasSubLinks now with a recursive lookup - could be wrong in
multi action rules because parse state isn't reset correctly and all
actions in the rule are marked hasSubLinks if one of them has.
Jan
Jan Wieck [Tue, 25 May 1999 08:49:33 +0000 (08:49 +0000)]
Fixed bug in rules event qualification output.
Jan
Bruce Momjian [Tue, 25 May 1999 05:29:38 +0000 (05:29 +0000)]
FIx for 0.0.0.0/0 output as 00/0.
Tom Lane [Sun, 23 May 1999 21:42:09 +0000 (21:42 +0000)]
Do not assign output columns to junk attributes created from
GROUP BY or ORDER BY expressions in INSERT ... SELECT.
Tom Lane [Sun, 23 May 1999 21:41:14 +0000 (21:41 +0000)]
Detect case of invalid use of GROUP BY when there are no
aggregate functions, as in
select a, b from foo group by a;
The ungrouped reference to b is not kosher, but formerly we neglected to
check this unless there was an aggregate function somewhere in the query.
Bruce Momjian [Sun, 23 May 1999 19:01:18 +0000 (19:01 +0000)]
Remove more -B parameters not needed.
Bruce Momjian [Sun, 23 May 1999 18:53:30 +0000 (18:53 +0000)]
Remove -B from wisconsin test.
Vadim B. Mikheev [Sun, 23 May 1999 09:10:24 +0000 (09:10 +0000)]
Fix tuple chain moving bug found by "Hiroshi Inoue" <Inoue@tpf.co.jp>.
Bruce Momjian [Sun, 23 May 1999 01:04:07 +0000 (01:04 +0000)]
Here it is. Remove or rename the current interfaces/libpq++ and untar
this file in interfaces/
It will all need to be checked in. I used the char *rcsid[] method for
cvs ids so it can be strings | grep'd to find version numbers. The new
version for the library is 3.0.
Run configure from src/ to create the Makefile and it should be good to
go.
I did minimal documentation references in the README, I'll see if I can
get something to Tom Lockhart rather quickly.
Vince.
Tom Lane [Sat, 22 May 1999 23:59:59 +0000 (23:59 +0000)]
Update commentary in sample GEQO config file.
Tom Lane [Sat, 22 May 1999 23:27:19 +0000 (23:27 +0000)]
Reduce default GEQO 'effort' setting to MEDIUM always.
This agrees with the documentation and seems like a more useful default
anyhow ...
Tom Lane [Sat, 22 May 1999 23:19:37 +0000 (23:19 +0000)]
Modify aset.c logic so that blocks requested from malloc get
bigger the more space is used in an allocset. This reduces the malloc
overhead very substantially on queries that need lots of memory.
Tom Lane [Sat, 22 May 1999 19:49:42 +0000 (19:49 +0000)]
Improve error message from failed LOAD command (include
kernel's error description when file is not accessible).
Tom Lane [Sat, 22 May 1999 19:29:01 +0000 (19:29 +0000)]
Allow GEQO effort to be specified numerically, as well as
symbolic LOW/MEDIUM/HIGH values --- needed for experiments with other
effort levels ...
Tom Lane [Sat, 22 May 1999 17:47:54 +0000 (17:47 +0000)]
Modify backend switch parsing to prevent 'insecure' switches
from being accepted when they are passed from client connection request.
Get rid of a couple that no longer do anything (like -P).