OSDN Git Service
Tom Lane [Sat, 19 Jun 1999 00:44:44 +0000 (00:44 +0000)]
Temporarily disable error checks for missing selectivity
functions, in order to work around oversight in 6.5 release: rtree
index functions haven't got any. Mea culpa ...
Bruce Momjian [Fri, 18 Jun 1999 16:47:23 +0000 (16:47 +0000)]
Patch to allow vacuum on multi-segment tables, from Hiroshi Inoue
Thomas G. Lockhart [Fri, 18 Jun 1999 05:03:48 +0000 (05:03 +0000)]
Incorporate fixes from Date and Darwen, 1997.
Did not check the function declarations as carefully as the other parts,
though all of the function names *do* match up with D&D.
Bruce Momjian [Fri, 18 Jun 1999 00:46:11 +0000 (00:46 +0000)]
linux_ppc now use -O0 to fix problem in optimization of fmgr calls.
Tom Lane [Thu, 17 Jun 1999 23:45:32 +0000 (23:45 +0000)]
Explain didn't handle inheritance correctly (it didn't
manipulate rtable the same way executor does).
Tom Lane [Thu, 17 Jun 1999 22:21:41 +0000 (22:21 +0000)]
Defend against function calls with more than 8 arguments (code
used to overrun its fixed-size arrays before detecting error; not cool).
Also, replace uses of magic constant '8' with 'MAXFARGS'.
Bruce Momjian [Thu, 17 Jun 1999 15:16:09 +0000 (15:16 +0000)]
Remove QUERY_LIMIT and documenation on same. Change _ALIGN to TYPEALIGN
for Irix.
Thomas G. Lockhart [Thu, 17 Jun 1999 14:19:17 +0000 (14:19 +0000)]
Add CLI required header and examples from SQL3/SQL98
August 1994 draft standard.
Use the ecpg support libraries to write the CLI interface?
Date and Darwen claim that CLI is a more modern and flexible approach...
Bruce Momjian [Thu, 17 Jun 1999 13:44:43 +0000 (13:44 +0000)]
Make linux_ppc use only -O, not -O2.
Michael Meskes [Wed, 16 Jun 1999 18:35:51 +0000 (18:35 +0000)]
*** empty log message ***
Michael Meskes [Wed, 16 Jun 1999 18:25:50 +0000 (18:25 +0000)]
*** empty log message ***
Bruce Momjian [Wed, 16 Jun 1999 18:09:59 +0000 (18:09 +0000)]
Add NT readme file.
Bruce Momjian [Wed, 16 Jun 1999 11:01:17 +0000 (11:01 +0000)]
Cleanup
Tom Lane [Mon, 14 Jun 1999 17:49:06 +0000 (17:49 +0000)]
Undo Jan's typo that broke regress.sh's detection of system
type name.
Thomas G. Lockhart [Mon, 14 Jun 1999 16:33:46 +0000 (16:33 +0000)]
Fix cross-reference to large objects.
Thomas G. Lockhart [Mon, 14 Jun 1999 16:32:41 +0000 (16:32 +0000)]
Fix cross-reference to large objects in the CREATE TYPE section.
Thomas G. Lockhart [Mon, 14 Jun 1999 15:57:24 +0000 (15:57 +0000)]
Release notes from sgml.
Came out with max 79 columns from Applix by defining the page width at
10 inches and the right margin at 9.5 inches, then exporting
as "ASCII Layout".
Thomas G. Lockhart [Mon, 14 Jun 1999 07:41:04 +0000 (07:41 +0000)]
Put in CREATE TABLE AS and SELECT INTO reference pages.
Left them out after splitting them
from the CREATE TABLE and SELECT sources.
Thomas G. Lockhart [Mon, 14 Jun 1999 07:37:05 +0000 (07:37 +0000)]
Minor updates for release.
Split reference pages for CREATE TABLE AS and SELECT INTO to allow psgml
(the emacs parser) to handle parsing.
Thomas G. Lockhart [Mon, 14 Jun 1999 07:36:12 +0000 (07:36 +0000)]
Minor updates for release.
Thomas G. Lockhart [Mon, 14 Jun 1999 07:24:32 +0000 (07:24 +0000)]
Cut down to 80 columns per Bruce. Mostly hacked at the porting table.
Thomas G. Lockhart [Mon, 14 Jun 1999 06:59:34 +0000 (06:59 +0000)]
HTML versions of docs for v6.5 release.
Thomas G. Lockhart [Mon, 14 Jun 1999 06:56:31 +0000 (06:56 +0000)]
Fix URL for Norm Walsh's Style Sheets.
Thomas G. Lockhart [Mon, 14 Jun 1999 06:55:45 +0000 (06:55 +0000)]
Fix typos and wording in v6.5 release summary per Fred Horsh.
Thomas G. Lockhart [Mon, 14 Jun 1999 06:25:03 +0000 (06:25 +0000)]
User's Guide for v6.5.
Tatsuo Ishii [Sun, 13 Jun 1999 00:07:43 +0000 (00:07 +0000)]
change #if defined(__mc68000__) to:
#if defined(__mc68000__) && defined(__linux__)
so that other m68k systems(such as NetBSD) will not be affected.
Tom Lane [Sat, 12 Jun 1999 22:17:24 +0000 (22:17 +0000)]
Move default NBuffers setting into config.h, and rename it
to DEF_NBUFFERS for readability. Make sure the default value is OK
according to postmaster.c's new sanity check for -B values.
Tom Lane [Sat, 12 Jun 1999 20:41:25 +0000 (20:41 +0000)]
Fix critical error noticed by Massimo: copy.c used to have a
special hack to ensure it would close its output file even after failure
due to elog(ERROR) partway through the copy. This is now unnecessary
because fd.c takes care of cleaning up open files at transaction abort;
worse, after fd.c closed the file copy.c would try to do so *again* at
the start of the next COPY command. This would result in havoc in most
implementations of stdio library.
Tom Lane [Sat, 12 Jun 1999 19:38:30 +0000 (19:38 +0000)]
Remove query_planner's overhasty rejection of cases where
tlist and qual are NULL. It ought to handle these the same as the cases
where tlist contains only constant expressions, ie, be willing to generate
a Result-node plan. This did not use to matter, but it does now because
union_planner will flatten the tlist when aggregates are present. Thus,
'select count(1) from table' now causes query_planner to be given a null
tlist, and to duplicate 6.4's behavior we need it to give back a Result
plan rather than refusing the query. 6.4 was arguably doing the Wrong
Thing for this query, but I'm not going to open a semantics issue right
before 6.5 release ... can revisit that problem later.
Tom Lane [Sat, 12 Jun 1999 19:27:41 +0000 (19:27 +0000)]
Plug hole in dike: planner would coredump if query_planner
returned NULL, which it will do in some cases where an elog(ERROR) would
probably be more appropriate. For the moment, generate a not-very-
informative error message rather than proceeding to certain coredump.
Probably ought to think about making query_planner elog instead of
returning NULL, but this is at least a safe change for now.
Tom Lane [Sat, 12 Jun 1999 19:22:40 +0000 (19:22 +0000)]
When targetlist is NULL, ExecTargetList was passing back a
pointer to palloc'd but uninitialized memory. This is not cool; anyone looking
at the returned 'tuple' would at best coredump and at worst behave in a
bizarre and irreproducible way. Fix it to return a predictable value,
namely a correctly-set-up palloc'd tuple containing zero attributes.
I believe this fix is both safe and critical.
Bruce Momjian [Sat, 12 Jun 1999 14:07:33 +0000 (14:07 +0000)]
Reversed out Massimo patch.
Bruce Momjian [Sat, 12 Jun 1999 14:05:41 +0000 (14:05 +0000)]
I don't like last minute patches before the final freeze, but I believe that
this one could be useful for people experiencing out-of-memory crashes while
executing queries which retrieve or use a very large number of tuples.
The problem happens when storage is allocated for functions results used in
a large query, for example:
select upper(name) from big_table;
select big_table.array[1] from big_table;
select count(upper(name)) from big_table;
This patch is a dirty hack that fixes the out-of-memory problem for the most
common cases, like the above ones. It is not the final solution for the
problem but it can work for some people, so I'm posting it.
The patch should be safe because all changes are under #ifdef. Furthermore
the feature can be enabled or disabled at runtime by the `free_tuple_memory'
options in the pg_options file. The option is disabled by default and must
be explicitly enabled at runtime to have any effect.
To enable the patch add the follwing line to Makefile.custom:
CUSTOM_COPT += -DFREE_TUPLE_MEMORY
To enable the option at runtime add the following line to pg_option:
free_tuple_memory=1
Massimo
Bruce Momjian [Fri, 11 Jun 1999 15:01:29 +0000 (15:01 +0000)]
Hi,
please apply the included patch. It corrects the headers in src/win32 -
there are some missing #endif.
Dan
Bruce Momjian [Fri, 11 Jun 1999 14:34:02 +0000 (14:34 +0000)]
add m86 similar entries.
Vadim B. Mikheev [Fri, 11 Jun 1999 09:35:08 +0000 (09:35 +0000)]
Change Assert(Ptp.t_data->t_xmax == tp.t_data->t_xmin) to :
/*
* Read above about cases when !ItemIdIsUsed(Citemid)
* (child item is removed)... Due to the fact that
* at the moment we don't remove unuseful part of
* update-chain, it's possible to get too old
* parent row here. Like as in the case which
* caused this problem, we stop shrinking here.
* I could try to find real parent row but want
* not to do it because of real solution will
* be implemented anyway, latter, and we are too
* close to 6.5 release. - vadim 06/11/99
*/
if (Ptp.t_data->t_xmax != tp.t_data->t_xmin)
...
Vadim B. Mikheev [Fri, 11 Jun 1999 09:00:02 +0000 (09:00 +0000)]
Removed bad Assert(!buf->ri_lock) when unlocking exclusively
locked buffer.
Vadim B. Mikheev [Fri, 11 Jun 1999 05:40:18 +0000 (05:40 +0000)]
More about chained mode and isolation.
Vadim B. Mikheev [Fri, 11 Jun 1999 05:19:53 +0000 (05:19 +0000)]
More about chained mode and isolation levels.
Bruce Momjian [Fri, 11 Jun 1999 02:39:43 +0000 (02:39 +0000)]
Change mdtruncate to truncate and not unlink.
Hiroshi Inoue
Bruce Momjian [Thu, 10 Jun 1999 22:59:22 +0000 (22:59 +0000)]
This patch should enable 6.5 to build on Motorola 68000 architecture.
It comes from Roman Hodek <Roman.Hodek@informatik.uni-erlangen.de>.
Michael Meskes [Thu, 10 Jun 1999 19:11:33 +0000 (19:11 +0000)]
*** empty log message ***
Jan Wieck [Thu, 10 Jun 1999 17:49:32 +0000 (17:49 +0000)]
Added 2 regression tests for NUMERIC data type.
1. Using 100 digits after decimal point on the default
make runtest.
2. Using 1000 digits after decimal point in a new target
make bigtest.
At the end of 'make runtest', a hint about the new bigtest is
printed.
Jan
Vadim B. Mikheev [Thu, 10 Jun 1999 14:17:12 +0000 (14:17 +0000)]
1. Fix for elog(ERROR, "EvalPlanQual: t_xmin is uncommitted ?!")
and possibly for other cases too:
DO NOT cache status of transaction in unknown state
(i.e. non-committed and non-aborted ones)
Example:
T1 reads row updated/inserted by running T2 and cache T2 status.
T2 commits.
Now T1 reads a row updated by T2 and with HEAP_XMAX_COMMITTED
in t_infomask (so cached T2 status is not changed).
Now T1 EvalPlanQual gets updated row version without HEAP_XMIN_COMMITTED
-> TransactionIdDidCommit(t_xmin) and TransactionIdDidAbort(t_xmin)
return FALSE and T2 decides that t_xmin is not committed and gets
ERROR above.
It's too late to find more smart way to handle such cases and so
I just changed xact status caching and got rid TransactionIdFlushCache()
from code.
Changed: transam.c, xact.c, lmgr.c and transam.h - last three
just because of TransactionIdFlushCache() is removed.
2. heapam.c:
T1 marked a row for update. T2 waits for T1 commit/abort.
T1 commits. T3 updates the row before T2 locks row page.
Now T2 sees that new row t_xmax is different from xact id (T1)
T2 was waiting for. Old code did Assert here. New one goes to
HeapTupleSatisfiesUpdate. Obvious changes too.
3. Added Assert to vacuum.c
4. bufmgr.c: break
Assert(buf->r_locks == 0 && !buf->ri_lock)
into two Asserts.
Tom Lane [Thu, 10 Jun 1999 06:55:40 +0000 (06:55 +0000)]
Fix errors in SELECT ... GROUP BY ... UNION SELECT ...
ye proverbial one-line patch (not counting five lines of comment so's
maybe it won't happen again)
Thomas G. Lockhart [Wed, 9 Jun 1999 13:44:59 +0000 (13:44 +0000)]
Add mention of hot backups to the release notes.
Add id tags to chapter and section headings to ensure good labels
on output html files.
Thomas G. Lockhart [Wed, 9 Jun 1999 13:43:42 +0000 (13:43 +0000)]
Make minor changes in wording.
Adjust tags to get a clean build.
Bruce Momjian [Wed, 9 Jun 1999 12:39:46 +0000 (12:39 +0000)]
Remove -O2 for linux/alpha, make -O.
Vadim B. Mikheev [Wed, 9 Jun 1999 12:23:42 +0000 (12:23 +0000)]
Reset evaluation plan tuple table next free slot counter to 0
after ExecEndNode. It must be done! Or we'll be out of free
tuple slots very soon, though slots are freed by ExecEndNode
and ready for reusing.
We didn't see this problem before because of
int nSlots = ExecCountSlotsNode(plan);
TupleTable tupleTable = ExecCreateTupleTable(nSlots + 10);
/* why add ten? - jolly */
code in InitPlan - i.e. extra 10 slots. Simple select uses
3 slots and so it was possible to re-use evaluation plan
3 additional times and didn't get
elog(NOTICE, "Plan requires more slots than are available");
elog(ERROR, "send mail to your local executor guru to fix this");
Changes are obvious and shouldn't be problems with them.
Though, I added Assert(epqstate->es_tupleTable->next == 0)
before EvalPlanQual():ExecInitNode and we'll notice if
something is still wrong. Is it better to change Assert
to elog(ERROR) ?
Vadim B. Mikheev [Wed, 9 Jun 1999 03:51:40 +0000 (03:51 +0000)]
MVCC updates.
Vadim B. Mikheev [Tue, 8 Jun 1999 20:01:01 +0000 (20:01 +0000)]
MVCC updation.
Bruce Momjian [Tue, 8 Jun 1999 19:19:51 +0000 (19:19 +0000)]
Linux-alpha gets -O
Bruce Momjian [Tue, 8 Jun 1999 17:34:43 +0000 (17:34 +0000)]
Remove optimization on linux/alpha.
Bruce Momjian [Tue, 8 Jun 1999 16:42:55 +0000 (16:42 +0000)]
Fix for duplicate LC_COLLATE
Bruce Momjian [Tue, 8 Jun 1999 16:42:10 +0000 (16:42 +0000)]
Add mention of new pg_dump feature.
Bruce Momjian [Tue, 8 Jun 1999 16:27:26 +0000 (16:27 +0000)]
Install proper Irix FAQ.
Bruce Momjian [Tue, 8 Jun 1999 01:37:55 +0000 (01:37 +0000)]
Cleanup
Bruce Momjian [Tue, 8 Jun 1999 01:32:05 +0000 (01:32 +0000)]
Disable pg_upgrade for 6.5.
Bruce Momjian [Mon, 7 Jun 1999 22:58:31 +0000 (22:58 +0000)]
I attach a patch for pg_upgrade. This does two things:
1. check whether the program is being executed in $PGDATA/.. This is
necessary if the data tree is not in the standard place, as is the
case with the Debian distribution (because of Debian policy).
2. give a clearer error message if the dumped data structure fails to
be loaded.
Oliver Elphick
Bruce Momjian [Mon, 7 Jun 1999 17:20:24 +0000 (17:20 +0000)]
On AIX 4.3.2 the third line in template/aix_42:
SHARED_LIB:
needs to be changed to:
SHARED_LIB:-lc
I think this was also needed on AIX 4.2. Comments Please !!
If nobody objects, I suggest to make this change, since it cannot
break AIX 4.2 and is necessary on AIX 4.3
Andreas
Vadim B. Mikheev [Mon, 7 Jun 1999 15:14:54 +0000 (15:14 +0000)]
Concurrency... Highest one...
DO NOT EVEN TRY TO DO PageGetMaxOffsetNumber BEFORE
LockBuffer!
-:)
Bruce Momjian [Mon, 7 Jun 1999 14:29:20 +0000 (14:29 +0000)]
> Here is a small patch that should only affect win32 building
> (native win32, not cygnus).
> It does the following:
> Patches two win32.mak files to DEFINE HAVE_VSNPRINTF and
> HAVE_STRDUP. This is required to build at all.
> Bumps the version number on libpq.dll from 6.4 to 6.5.
> Required for install programs to work.
> Adds defintions for BLCKSZ and MAXIMUM_ALIGN to "win32.h" in
> the client-side libpiq directory.
>
> All these files are only used when building on native win32,
> so it should be safe I think.
>
> Again, really sorry to throw this in so late, but I would
> hate to do the same thing as with 6.4 (which required 6.4.1
> to at all compile on Win32).
>
> Thanks,
>
> //Magnus
Tom Lane [Mon, 7 Jun 1999 14:28:26 +0000 (14:28 +0000)]
Repair recently-introduced error in makeIndexable for LIKE:
a non-leading % would be put into the >=/<= patterns. Also, repair
longstanding confusion about whether %% means a literal %%. The SQL92
doesn't say any such thing, and textlike() knows that, but gram.y didn't.
Vadim B. Mikheev [Mon, 7 Jun 1999 14:28:22 +0000 (14:28 +0000)]
Have to release meta page before reading root one!
< 6.5 versions were just not affected by this bug due to locking.
Bruce Momjian [Mon, 7 Jun 1999 02:42:07 +0000 (02:42 +0000)]
Update TODO.
Vadim B. Mikheev [Sun, 6 Jun 1999 20:19:35 +0000 (20:19 +0000)]
1. xact.c: update comments about changing MyProc->xid and MyProc->xmin.
2. varsup.c:ReadNewTransactionId(): don't read nextXid from disk -
this func doesn't allocate next xid, so ShmemVariableCache->nextXid
may be used (but GetNewTransactionId() must be called first).
3. vacuum.c: change elog(ERROR, "Child item....") to elog(NOTICE) -
this is not ERROR, proper handling is just not implemented, yet.
4. s_lock.c: increase S_MAX_BUSY by 2 times.
5. shmem.c:GetSnapshotData(): have to call ReadNewTransactionId()
_after_ SpinAcquire(ShmemIndexLock).
Tom Lane [Sun, 6 Jun 1999 17:46:40 +0000 (17:46 +0000)]
equal() needs a case for Aggref nodes, as shown by:
regression=> select sum(q1) from int8_tbl group by q2 order by sum(q1);
NOTICE: equal: don't know whether nodes of type 107 are equal
Tom Lane [Sun, 6 Jun 1999 17:41:01 +0000 (17:41 +0000)]
Add a regression test case to catch breakage of GROUP BY
and aggregate functions in queries that use inheritance.
Tom Lane [Sun, 6 Jun 1999 17:38:11 +0000 (17:38 +0000)]
Fix problems with grouping/aggregation in queries that use
inheritance ... basically it was completely busted :-(
Vadim B. Mikheev [Sun, 6 Jun 1999 15:14:40 +0000 (15:14 +0000)]
I used bad style of comments and ... commented out some code in
EvalPlanQualNext() when implemented it... -:)
Uncommented...
Tom Lane [Sat, 5 Jun 1999 20:22:30 +0000 (20:22 +0000)]
Instead of failing when the constructed name for a sequence,
index, etc is too long, truncate until it fits.
Bruce Momjian [Sat, 5 Jun 1999 20:07:54 +0000 (20:07 +0000)]
Update from Massimo
Bruce Momjian [Sat, 5 Jun 1999 19:09:48 +0000 (19:09 +0000)]
Hi,
I have updated my contrib code for version 6.5. In the attachment you will
find the directories array, datetime, miscutil, string, tools and userlocks
which replace the corresponding directories under contrib.
In contrib/tools you will find some developement scripts which I use while
hacking the sources. I hope they will be useful for some other people.
I have also added a contrib/Makefile which tries to compile and install all
the contribs. Unfortunately many of them don't have a Makefile or don't
compile cleanly.
--
Massimo Dal Zotto
Bruce Momjian [Sat, 5 Jun 1999 18:30:43 +0000 (18:30 +0000)]
New FAQ with commerical support mention.
Bruce Momjian [Sat, 5 Jun 1999 18:24:55 +0000 (18:24 +0000)]
Update faq and hpux faq.
Tom Lane [Sat, 5 Jun 1999 18:05:17 +0000 (18:05 +0000)]
Remove redeclarations of default parameter values from
PgDatabase::DisplayTuples and PgDatabase::PrintTuples. This is incorrect
according to strict interpretation of the C++ spec, and some compilers
will reject it. Also silence g++ warning about unused parameter.
Tatsuo Ishii [Sat, 5 Jun 1999 10:27:31 +0000 (10:27 +0000)]
a fix for Win32 support provided by yutaka@marin.or.jp.
The patch will avoid to add .exe suffix to the pg_encoding
binary.
Marc G. Fournier [Sat, 5 Jun 1999 04:18:09 +0000 (04:18 +0000)]
trace.patch (compilation error)
the gettimeofday doesn't compile under Linux with glibc2 because
the DST_NONE constant is no more defined. It seems that this code
(written by me) has always be wrong but for some reason working.
From: Massimo Dal Zotto <dz@cs.unitn.it>
Marc G. Fournier [Sat, 5 Jun 1999 04:15:09 +0000 (04:15 +0000)]
man.patch (make inconsistency)
the default target is 'install' instead of 'all'. So if you do a
make without target you actually do a make install, which is not
what one normally expects from a standard makefile.
From: Massimo Dal Zotto <dz@cs.unitn.it>
Marc G. Fournier [Sat, 5 Jun 1999 04:13:21 +0000 (04:13 +0000)]
ecpg.patch (wrong makefile expansion in some cases)
the ecpg Makefiles use a variable DESTDIR which is never defined
except by debian/rules makefile, in which case the ecpg makefiles
expand wrong pathnames. If we want to support a DESTDIR root it
must be done consistently in all the makefiles, not just in ecpg.
From: Massimo Dal Zotto <dz@cs.unitn.it>
Bruce Momjian [Sat, 5 Jun 1999 03:43:07 +0000 (03:43 +0000)]
Update FAQ's for release.
Bruce Momjian [Sat, 5 Jun 1999 02:47:13 +0000 (02:47 +0000)]
Update with more TODO items.
Tom Lane [Fri, 4 Jun 1999 21:21:13 +0000 (21:21 +0000)]
Suppress indexes on large objects from psql's \d listing;
they were confusing because the large object tables themselves are not
shown. (Besides, if you've got hundreds or thousands of large objects,
you really don't want to see 'em at all.)
Also, suppress all indexes from the \z ACL listing, since indexes have
no meaningful protection information.
Tom Lane [Fri, 4 Jun 1999 21:14:46 +0000 (21:14 +0000)]
Add startup-time check that -B is not unreasonably small for
given number of backends (-N), per recent discussion in pghackers list.
Tom Lane [Fri, 4 Jun 1999 21:13:38 +0000 (21:13 +0000)]
Add configurable option controlling security checks in LO functions.
Tom Lane [Fri, 4 Jun 1999 21:12:07 +0000 (21:12 +0000)]
Turns out OIDNAMELEN wasn't really being used at all!
Get rid of it to make customization of NAMEDATALEN easier.
Thomas G. Lockhart [Fri, 4 Jun 1999 15:51:42 +0000 (15:51 +0000)]
Add blurb on new docs in release notes.
Make minor info and markup changes for v6.5 release.
Thomas G. Lockhart [Fri, 4 Jun 1999 15:50:44 +0000 (15:50 +0000)]
Add input parameters for LOCK TABLE. Still needs explanation from Vadim.
Fix markup.
Thomas G. Lockhart [Fri, 4 Jun 1999 06:31:14 +0000 (06:31 +0000)]
May as well keep an ApplixWare version of this file too.
Thomas G. Lockhart [Fri, 4 Jun 1999 06:24:02 +0000 (06:24 +0000)]
Hardcopy for v6.5 release.
Thomas G. Lockhart [Fri, 4 Jun 1999 06:23:27 +0000 (06:23 +0000)]
Add a mention of doc changes in the release notes.
Thomas G. Lockhart [Fri, 4 Jun 1999 06:23:00 +0000 (06:23 +0000)]
Release notes from sgml for v6.5 release.
Bruce Momjian [Fri, 4 Jun 1999 04:28:54 +0000 (04:28 +0000)]
Add mention of SHARE ROW EXCLUSIVE mode.
Bruce Momjian [Fri, 4 Jun 1999 04:16:11 +0000 (04:16 +0000)]
man page cleanup for vadim.
Bruce Momjian [Fri, 4 Jun 1999 03:44:42 +0000 (03:44 +0000)]
Add description for SET TRANSACTION.
Tom Lane [Fri, 4 Jun 1999 02:19:47 +0000 (02:19 +0000)]
Fix for failure to clean SysCache entry when a relation is deleted
in the same transaction that created it.
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.