summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
1999-06-09MVCC updates.Vadim B. Mikheev
1999-06-08Linux-alpha gets -OBruce Momjian
1999-06-08Remove optimization on linux/alpha.Bruce Momjian
1999-06-08CleanupBruce Momjian
1999-06-08Disable pg_upgrade for 6.5.Bruce Momjian
1999-06-07I attach a patch for pg_upgrade. This does two things:Bruce Momjian
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
1999-06-07On AIX 4.3.2 the third line in template/aix_42:Bruce Momjian
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
1999-06-07Concurrency... Highest one...Vadim B. Mikheev
DO NOT EVEN TRY TO DO PageGetMaxOffsetNumber BEFORE LockBuffer! -:)
1999-06-07> Here is a small patch that should only affect win32 buildingBruce Momjian
> (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
1999-06-07Repair recently-introduced error in makeIndexable for LIKE:Tom Lane
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.
1999-06-07Have to release meta page before reading root one!Vadim B. Mikheev
< 6.5 versions were just not affected by this bug due to locking.
1999-06-061. xact.c: update comments about changing MyProc->xid and MyProc->xmin.Vadim B. Mikheev
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).
1999-06-06equal() needs a case for Aggref nodes, as shown by:Tom Lane
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
1999-06-06Add a regression test case to catch breakage of GROUP BYTom Lane
and aggregate functions in queries that use inheritance.
1999-06-06Fix problems with grouping/aggregation in queries that useTom Lane
inheritance ... basically it was completely busted :-(
1999-06-06I used bad style of comments and ... commented out some code inVadim B. Mikheev
EvalPlanQualNext() when implemented it... -:) Uncommented...
1999-06-05Instead of failing when the constructed name for a sequence,Tom Lane
index, etc is too long, truncate until it fits.
1999-06-05Remove redeclarations of default parameter values fromTom Lane
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.
1999-06-05a fix for Win32 support provided by yutaka@marin.or.jp.Tatsuo Ishii
The patch will avoid to add .exe suffix to the pg_encoding binary.
1999-06-05trace.patch (compilation error)Marc G. Fournier
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>
1999-06-05man.patch (make inconsistency)Marc G. Fournier
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>
1999-06-05ecpg.patch (wrong makefile expansion in some cases)Marc G. Fournier
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>
1999-06-04Suppress indexes on large objects from psql's \d listing;Tom Lane
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.
1999-06-04Add startup-time check that -B is not unreasonably small forTom Lane
given number of backends (-N), per recent discussion in pghackers list.
1999-06-04Add configurable option controlling security checks in LO functions.Tom Lane
1999-06-04Turns out OIDNAMELEN wasn't really being used at all!Tom Lane
Get rid of it to make customization of NAMEDATALEN easier.
1999-06-04Add mention of SHARE ROW EXCLUSIVE mode.Bruce Momjian
1999-06-04man page cleanup for vadim.Bruce Momjian
1999-06-04Add description for SET TRANSACTION.Bruce Momjian
1999-06-04Fix for failure to clean SysCache entry when a relation is deletedTom Lane
in the same transaction that created it.
1999-06-03SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;Bruce Momjian
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
1999-06-03Thanks for this, but SET TRANSACTION ISOLATION LEVELBruce Momjian
should be described like SET TIME ZONE: TO is not allowed, as well as DEFAULT option. There are only two forms: for Vadim.
1999-06-03Add mention of FOR UPDATE and LIMIT/OFFSET>Bruce Momjian
1999-06-03Update lock sgml/man/psql help pages.Bruce Momjian
1999-06-03Add SET TRANSACTION ISOLATION LEVEL and SET NAMES mention.Bruce Momjian
1999-06-03Update psql help so it looks better.Bruce Momjian
1999-06-03Update SET commands for psql \h, man pages, and sgml.Bruce Momjian
1999-06-031. Additional fix against ERROR: Child itemid marked as unusedVadim B. Mikheev
in CommitTransaction(). 2. Changes in GetSnapshotData().
1999-06-03Unuseful tuple.t_data->t_infomask & HEAP_XMIN_COMMITTED inVadim B. Mikheev
vc_scanheap().
1999-06-031. MyProc->xid assignment is moved to GetNewTransactionId so newerVadim B. Mikheev
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).
1999-06-03pg_dump failed on any database containing large objects,Tom Lane
because it ignored the LOs themselves but failed to ignore the indexes on the LOs. How long has this been broken??
1999-06-03Ensure consistent results when FormSortKeys fails to findTom Lane
all the expected keys (it was returning uninitialized memory).
1999-06-03Ooops ... dllist.c can't use Assert() when it is compiled intoTom Lane
libpq ...
1999-06-02Changed "current." into "old." in rule string backparsingJan Wieck
Jan
1999-06-02The INET and CIDR types mistakenly compared 198.68.123.0/24 andBruce Momjian
198.68.123.0/27 the same when indexing them. D'Arcy
1999-06-01typedef struct LTAGVadim B. Mikheev
{ 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...
1999-06-01forgot to attach the patch. :(Bruce Momjian
Vince.
1999-06-01commented out PgConnection& references for now. May be using themBruce Momjian
later. Vince.
1999-05-31Fix some latent bugs in dllist.c (carelessness about settingTom Lane
all fields that should be set). Add a MoveToFront primitive to speed up one of the hotspots in SearchSysCache.
1999-05-31Clean up memory leaks in LO operations by freeing LO's privateTom Lane
memory context at transaction commit or abort.