aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Improvements to Maintenance and External Projects documentation.Bruce Momjian2006-08-01
| | | | | Joshua D. Drake Robert Treat
* Add:Bruce Momjian2006-07-31
| | | | | | > * Consider compressed annealing to search for query plans > > This might replace GEQO, http://sixdemonbag.org/Djinni.
* Change the relation_open protocol so that we obtain lock on a relationTom Lane2006-07-31
| | | | | | | | | | | | (table or index) before trying to open its relcache entry. This fixes race conditions in which someone else commits a change to the relation's catalog entries while we are in process of doing relcache load. Problems of that ilk have been reported sporadically for years, but it was not really practical to fix until recently --- for instance, the recent addition of WAL-log support for in-place updates helped. Along the way, remove pg_am.amconcurrent: all AMs are now expected to support concurrent update.
* Added missing ECPGget_sqlca() callMichael Meskes2006-07-31
|
* First small patches needed for regression testsMichael Meskes2006-07-31
|
* Fix memory allocation bug in pgbench.Tatsuo Ishii2006-07-31
| | | | patches submitted by ITAGAKI Takahiro.
* Change the bootstrap sequence so that toast tables for system catalogs areTom Lane2006-07-31
| | | | | | | | | | created in the bootstrap phase proper, rather than added after-the-fact by initdb. This is cleaner than before because it allows us to retire the undocumented ALTER TABLE ... CREATE TOAST TABLE command, but the real reason I'm doing it is so that toast tables of shared catalogs will now have predetermined OIDs. This will allow a reasonably clean solution to the problem of locking tables before we load their relcache entries, to appear in a forthcoming patch.
* Fix confusion between COPY FROM and COPY TO, per Gavin Sharry and Arul Shaji.Alvaro Herrera2006-07-31
|
* Fix a couple of comments.Tom Lane2006-07-30
|
* Replaced $Header$ by $§PosgreSQL$Michael Meskes2006-07-30
|
* Added missing $Header$ entries.Michael Meskes2006-07-30
|
* Modify snapshot definition so that lazy vacuums are ignored by otherAlvaro Herrera2006-07-30
| | | | | | | | | vacuums. This allows a OLTP-like system with big tables to continue regular vacuuming on small-but-frequently-updated tables while the big tables are being vacuumed. Original patch from Hannu Krossing, rewritten by Tom Lane and updated by me.
* Add:Bruce Momjian2006-07-30
| | | | > * Consider detoasting keys before sorting
* Fix WIN32 wait() return value macros to be accurate, particularlyBruce Momjian2006-07-30
| | | | | | | | | because they are used for testing the return value from system(). (WIN32 doesn't overlay the return code with other failure conditions like Unix does, so they are just simple macros.) Fix regression checks to properly handle diff failures on Win32 using the new macros.
* prevent multiplexing Windows kernel event objects we listen for across ↵Andrew Dunstan2006-07-29
| | | | various sockets - should fix the occasional stats test regression failures we see.
* Add entry:Bruce Momjian2006-07-29
| | | | | > * Add column to pg_stat_activity that shows the progress of long-running > commands like CREATE INDEX and VACUUM
* Don't use #include <crtdefs.h> for MSVC <= 1400.Bruce Momjian2006-07-29
| | | | Hiroshi Saito
* Add:Bruce Momjian2006-07-29
| | | | | | > * Add support for SQL-standard GENERATED/IDENTITY columns > > http://archives.postgresql.org/pgsql-hackers/2006-07/msg00543.php
* Add #include postgres_fe.h in two win32-specific files, because there isBruce Momjian2006-07-29
| | | | pg-specific code in those files, or might be some day.
* Adjust initialization sequence for timezone_abbreviations so thatTom Lane2006-07-29
| | | | | | | | | it's handled just about like timezone; in particular, don't try to read anything during InitializeGUCOptions. Should solve current startup failure on Windows, and avoid wasted cycles if a nondefault setting is specified in postgresql.conf too. Possibly we need to think about a more general solution for handling 'expensive to set' GUC options.
* Change the delta val from 0 and 10000 to -5000 and 5000 per recentTatsuo Ishii2006-07-28
| | | | | discussion in hackers list. Also enhance predefined benchmark scenarios to reflect the scaling factor parameter flexibly.
* Remove update TODO.detail item.Bruce Momjian2006-07-28
|
* Updates per Tom:Bruce Momjian2006-07-28
| | | | | > * Allow DISTINCT to work in multiple-argument aggregate calls < o Allow UPDATE to handle complex aggregates [update]?
* SQL2003-standard statistical aggregates, by Sergey Koposov. I've added onlyTom Lane2006-07-28
| | | | | | | the float8 versions of the aggregates, which is all that the standard requires. Sergey's original patch also provided versions using numeric arithmetic, but given the size and slowness of the code, I doubt we ought to include those in core.
* Fix table title.Tom Lane2006-07-28
|
* Make it clearer that not every Postgres character set can be used as aTom Lane2006-07-28
| | | | server-side character set.
* Update Tatsuo:Bruce Momjian2006-07-28
| | | | | < * Tatsuo is Tatsuo Ishii <t-ishii@sra.co.jp> of Software Research Assoc. > * Tatsuo is Tatsuo Ishii <ishii@sraoss.co.jp> of SRA OSS, Inc. Japan
* Variables should be free'ed only once.Michael Meskes2006-07-28
|
* Removed superfluous commentMichael Meskes2006-07-28
|
* And one more:Michael Meskes2006-07-28
| | | | Connection identifier has to be unique
* Added more SoC changes by Joachim Wieland <joe@mcknight.de>:Michael Meskes2006-07-28
| | | | | - SHOW statement puts result into a variable - COPY TO STDOUT works
* Add URL for UPDATE/SET for multiple values.Bruce Momjian2006-07-27
|
* Add for UPDATE SET for multiple values:Bruce Momjian2006-07-27
| | | | | > > A subselect can also be used as the value source.
* Fix incorrect function return code in cube_cmp and cube_dim;Tom Lane2006-07-27
| | | | update regression expected files to what I think is correct.
* revert last change - broke non-AIX platforms.Andrew Dunstan2006-07-27
|
* Aggregate functions now support multiple input arguments. I also tookTom Lane2006-07-27
| | | | | | | | the opportunity to treat COUNT(*) as a zero-argument aggregate instead of the old hack that equated it to COUNT(1); this is materially cleaner (no more weird ANYOID cases) and ought to be at least a tiny bit faster. Original patch by Sergey Koposov; review, documentation, simple regression tests, pg_dump and psql support by moi.
* another try at keeping AIX/ppc happy on cube test.Andrew Dunstan2006-07-27
|
* fix most regression tests for new cube code.Andrew Dunstan2006-07-27
|
* Original coding of pg_regress.c made the results and log directoriesTom Lane2006-07-27
| | | | | with restrictive permissions, which was not the behavior of the shell script and doesn't seem very desirable. Use the umask setting instead.
* Allow LDAP lookups from pg_service.conf.Bruce Momjian2006-07-27
| | | | Albe Laurenz
* Allow units to be specified with configuration settings.Peter Eisentraut2006-07-27
|
* Code review for bigint-LIMIT patch. Fix missed planner dependency,Tom Lane2006-07-26
| | | | | | eliminate unnecessary code, force initdb because stored rules change (limit nodes are now supposed to be int8 not int4 expressions). Update comments and error messages, which still all said 'integer'.
* Reorder items:Bruce Momjian2006-07-26
| | | | | | | | | | | | | | | | | | | | | | < o Allow point-in-time recovery to archive partially filled < write-ahead logs? [pitr] > o Add command to archive partially filled write-ahead logs? [pitr] < of a disk failure. This could be triggered by a user command or < a timer. > of a disk failure. < recovery. A function call to do this would also be useful. > recovery. > o Add reporting of the current WAL file and offset, perhaps as > part of partial log file archiving > > The offset allows parts of a WAL file to be archived using > an external program. > < o Add reporting of the current WAL file and offset, perhaps as < part of partial log file archiving < < The offset allows parts of a WAL file to be archived using < an external program.
* Work around bug in strxfmt() but in MS VS2005.Bruce Momjian2006-07-26
| | | | William ZHANG
* When a GUC string variable is not set, print the empty string (in SHOW etc.),Peter Eisentraut2006-07-26
| | | | | | not "unset". An "unset" state doesn't really exist; all variables behave like an empty string value if the string being pointed to has not been initialized.
* Convert effective_cache_size to an integer, for better integration withPeter Eisentraut2006-07-26
| | | | upcoming units feature.
* New features contributed by Tomoaki Sato.Tatsuo Ishii2006-07-26
| | | | | | | | | | | - predefined variable "tps" The value of variable tps is taken from the scaling factor specified by -s option. - -D option Variable values can be defined by -D option. - \set command now allows arithmetic calculations.
* Done:Bruce Momjian2006-07-26
| | | | > * -Change LIMIT/OFFSET and FETCH/MOVE to use int8
* Change LIMIT/OFFSET to use int8Bruce Momjian2006-07-26
| | | | Dhanaraj M
* /contrib/cube improvements:Bruce Momjian2006-07-25
| | | | | | | | | | | | | | | | | | | | Update the calling convention for all external facing functions. By external facing, I mean all functions that are directly referenced in cube.sql. Prior to my update, all functions used the older V0 calling convention. They now use V1. New Functions: cube(float[]), which makes a zero volume cube from a float array cube(float[], float[]), which allows the user to create a cube from two float arrays; one for the upper right and one for the lower left coordinate. cube_subset(cube, int4[]), to allow you to reorder or choose a subset of dimensions from a cube, using index values specified in the array. Joshua Reich
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-06 05:25:03 +0000