aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Wups, stuck ORDER BY on wrong query while trying to eliminate randomTom Lane2002-11-21
| | | | ordering of GROUP BY output due to hash-based aggregation.
* Add:Bruce Momjian2002-11-21
| | | | > * Have sequence dependency track use of DEFAULT sequences, seqname.nextval
* Add mention of kern.ipc.shm_use_phys for locking shared memory.Bruce Momjian2002-11-21
|
* Code review for superuser_reserved_connections patch. Don't try to doTom Lane2002-11-21
| | | | | | database access outside a transaction; revert bogus performance improvement in SIBackendInit(); improve comments; add documentation (this part courtesy Neil Conway).
* NetBSD versions 1.6 and (we hope) later can use the standard geometryTom Lane2002-11-21
| | | | | comparison file, instead of geometry-positive-zeros. Per report from Patrick Welche.
* Done:Bruce Momjian2002-11-21
| | | | > * -Add hash for evaluating GROUP BY aggregates (Tom)
* Finish implementation of hashed aggregation. Add enable_hashagg GUCTom Lane2002-11-21
| | | | | | parameter to allow it to be forced off for comparison purposes. Add ORDER BY clauses to a bunch of regression test queries that will otherwise produce randomly-ordered output in the new regime.
* Update ports list.Bruce Momjian2002-11-20
|
* Fix a dumb cut and paste error from my last commit and update some of theBarry Lind2002-11-20
| | | | | | | | jdbc3 metadata responses Modified Files: jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/jdbc3/AbstractJdbc3DatabaseMetaData.java
* Fixed bug reported by Marko Strukelj and Keith Wannamaker. Using executeBatchBarry Lind2002-11-20
| | | | | | | | | | | | | on a preparedStatement would reset the prepared statment causing subsequent uses of the preparedStatement to fail (i.e. the following series of calls would fail: addBatch() executeBatch() addBatch() executBatch()). This is a regression from 7.2 where this worked correctly. The regression test has also been modified to explicitly test for this case. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/test/jdbc2/BatchExecuteTest.java
* Add an at-least-marginally-plausible method of estimating the numberTom Lane2002-11-19
| | | | | | of groups produced by GROUP BY. This improves the accuracy of planning estimates for grouped subselects, and is needed to check whether a hashed aggregation plan risks memory overflow.
* Add my name:Bruce Momjian2002-11-19
| | | | > * Allow savepoints / nested transactions [transactions] (Bruce)
* Update regression for ALL missing from CLUSTER.Bruce Momjian2002-11-19
|
* Most of the code follows the American spelling of the word, which isBruce Momjian2002-11-19
| | | | | | | | "canceled", so I changed the one remaining usage of the British spelling ("cancelled") over to the former, and updated the translation files appropriately. Neil Conway
* Back out NetBSD/arm32 port.Bruce Momjian2002-11-19
|
* Update ports list.Bruce Momjian2002-11-19
|
* Fix typo and markup.Peter Eisentraut2002-11-18
|
* Update SGML problem in ports.Bruce Momjian2002-11-18
|
* Remove ALL from CLUSTER ALL. Use just CLUSTER.Bruce Momjian2002-11-18
|
* Update ports list.Bruce Momjian2002-11-18
|
* Put back error test for DECLARE CURSOR outside a transaction block ...Tom Lane2002-11-18
| | | | but do it correctly now.
* Suppress compile warning, avoid possible problems with signed vs. unsignedTom Lane2002-11-18
| | | | comparisons in recently-added CheckPointWarning code.
* Re-order REINDEX options in manual for consistency. REINDEXBruce Momjian2002-11-17
| | | | DATABASE/TABLE/INDEX is the proper order.
* Reduce need for palloc/pfree overhead in varstr_cmp() by using fixed-sizeTom Lane2002-11-17
| | | | buffers on stack for short strings.
* Revise SQL features list.Peter Eisentraut2002-11-17
|
* Fix CLUSTER regression failure caused by new patch, from Neil ConwayBruce Momjian2002-11-16
|
* Add relcache support for system catalogs with attnotnull columns.Tom Lane2002-11-15
| | | | | | | | The code was not making TupleConstr structs for such catalogs in several places; with the consequence that the not-null constraint wasn't actually enforced. With this change, INSERT INTO pg_proc VALUES('sdf'); generates a 'Fail to add null value' error instead of a core dump.
* Synced parser.Michael Meskes2002-11-15
|
* SGML markup fixes.Bruce Momjian2002-11-15
|
* SGML improvements.Bruce Momjian2002-11-15
| | | | Neil Conway
* New version attached. The following is implemented:Bruce Momjian2002-11-15
| | | | | | | | | | | - CLUSTER ALL clusters all the tables that have some index with indisclustered set and the calling user owns. - CLUSTER tablename clusters the named table, using the index with indisclustered set. If no index has the bit set, throws elog(ERROR). - The multi-relation version (CLUSTER ALL) uses a multitransaction approach, similar to what VACUUM does. Alvaro Herrera
* Clean up psql:Bruce Momjian2002-11-15
| | | | | | | | | | | | | | | | | | | | | | | | | Add simple ALTER DATABASE, ALTER TRIGGER, CHECK POINT, CREATE CONVERSION, CREATE DOMAIN, CREATE LANGUAGE, DEALLOCATE, DROP CONVERSION, DROP DOMAIN, DROP LANGUAGE, EXECUTE, PREPARE Complete CAST in CREATE CAST and DROP CAST but doesn't suggest what should follow. Add many more SET / SHOW variables to the list. Taken from SHOW ALL output. Complete a case sensitive search to allow \dD, \dd, \dS, \ds, \h, \H to complete properly. But there are no matches, then try a case insensitive search to allow case conversion. Add all missing help options. \Q<tab> -> \q \dD<tab> -> \dD \dd<tab> -> \dd \D<tab><tab><tab> -> \d (with listing of \d? commands) sel<tab> -> SELECT Rod Taylor
* OpenSSL 0.9.6g in Debian/unstable stopped working with pgcrypto. ThisBruce Momjian2002-11-15
| | | | | | | | | | | is pgcrypto bug as it assumed too much about inner workings of OpenSSL. Following patch stops pgcrypto using EVP* functions for ciphers and lets it manage ciphers itself. This patch supports Blowfish, DES and CAST5 algorithms. Marko Kreen
* pg_dump for domain constraints.Bruce Momjian2002-11-15
| | | | Rod Taylor
* Add DOMAIN check constraints.Bruce Momjian2002-11-15
| | | | Rod Taylor
* Add checkpoint_warning to warn of excessive checkpoints caused by tooBruce Momjian2002-11-15
| | | | few WAL files.
* Push qual clauses containing subplans to the back of the qual listTom Lane2002-11-15
| | | | at each plan node. Per gripe from Ross Reedstrom.
* Rename hostname_lookup to log_hostname.Bruce Momjian2002-11-15
|
* Rename show_source_port to log_source_port.Bruce Momjian2002-11-15
|
* Rename show_btree_build_stats to log_btree_build_statsBruce Momjian2002-11-15
|
* Rename:Bruce Momjian2002-11-15
| | | | | | | | | | | | | | ! #show_parser_stats = false ! #show_planner_stats = false ! #show_executor_stats = false ! #show_statement_stats = false TO: ! #log_parser_stats = false ! #log_planner_stats = false ! #log_executor_stats = false ! #log_statement_stats = false
* Rename server_min_messages to log_min_messages. Part of consolidationBruce Momjian2002-11-14
| | | | of log_ settings.
* Improve warning messages from tsearch trigger function; clean up someTom Lane2002-11-14
| | | | | casting infelicities. Allow char(n) fields to be indexed. Per Bjoern Metzdorf.
* Fix planning bug introduced in recent code reorganization for hashedTom Lane2002-11-14
| | | | | aggregates: tuple_fraction has to be adjusted before passing it to compare_fractional_path_costs().
* Update ports list.Bruce Momjian2002-11-14
|
* Fix Magnus's name.Bruce Momjian2002-11-14
|
* Fix version number for FreeBSD/alpha on ports list.Bruce Momjian2002-11-14
|
* Update ports list.Bruce Momjian2002-11-14
|
* Applied patch submitted by Mats Lofkvist fixing serious threading problem ↵Barry Lind2002-11-14
| | | | | | | | | | | | | | | introduced in beta3. Fixed bug with using setNull()(or setXXX(x, null)) and serverside prepare statements. Improved error message when using a connection object that has already been closed. Modified Files: jdbc/org/postgresql/errors.properties jdbc/org/postgresql/core/Encoding.java jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
* Update ports list.Bruce Momjian2002-11-14
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-06 00:11:34 +0000