aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* Avoid assuming that pg_index table entries have unique OIDs, or evenTom Lane2001-07-17
| | | | | that they have OIDs at all (the primary key for this table is indexrelid, not OID). Simplify overly complex query to get name of primary key.
* Improve documentation about reasoning behind the order of operationsTom Lane2001-07-16
| | | | | | | | in GetSnapshotData, GetNewTransactionId, CommitTransaction, AbortTransaction, etc. Correct race condition in transaction status testing in HeapTupleSatisfiesVacuum --- this wasn't important for old VACUUM with exclusive lock on its table, but it sure is important now. All per pghackers discussion 7/11/01 and 7/12/01.
* Fix fault in message.Peter Eisentraut2001-07-16
|
* Remove some unused node symbolsBruce Momjian2001-07-16
|
* More EXTEND INDEX removal.Bruce Momjian2001-07-16
| | | | Martijn van Oosterhout
* Do not push down quals into subqueries that have LIMIT/OFFSET clauses,Tom Lane2001-07-16
| | | | | since the added qual could change the set of rows that get past the LIMIT. Per discussion on pgsql-sql 7/15/01.
* Partial indexes work again, courtesy of Martijn van Oosterhout.Tom Lane2001-07-16
| | | | | | Note: I didn't force an initdb, figuring that one today was enough. However, there is a new function in pg_proc.h, and pg_dump won't be able to dump partial indexes until you add that function.
* Restructure index AM interface for index building and index tuple deletion,Tom Lane2001-07-15
| | | | | | | | | | | | | | | | | | | | | | | | | per previous discussion on pghackers. Most of the duplicate code in different AMs' ambuild routines has been moved out to a common routine in index.c; this means that all index types now do the right things about inserting recently-dead tuples, etc. (I also removed support for EXTEND INDEX in the ambuild routines, since that's about to go away anyway, and it cluttered the code a lot.) The retail indextuple deletion routines have been replaced by a "bulk delete" routine in which the indexscan is inside the access method. I haven't pushed this change as far as it should go yet, but it should allow considerable simplification of the internal bookkeeping for deletions. Also, add flag columns to pg_am to eliminate various hardcoded tests on AM OIDs, and remove unused pg_am columns. Fix rtree and gist index types to not attempt to store NULLs; before this, gist usually crashed, while rtree managed not to crash but computed wacko bounding boxes for NULL entries (which might have had something to do with the performance problems we've heard about occasionally). Add AtEOXact routines to hash, rtree, and gist, all of which have static state that needs to be reset after an error. We discovered this need long ago for btree, but missed the other guys. Oh, one more thing: concurrent VACUUM is now the default.
* Add ORDER BY to a couple of test queries whose output ordering is notTom Lane2001-07-15
| | | | | as predictable as it used to be, due to recycling of free space with new VACUUM.
* NLS for libpq. Clean up the message formats and change the documentationPeter Eisentraut2001-07-15
| | | | accordingly.
* Change xgettext rule to run in the source tree, so we don't have thePeter Eisentraut2001-07-15
| | | | | absolute paths of the source tree in the po files. Also, run msgfmt with -c option in maintainer-check.
* Make sure the build tree is before the source tree in the include path.Peter Eisentraut2001-07-15
|
* TODO item:Tatsuo Ishii2001-07-15
| | | | * Make n of CHAR(n)/VARCHAR(n) the number of letters, not bytes
* The attached patch fixes problems with the JDBC driver handling longBruce Momjian2001-07-15
| | | | | | | | | | | | | | | | | | | | | | | | null terminated strings. The FE/BE protocol sends in some cases null terminated strings to the client. The docs for the FE/BE protocol state that there is no limit on the size of a null terminated string sent to the client and a client should be coded using an expanding buffer to deal with large strings. The old code did not do this and gave an error if a null terminated string was greater than either 4 or 8K. It appears that with the advent of TOAST very long SQL statements are becoming more common, and apparently some error messages from the backend include the SQL statement thus easily exceeding the 8K limit in the old code. In fixing I also cleaned up some calls in the JDBC fastpath code that were not doing character set conversion under multibyte, and removed some methods that were no longer needed. I also removed a potential threading problem with a shared variable that was being used in Connection.java. Thanks to Steve Wampler for discovering the problem and sending the initial diffs that were the basis of this patch. thanks, --Barry
* Initial implementation of concurrent VACUUM. Ifdef'd out for the moment,Tom Lane2001-07-13
| | | | | because index locking issues are not handled correctly yet. Need to go work on the index AMs next.
* Minor code cleanup/beautification in RelationPutHeapTuple.Tom Lane2001-07-13
|
* indicies to indexes from Neil ConwayBruce Momjian2001-07-12
|
* Remove grammar restrictions on order of optional clauses in CREATE GROUP.Tom Lane2001-07-12
| | | | From Vince Vielhaber.
* Back out SET AUTHORIZATION patch until security is resolved.Bruce Momjian2001-07-12
|
* Add win32 c++ files.Bruce Momjian2001-07-12
|
* Add missing encode file.Bruce Momjian2001-07-12
|
* Create a new HeapTupleSatisfiesVacuum() routine in tqual.c that embodies theTom Lane2001-07-12
| | | | | | validity checking rules for VACUUM. Make some other rearrangements of the VACUUM code to allow more code to be shared between full and lazy VACUUM. Minor code cleanups and added comments for TransactionId manipulations.
* Make code malloc memory of proper length.Bruce Momjian2001-07-12
|
* > > Put encode() into base system. Used part of Alex' patchBruce Momjian2001-07-11
| | | | | | > > for docs, hope he does not mind ;) Marko Kreen
* Libpq++ fixes for Win32 compile.Bruce Momjian2001-07-11
| | | | Christian Ullrich
* Add prototypes to supress warnings.Bruce Momjian2001-07-11
|
* Disable COPY TO/FROM on views.Bruce Momjian2001-07-11
|
* Better document use of ident on localhost, per Tom Lane's idea.Bruce Momjian2001-07-11
|
* Move export to a separate line, per Peter E.Bruce Momjian2001-07-11
|
* Instead of believing SOMAXCONN from the system header files (which isTom Lane2001-07-11
| | | | | | a lie on many Unixen), invoke listen() with MIN(MaxBackends*2, 10000). The clamp value 10000 is configurable in config.h.in, if that proves to be necessary --- hopefully it won't.
* I updated the patch to use the SET AUTHORIZATION { INVOKER | DEFINER }Bruce Momjian2001-07-11
| | | | | | | terminology. Also, the function owner is now determined and saved at compile time (no gotchas here, right?)/ Mark Volpe
* Remove direct calls of index_insert(), instead use ExecInsertIndexTuples().Tom Lane2001-07-11
| | | | | | | This makes VACUUM work properly with partial indexes, and avoids memory leakage with functional indexes. Also, suppress complaint about fewer index tuples than heap tuples when the index is a partial index. From Martijn van Oosterhout.
* The SQL preprocessor ecpg generates "initially deferrable" fromBruce Momjian2001-07-11
| | | | | | INITIALLY DEFERRED in source code. cf. preproc.y:1455. Unknown.
* Move export PGDATA to the proper place. Quote some variable substitutions.Bruce Momjian2001-07-11
|
* Fix duplication of -D during pg_ctl restart, from Peter E's patch.Bruce Momjian2001-07-11
|
* Changes from Vince Vielhaber to allow the optional clauses of CREATETom Lane2001-07-10
| | | | | | | | USER and ALTER USER to appear in any order, not only the fixed order they used to be required to appear in. Also, some changes from Tom Lane to create a FULL option for VACUUM; it doesn't do anything yet, but I needed to change many of the same files to make that happen, so now seemed like a good time.
* Support fake root install, separate build dir, dependency tracking, ourPeter Eisentraut2001-07-10
| | | | | | choice of compiler and flags, uninstall, and peculiar Python installation layouts for PyGreSql. Also install into site-packages now, as officially recommended. And pgdb.py is also installed now, used to be forgotten.
* Remove formatter's assumption that year would never exceed four digits.Tom Lane2001-07-10
| | | | | Enforce MAXTZLEN for all datestyles, not just some. Remove macro definitions that were redundant with datetime.h.
* Ensure macros are adequately parenthesized.Tom Lane2001-07-10
|
* Remove unnecessarily enthusiastic parenthesizing in reverse-listing ofTom Lane2001-07-10
| | | | IS NULL, IS TRUE, and friends (my fault...)
* Fix rule rewriter so that new ordering of ON INSERT actions appliesTom Lane2001-07-09
| | | | | | in cases of qualified rules as well as unqualified ones. Tweak rules test to avoid cluttering output with dummy SELECT results. Update documentation to match code.
* Add SHARE UPDATE EXCLUSIVE lock mode, coming soon to a VACUUM near you.Tom Lane2001-07-09
| | | | Name chosen per pghackers discussion around 6/22/01.
* German message localization for JDBCPeter Eisentraut2001-07-09
|
* Document meaning of lossy column.Bruce Momjian2001-07-09
|
* postgresql.badint property name was probably meant to bePeter Eisentraut2001-07-09
| | | | postgresql.res.badint, since that's the name in the properties file.
* Show islossy for index.Peter Eisentraut2001-07-08
|
* Implement DatabaseMetaData.getCatalogs()Peter Eisentraut2001-07-08
|
* Bring DatabaseMetaData feature tests up to date:Peter Eisentraut2001-07-08
| | | | | | | | | | | | | | | | * NULLs are sorted differently in 7.2 * table correlation names are supported * GROUP BY, ORDER BY unrelated is supported since 6.4 * ESCAPE/LIKE only supported since 7.1 * outer joins only since 7.1 * preferred term for procedure is "function" * preferred term for catalog is "database" * supports SELECT for UPDATE since 6.5 * supports subqueries * supports UNION; supports UNION ALL since 7.1 * update some of the max lengths to match reality * rearrange some functions to match the order in the spec for easier maintenance
* Sync with jdbc2, remove gratuitous white space differences.Peter Eisentraut2001-07-07
|
* Resolve a number of oddities in the Java build. First, remove the weirdPeter Eisentraut2001-07-06
| | | | | | | | | redirections between the build files, which didn't work completely. Now you just go to the directory of your choice and run make. Clean up the build files to have a logical order, fix the unnecessary rebuilds, prevent the deleting targets from removing files they're not responsible for. Ant 1.3 does not have a bug. It deletes directories just fine if you follow the documentation.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-04 16:26:44 +0000