aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Forgot to commit Makefile change.Michael Meskes2003-02-21
|
* Make btree index structure adjustments and WAL logging changes needed toTom Lane2003-02-21
| | | | | | | | | | | support btree compaction, as per proposal of a few days ago. btree index pages no longer store parent links, instead they have a level indicator (counting up from zero for leaf pages). The FixBTree recovery logic is removed, and replaced by code that detects missing parent-level insertions during WAL replay. Also, generate appropriate WAL entries when updating btree metapage and when building a btree index from scratch. I believe btree indexes are now completely WAL-legal for the first time. initdb forced due to index and WAL changes.
* Fix timestamptz_in so that parsing of 'now'::timestamptz gives rightTom Lane2003-02-20
| | | | | | | answer when SET TIMEZONE has been done since the start of the current transaction. Per bug report from Robert Haas. I plan some futher cleanup in HEAD, but this is a low-risk patch for the immediate issue in 7.3.
* Back out LOCKTAG changes by Rod Taylor, pending code review. Sorry.Bruce Momjian2003-02-19
|
* Fix for GUC client_encoding variable not being handledTatsuo Ishii2003-02-19
| | | | | | | | correctly. See following thread for more details. Subject: [HACKERS] client_encoding directive is ignored in postgresql.conf From: Tatsuo Ishii <t-ishii@sra.co.jp> Date: Wed, 29 Jan 2003 22:24:04 +0900 (JST)
* Added DATABASE command as alias to CONNECT TO.Michael Meskes2003-02-19
|
* This patch makes the following changes to the documentation:Bruce Momjian2003-02-19
| | | | | | | | | | | | | - more work from the SGML police - some grammar improvements: rewriting a paragraph or two, replacing contractions where (IMHO) appropriate - fix missing utility commands in lock mode docs - improve CLUSTER, REINDEX, SET SESSION AUTHORIZATION ref pages Neil Conway
* Autoconf run for readline/libedit patch.Bruce Momjian2003-02-19
|
* Here's the patch I promised over on HACKERS - it alters theBruce Momjian2003-02-19
| | | | | | | | | | | | implementation of '\e' history tracking for systems that have a readline compatability library without replace_history_entry. I fall back to pushing the query onto the history stack after the \e, rather than replacing it. The patch adds one more place to look for readline headers, and a test for replace_history_entry. I've only included the patch for configure.in Ross J. Reedstrom
* - Modifies LOCKTAG to include a 'classId'. Relation receive a classId ofBruce Momjian2003-02-19
| | | | | | | | | | | | | | | | | RelOid_pg_class, and transaction locks XactLockTableId. RelId is renamed to objId. - LockObject() and UnlockObject() functions created, and their use sprinkled throughout the code to do descent locking for domains and types. They accept lock modes AccessShare and AccessExclusive, as we only really need a 'read' and 'write' lock at the moment. Most locking cases are held until the end of the transaction. This fixes the cases Tom mentioned earlier in regards to locking with Domains. If the patch is good, I'll work on cleaning up issues with other database objects that have this problem (most of them). Rod Taylor
* Allow PQcmdTuples to return row counts for MOVE and FETCH.Bruce Momjian2003-02-19
| | | | Neil Conway
* Here's some changes I made last night to psql's common.c (as found inBruce Momjian2003-02-19
| | | | | | | | | 7.3.2). It removes some code duplication and #ifdeffing, and some unstructured ugliness such as tacky breaks and an unneeded continue. Breaks up a large function into smaller functions and reduces required nesting levels, and kills a variable or two. Jeroen T. Vermeulen
* At present it is impossible to kill createuser except with kill -9Bruce Momjian2003-02-19
| | | | Oliver Elphick
* Please apply patches for contrib/ltree.Bruce Momjian2003-02-19
| | | | | | | | | | | | | | ltree_73.patch.gz - for 7.3 : Fix ~ operation bug: eg '1.1.1' ~ '*.1' ltree_74.patch.gz - for current CVS Fix ~ operation bug: eg '1.1.1' ~ '*.1' Add ? operation Optimize index storage Last change needs drop/create all ltree indexes, so only for 7.4 Teodor Sigaev
* The following patches eliminate the overflows in the j2date() and date2j()Bruce Momjian2003-02-19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | functions which limited the maximum date for a timestamp to AD 1465001. The new limit is AD 5874897. The files affected are: doc/src/sgml/datatype.sgml: Documentation change due to patch. Included is a notice about the reduced range when using an eight-byte integer for timestamps. src/backend/utils/adt/datetime.c: Replacement functions for j2date() and date2j() functions. src/include/utils/datetime.h: Corrected a bug with the limit on the earliest possible date, Nov 23,-4713 has a Julian day count of -1. The earliest possible date should be Nov 24, -4713 with a day count of 0. src/test/regress/expected/horology-no-DST-before-1970.out: src/test/regress/expected/horology-solaris-1947.out: src/test/regress/expected/horology.out: Copies of expected output for regression testing. Note: Only horology.out has been physically tested. I do not have access to a Solaris box and I don't know how to provoke the "pre-1970" test. src/test/regress/sql/horology.sql: Added some test cases to check extended range. John Cochran
* We just released new version of contrib/btree_gistBruce Momjian2003-02-19
| | | | | | | (7.3 and current CVS) with support of int8, float4, float8 in addition to int4. Thanks Janko Richter for contribution. Oleg Bartunov
* This patch includes more SGML markup fixes as well as a few minorBruce Momjian2003-02-19
| | | | | | additions to the docs. Neil Conway
* This patch adds a note to the documentation describing why theBruce Momjian2003-02-19
| | | | | | | | performance of min() and max() is slow when applied to the entire table, and suggesting the simple workaround most experienced Pg users eventually learn about (SELECT xyz ... ORDER BY xyz LIMIT 1). Neil Conway
* Add SQL 200X standards URL.Bruce Momjian2003-02-19
|
* Mark as done, fix grammar:Bruce Momjian2003-02-19
| | | | | | | | < * Prevent index uniqueness checks when UPDATE does not modifying column > * Prevent index uniqueness checks when UPDATE does not modify the column 235c235 < o Make PL/PgSQL %TYPE schema-aware > o -Make PL/PgSQL %TYPE schema-aware
* Update URL.Bruce Momjian2003-02-18
|
* Hungarian FAQ is text, not HTML, so remove it.Bruce Momjian2003-02-18
|
* New URL.Bruce Momjian2003-02-18
|
* New URL for FAQ.Bruce Momjian2003-02-18
|
* Add:Bruce Momjian2003-02-18
| | | | > * Allow WAL information to recover corrupted pg_controldata
* Update German FAQ, from Ian Barwick.Bruce Momjian2003-02-18
|
* *** empty log message ***Bruce Momjian2003-02-18
|
* Update changes from Ian Barwick.Bruce Momjian2003-02-18
|
* Add:Bruce Momjian2003-02-18
| | | | > * Allow pg_dump to dump sequences using NO_MAXVALUE and NO_MINVALUE
* Update README.Bruce Momjian2003-02-18
|
* Async_NotifyHandler must save and restore ImmediateInterruptOK. FixesTom Lane2003-02-18
| | | | | | known problem with failure to respond to 'pg_ctl stop -m fast', and probable problems if SIGINT or SIGTERM arrives while processing a SIGUSR2 interrupt that arrived while waiting for a new client query.
* Add:Bruce Momjian2003-02-18
| | | | > * Add a script to ask system configuration questions and tune postgresql.conf
* Rename 'holder' references to 'proclock' for PROCLOCK references, forBruce Momjian2003-02-18
| | | | consistency.
* Add:Bruce Momjian2003-02-17
| | | | > * Allow CIDR format to be used in pg_hba.conf
* Update marks:Bruce Momjian2003-02-17
| | | | | | | | | | | < o Allow CLUSTER to cluster all tables (Alvaro Herrera) > o -Allow CLUSTER to cluster all tables (Alvaro Herrera) 243c243 < * Allow pg_dump to dump a specific schema (Neil Conway) > * -Allow pg_dump to dump a specific schema (Neil Conway) 398c398 < * Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS (Tom) > * -Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS (Tom)
* Remove IN/EXISTS TODO.detail item.Bruce Momjian2003-02-17
|
* Mark as done:Bruce Momjian2003-02-17
| | | | | | | | | | | | > o -Add ALTER TABLE tab SET WITHOUT OIDS (Rod) > o -Allow CLUSTER to cluster all tables (Alvaro Herrera) > * -Allow pg_dump to dump a specific schema (Neil Conway) > * -Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS (Tom) > * Rod is Rod Taylor <pg@rbt.ca)>
* Update:Bruce Momjian2003-02-17
| | | | | < * -Make a transaction-safe TRUNCATE > * -Make a transaction-safe TRUNCATE (Rod)
* Done:Bruce Momjian2003-02-17
| | | | > * -Make a transaction-safe TRUNCATE
* Added Informix "database" command.Michael Meskes2003-02-17
|
* Back off previous patch to skip projection step in scan plan nodes,Tom Lane2003-02-16
| | | | | | | in the case where the node immediately above the scan is a Hash, Sort, or Material node. In these cases it's better to do the projection so that we don't store unneeded columns in the hash/sort/materialize table. Per discussion a few days ago with Anagh Lal.
* COALESCE() and NULLIF() are now first-class expressions, not macrosTom Lane2003-02-16
| | | | | that turn into CASE expressions. They evaluate their arguments at most once. Patch by Kris Jurka, review and (very light) editorializing by me.
* Update wording:Bruce Momjian2003-02-16
| | | | | < * Disallow DROP COLUMN on a column that is part of a multi-column index > * Require DROP COLUMN CASCADE for a column that is part of a multi-column index
* Marginal tweaks to make sure that roundoff error won't cause us to makeTom Lane2003-02-15
| | | | a bad choice between sorted and hashed aggregation.
* Teach planner how to propagate pathkeys from sub-SELECTs in FROM up toTom Lane2003-02-15
| | | | | | | | | the outer query. (The implementation is a bit klugy, but it would take nontrivial restructuring to make it nicer, which this is probably not worth.) This avoids unnecessary sort steps in examples like SELECT foo,count(*) FROM (SELECT ... ORDER BY foo,bar) sub GROUP BY foo which means there is now a reasonable technique for controlling the order of inputs to custom aggregates, even in the grouping case.
* Add:Bruce Momjian2003-02-15
| | | | > * Disallow DROP COLUMN on a column that is part of a multi-column index
* Propogate pg_ctl -D to the postmaster as a -D flag for identification byBruce Momjian2003-02-14
| | | | ps for multiple postmasters, for Kevin Brown.
* Fix SPI result logic for case where there are multiple statements of theTom Lane2003-02-14
| | | | same type in a rule. Per bug report from Pavel Hanak.
* Make pg_dump/restore safer for autocommit=off in postgresql.conf.Bruce Momjian2003-02-14
|
* Add:Bruce Momjian2003-02-14
| | | | > * Allow incremental backups
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-07 06:34:57 +0000