aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Update Chinese FAQ, per Magnus.Bruce Momjian2005-05-11
|
* Tag 1000000L as long for compuation.Bruce Momjian2005-05-11
|
* Fix newly introduced spelling error.Neil Conway2005-05-11
|
* Add mention that not all functions are listed.Bruce Momjian2005-05-11
| | | | Update Chinese FAQ for HTML.
* This patch refactors away some duplicated code in the index AM buildNeil Conway2005-05-11
| | | | | | methods: they all invoke UpdateStats() since they have computed the number of heap tuples, so I created a function in catalog/index.c that each AM now calls.
* Add Chinese FAQ.Bruce Momjian2005-05-11
| | | | laser@pgsqldb.com
* This patch reduces the size of the message header used by statisticsNeil Conway2005-05-11
| | | | | | | | | | | | | | | | | | | | | | | | | | collector messages, per recent discussion on pgsql-patches. This actually required quite a few changes -- for example, "databaseid != InvalidOid" was used to check whether a slot in the backend entry table was initialized, but that no longer works since the slot might be initialized prior to receiving the BESTART message which contains the database id. We now use procpid > 0 to indicate that a slot is non-empty. Other changes: - various comment improvements and cleanups - there's no need to zero-out the entire activity buffer in pgstat_add_backend(), we can just set activity[0] to '\0'. - remove the counting of the # of connections to a database; this was not used anywhere One change in behavior I wasn't sure about: previously, the code would create a hash table entry for a database as soon as any message was received whose header referenced that database. Now, we only create hash table entries as needed (so for example BESTART won't create a database hash table entry, since it doesn't need to access anything in the per-db hash table). It would be easy enough to retain the old behavior, but AFAICS it is not required.
* Code cleanup: in C89, there is no point casting the first argument toNeil Conway2005-05-11
| | | | | | memset() or MemSet() to a char *. For one, memset()'s first argument is a void *, and further void * can be implicitly coerced to/from any other pointer type.
* Back out check for unreferenced files.Bruce Momjian2005-05-10
| | | | Heikki Linnakangas
* Item removed from CVS:Bruce Momjian2005-05-10
| | | | | < * -Check for unreferenced table files created by transactions that were > * Check for unreferenced table files created by transactions that were
* Report index name on CLUSTER failure. Also, suggest ALTER TABLEBruce Momjian2005-05-10
| | | | | WITHOUT CLUSTER for cluster failure of a single table in a full db cluster.
* Fix typo in comment.Neil Conway2005-05-10
|
* Add:Bruce Momjian2005-05-10
| | | | > * Fix sgmltools so PDFs can be generated with bookmarks
* Add:Bruce Momjian2005-05-10
| | | | | > * Allow postgresql.conf values to be set so they can not be changed by > the user
* Done:Bruce Momjian2005-05-10
| | | | | | | | < * Add session start time and last statement time to pg_stat_activity > * -Add session start time and last statement time to pg_stat_activity 134c134 < * Add the client IP address and port to pg_stat_activity > * -Add the client IP address and port to pg_stat_activity
* Regression tests for the COPY CSV header feature. From Andrew Dunstan.Neil Conway2005-05-10
|
* Rename encryption section.Bruce Momjian2005-05-09
|
* Remove encryption FAQ item now that we have a doc section.Bruce Momjian2005-05-09
|
* Improve wording of new documentation section on encryption, and move itBruce Momjian2005-05-09
| | | | a few sections up.
* Update "expected" regression test output for the recent stats collectorNeil Conway2005-05-09
| | | | checkin. My apologies for breaking the tests.
* Fix duplicate call to WRITE_NODE_FIELD(whereClause) in _outSelectStmtTatsuo Ishii2005-05-09
|
* Add some defenses against functions declared to return set that don'tTom Lane2005-05-09
| | | | actually follow the protocol; per example from Kris Jurka.
* Complete the following TODO items:Neil Conway2005-05-09
| | | | | | | | | * Add session start time to pg_stat_activity * Add the client IP address and port to pg_stat_activity Original patch from Magnus Hagander, code review by Neil Conway. Catalog version bumped. This patch sends the client IP address and port number in every statistics message; that's not ideal, but will be fixed up shortly.
* Update release notes for upcoming re-releases.Tom Lane2005-05-09
|
* Update release checklist to reflect that HISTORY and INSTALL don'tTom Lane2005-05-08
| | | | need to be created by hand anymore.
* Add encryption section to documentation.Bruce Momjian2005-05-08
| | | | Christopher Browne
* Documentation adjustments.Bruce Momjian2005-05-08
| | | | Vladimir Chukharev
* Repair very-low-probability race condition between relation extensionTom Lane2005-05-07
| | | | | | | | and VACUUM: in the interval between adding a new page to the relation and formatting it, it was possible for VACUUM to come along and decide it should format the page too. Though not harmful in itself, this would cause data loss if a third transaction were able to insert tuples into the vacuumed page before the original extender got control back.
* Adjust time qual checking code so that we always check TransactionIdIsInProgressTom Lane2005-05-07
| | | | | | | before we check commit/abort status. Formerly this was done in some paths but not all, with the result that a transaction might be considered committed for some purposes before it became committed for others. Per example found by Jan Wieck.
* Fix case in which a debug printout would print already-pfreed data.Tom Lane2005-05-07
|
* Add description:Bruce Momjian2005-05-07
| | | | | | | | < Currently locale can only be set during initdb. > Currently locale can only be set during initdb. No global tables have > locale-aware columns. However, the database template used during > database creation might have locale-aware indexes. The indexes would > need to be reindexed to match the new locale.
* Add comment on C locale test for upper/lower/initcap().Bruce Momjian2005-05-07
|
* Revert the ld --as-needed patch. This breaks Fedora Core 3, due to a strangeNeil Conway2005-05-07
| | | | | | | | | | interaction between ld, readline, termcap, and psql. The symptom is psql failing with this error on startup: symbol lookup error: /usr/lib64/libreadline.so.4: undefined symbol: BC I'm still trying to find the best way to solve this, but in the mean time I'm reverting the patch in order to unbreak FC3.
* Done:Bruce Momjian2005-05-07
| | | | > o -Allow COPY to optionally include column headings in the first line
* Add items:Bruce Momjian2005-05-07
| | | | | | | | | | | | | | | | | | | | | | > * Prevent to_char() on interval from returning meaningless values > > For example, to_char('1 month', 'mon') is meaningless. Basically, > most date-related parameters to to_char() are meaningless for > intervals because interval is not anchored to a date. > > * Allow to_char() on interval values to accumulate the highest unit > requested > > o to_char(INTERVAL '1 hour 5 minutes', 'MI') => 65 > o to_char(INTERVAL '43 hours 20 minutes', 'MI' ) => 2600 > o to_char(INTERVAL '43 hours 20 minutes', 'WK:DD:HR:MI') => 0:1:19:20 > o to_char(INTERVAL '3 years 5 months','MM') => 41 > > Some special format flag would be required to request such > accumulation. Such functionality could also be added to EXTRACT. > Prevent accumulation that crosses the month/day boundary because of > the uneven number of days in a month. >
* Add COPY WITH CVS HEADER to allow a heading line as the first line inBruce Momjian2005-05-07
| | | | | | COPY. Andrew Dunstan
* Update backend flowchart HTML.Bruce Momjian2005-05-06
|
* Update flowchart sections to match current CVS.Bruce Momjian2005-05-06
|
* Markup improvements.Bruce Momjian2005-05-06
|
* Update backend flowchard wordingBruce Momjian2005-05-06
|
* Adjust question spacing.Bruce Momjian2005-05-06
|
* For some reason access/tupmacs.h has been #including utils/memutils.h,Tom Lane2005-05-06
| | | | | | | which is neither needed by nor related to that header. Remove the bogus inclusion and instead include the header in those C files that actually need it. Also fix unnecessary inclusions and bad inclusion order in tsearch2 files.
* Update misleading comment about the use of lanpltrusted ... it isTom Lane2005-05-06
| | | | significant regardless of the value of lanispl.
* Update comment to mention "Name classification hierarchy" as place toBruce Momjian2005-05-06
| | | | check for reserved words.
* Remove documentation that CSV didn't handle carriage returns and lineBruce Momjian2005-05-06
| | | | feeds properly.
* Convert some mulit-line comments in copy.c to single line, as appropriate.Bruce Momjian2005-05-06
|
* Marginal performance improvements in dynahash: make sure that everythingTom Lane2005-05-06
| | | | | | associated with a hashtable is allocated in that hashtable's private context, so that hash_destroy only has to destroy the context and not do any retail pfree's; and tighten the inner loop of hash_seq_search.
* Fix bogus hashtable setup. (This code has quite a few other problemsTom Lane2005-05-05
| | | | too, but that one is in my way at the moment.)
* Make standalone backends ignore pg_database.datallowconn, so that thereTom Lane2005-05-05
| | | | is a way to recover from disabling connections to all databases at once.
* On Win32, libintl replaces snprintf() with its own version thatBruce Momjian2005-05-05
| | | | | | understands arg control, so we don't need our own. In fact, it also uses macros that conflict with ours, so we _can't_ use our own.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-03 20:00:39 +0000