aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Fix longstanding bug found by Atsushi Ogawa: _bt_check_unique would markTom Lane2005-10-12
| | | | | | the wrong buffer dirty when trying to kill a dead index entry that's on a page after the one it started on. No risk of data corruption, just inefficiency, but still a bug.
* Fix another recently-changed place that was messing with spinlock-Tom Lane2005-10-12
| | | | protected data structures and not using a volatile pointer for same.
* Do all accesses to shared buffer headers through volatile-qualifiedTom Lane2005-10-12
| | | | | | | pointers, to ensure that compilers won't rearrange accesses to occur while we're not holding the buffer header spinlock. It's probably not necessary to mark volatile in every single place in bufmgr.c, but better safe than sorry. Per trouble report from Kevin Grittner.
* Add warning about plperl nested named subroutinesBruce Momjian2005-10-12
| | | | Andrew Dunstan
* No longer needed:Bruce Momjian2005-10-12
| | | | | | | | | | | < < * Add code to detect an SMP machine and handle spinlocks accordingly < from distributted.net, http://www1.distributed.net/source, < in client/common/cpucheck.cpp < < On SMP machines, it is possible that locks might be released shortly, < while on non-SMP machines, the backend should sleep so the process < holding the lock can complete and release it.
* Rearrange:Bruce Momjian2005-10-12
| | | | | | | | | < o %Add dumping of comments on composite type columns < o %Add dumping of comments on index columns < o Stop dumping CASCADE on DROP TYPE commands in clean mode > o %Add dumping of comments on index columns and composite type columns 604a603 > o Stop dumping CASCADE on DROP TYPE commands in clean mode
* Done:Bruce Momjian2005-10-12
| | | | | | | < o %Replace crude DELETE FROM method of pg_dumpall --clean for < cleaning of roles with separate DROP commands 608a607 >
* Add:Bruce Momjian2005-10-12
| | | | | | < > o Allow pg_dump --clean to drop roles that own objects or have > privileges
* Update keywords table for 8.1.Peter Eisentraut2005-10-12
|
* Add description:Bruce Momjian2005-10-12
| | | | | | | | | < * Prevent libpq's PQfnumber() from lowercasing the column name? > * Prevent libpq's PQfnumber() from lowercasing the column name > > One idea is to lowercase all identifiers except those that are > surrounded by quotes. >
* Add:Bruce Momjian2005-10-12
| | | | > o Add options like pg_restore -l and -L to pg_dump
* Add:Bruce Momjian2005-10-11
| | | | | | | > o Allow selection of individual object(s) of all types, not just > tables > o In a selective dump, allow dumping of an object and all its > dependencies
* must commit *after* autoconf, not beforeREL8_1_0BETA3PostgreSQL Daemon2005-10-11
|
* update to beta3 before tagging ...PostgreSQL Daemon2005-10-11
|
* Fix typo in sample pg_hba.conf; per IRC report from Bernhard Neuhauser.Neil Conway2005-10-11
|
* Release notes up to date as of today.Tom Lane2005-10-11
|
* Add infrastructure for making spins_per_delay variable depending onTom Lane2005-10-11
| | | | | | whether we seem to be running in a uniprocessor or multiprocessor. The adjustment rules could probably still use further tweaking, but I'm convinced this should be a win overall.
* Don't use a non-locked pre-test of the spinlock on x86_64 machines.Tom Lane2005-10-11
| | | | | The pre-test has been shown to be a big loss on Opterons and at best a wash on EM64T.
* Document that get_attstatsslot/free_attstatsslot only need to be passedTom Lane2005-10-11
| | | | | | | | valid type information if they are asked to fetch the values part of a pg_statistic slot; these arguments are unneeded if fetching only the numbers part. Use this to save a catcache lookup in btcostestimate, which is looking like a bit of a hotspot in recent profiling. Not a big savings, but since it's essentially free, might as well do it.
* Fix oversight in 8.0 modification of RestrictInfo data structures.Tom Lane2005-10-11
| | | | | | | | A RestrictInfo representing an OR clause now contains two versions of the contained expression, one with sub-RestrictInfos and one without. clause_selectivity() should descend to the version with sub-RestrictInfos so that it has a chance of caching its results for the OR's sub-clauses. Failing to do so resulted in redundant planner effort.
* Remove the DELETEs from pg_shadow and pg_group that pg_dumpall used toTom Lane2005-10-10
| | | | | | | | emit when given the --clean option, in favor of individual DROP ROLE commands. The old technique could not possibly work in 8.1, and was never a very good idea anyway IMHO. The DROP ROLE approach has the defect that the DROPs will fail for roles that own objects or have privileges, but perhaps we can improve that later.
* Use a safer order of operations in dropdb(): rollbackable operations,Tom Lane2005-10-10
| | | | | | ie removing shared-dependency entries, should happen before non-rollbackable ones. That way a failure during the rollbackable part doesn't leave us with inconsistent state.
* Document the process to update translations.Peter Eisentraut2005-10-10
|
* Translation updatePeter Eisentraut2005-10-10
|
* Fix the problem of GRANTs creating "dangling" privileges not directlyTom Lane2005-10-10
| | | | | | traceable to grant options. As per my earlier proposal, a GRANT made by a role member has to be recorded as being granted by the role that actually holds the grant option, and not the member.
* <limits.h> is now needed here, for INT_MAX. Per Michael Fuhr.Tom Lane2005-10-10
|
* Fix (hopefully for the last time) problems with datetime values displayingTom Lane2005-10-09
| | | | | | | like '23:59:60' because of fractional-second roundoff problems. Trying to control this upstream of the actual display code was hopeless; the right way is to explicitly round fractional seconds in the display code and then refigure the results if the fraction rounds up to 1. Per bug #1927.
* Fix a thinko in description of krb_server_hostname.Tom Lane2005-10-08
|
* Fix up grammar in variable description string.Tom Lane2005-10-08
|
* Fix Kerberos authentication in wake of virtual-hosts changes --- needTom Lane2005-10-08
| | | | | | | to call krb5_sname_to_principal() always. Also, use krb_srvname rather than the hardwired string 'postgres' as the appl_version string in the krb5_sendauth/recvauth calls, to avoid breaking compatibility with PG 8.0. Magnus Hagander
* Remove unnecessary ABORT commands in dblink regression tests.Bruce Momjian2005-10-08
|
* Cosmetic improvements to dblink.Bruce Momjian2005-10-08
|
* Cosmetic changes to dblink.Bruce Momjian2005-10-08
|
* Cosmetic changes to dblink.Bruce Momjian2005-10-08
|
* Add spacing around operators.Bruce Momjian2005-10-08
|
* Fix LWLockAssign() so that it can safely be executed after postmasterTom Lane2005-10-07
| | | | initialization. Add spinlocking, fix EXEC_BACKEND unsafeness.
* Minor parentheses cleanup.Bruce Momjian2005-10-07
|
* Add spaces around operator.Bruce Momjian2005-10-07
|
* Allocate a few extra LWLocks for possible use by add-on modules.Tom Lane2005-10-07
| | | | Per request from Marc Munro.
* Marginal performance improvement in aclmask(): don't bother withTom Lane2005-10-07
| | | | | | testing ownership if the caller isn't interested in any GOPTION bits (which is the common case). It did not matter in 8.0 where the ownership test was just a trivial equality test, but it matters now.
* Recognize ERROR_SHARING_VIOLATION (translate to EACCES), increase logTom Lane2005-10-07
| | | | | | level for unrecognized win32 error codes to LOG, and make messages conform to style guide. Per old suggestion from Qingqing Zhou, which seems to have gotten lost in the shuffle.
* (Apologies for fat-fingering cvs commit command...) Should have read:Tom Lane2005-10-07
| | | | | | | Remove unportable use of tfind/tsearch in favor of bsearch. Fix up random number generator to use random() not rand() and to actually honor its min/max arguments properly. That wasn't so important before, but with exposure of capability to ask for general ranges, it will be.
* gniTom Lane2005-10-07
|
* Remove an unused typedef.Alvaro Herrera2005-10-07
|
* Update:Bruce Momjian2005-10-07
| | | | | | | | < * Consider compressing indexes by storing key prefix values shared by > * Consider compressing indexes by storing key values duplicated in 735a736,737 > > This is difficult because it requires datatype-specific knowledge.
* Add:Bruce Momjian2005-10-07
| | | | | | < > * Consider compressing indexes by storing key prefix values shared by > several rows as a single index entry
* Minor dbf2pg fixes from Martin Pitt: check for failure when issuingTom Lane2005-10-06
| | | | CREATE TABLE command, and translate dBase's 'M' field type to 'text'.
* Marginal speedup in RelationIsVisible and TypeIsVisible: avoid a redundantTom Lane2005-10-06
| | | | | | | cache lookup in the success case. This won't help much for cases where the given relation is far down the search path, but it does not hurt in any cases either; and it requires only a little new code. Per gripe from Jim Nasby about slowness of \d with many tables.
* Minor API cleanup for async notifications: we can only register theNeil Conway2005-10-06
| | | | | current backend in pg_listener, so there is little point in making the PID to register part of async.c's public API. Other minor tweaks.
* Minor tweaks for PL/PgSQL documentation.Neil Conway2005-10-06
|