aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* > Actually, if you submit a patch that says either "SCROLL is theBruce Momjian2006-02-12
| | | | | | | | | | | | | | | | default" > or "NO SCROLL is the default", it will be rejected as incorrect. The > reason is that the default behavior is different from either of these, > as is explained in the NOTES section. Ok, so *that's* where the bit about the query plan being simple enough. Based on that, ISTM that it should be premissable for us to decide that a cursor requiring a sort isn't "simple enough" to support SCROLL. In any case, here's a patch that makes the non-standard behavior easier for people to find. Jim C. Nasby
* Fix release item ordering.Bruce Momjian2006-02-12
|
* Update back branch release notes.Bruce Momjian2006-02-12
|
* Fix release markup.Bruce Momjian2006-02-12
|
* Update release checlist.Bruce Momjian2006-02-12
|
* Update for 8.1.3.Bruce Momjian2006-02-12
|
* Update release notes for 8.1.3.Bruce Momjian2006-02-12
|
* Improve tab completion macro for default keywords.Bruce Momjian2006-02-12
|
* When performing a parallel build (make -j N) with ./configureBruce Momjian2006-02-12
| | | | | | | | --enable-depend it often tries to create the .deps directory twice and bails out when it already exists due to a race condition of if doesn't exist, then create. This patch prevents mkdir from returning an error. Kris Jurka
* List psql tab completion for various default keywords.Bruce Momjian2006-02-12
| | | | Joachim Wieland
* Done:Bruce Momjian2006-02-12
| | | | > * -Add COMMENT ON for all cluster global objects (roles, databases
* Apply code-reviewed version of for-scalar-list patch: mostly, fixingTom Lane2006-02-12
| | | | it to report reasonable errors in error cases.
* Add MSVC support for utility commands and pg_dump.Bruce Momjian2006-02-12
| | | | Hiroshi Saito
* Allow PL/pgSQL FOR statement to return values to scalars as well asBruce Momjian2006-02-12
| | | | | | records and row types. Pavel Stehule
* Use 0x01 for newlines in saved history. It was determined to be notBruce Momjian2006-02-12
| | | | | used by multi-byte sequences, but futher invesetigation might prove this to be false.
* Clean up plpgsql grammar to make sure that check_assignable() is appliedTom Lane2006-02-12
| | | | | | | | | consistently. This is mostly cosmetic right at the moment because check_assignable() does nothing for ROW or RECORD datums, but that might not always be so. This also syncs several different places that read INTO target lists. They're just enough different that it seems impractical to factor them into a single routine, but they surely should be the same as much as possible.
* Done:Bruce Momjian2006-02-12
| | | | > * -Allow to_char() to print localized month names
* Allow to_char() to print localized month and day names.Bruce Momjian2006-02-12
| | | | Euler Taveira de Oliveira
* As part of previous commit, add pg_restore option:Bruce Momjian2006-02-12
| | | | | | -1 or --single-transaction Simon Riggs
* Add psql option:Bruce Momjian2006-02-12
| | | | | | -1 or --single-transaction Simon Riggs
* Done:Bruce Momjian2006-02-12
| | | | > * -Add system view to show free space map contents
* Add contrib/pg_freespacemap to display free space map information.Bruce Momjian2006-02-12
| | | | Mark Kirkwood
* Fix more fallout from line-wrap patch, to wit, arbitrarily changingTom Lane2006-02-12
| | | | | | | the API of PQdsplen without bothering to fix its callers. Although ReportSyntaxErrorPosition could probably do with more smarts about handling control characters, for the moment I'll just get it back to handling tabs consistently.
* I've created a new shared catalog table pg_shdescription to storeBruce Momjian2006-02-12
| | | | | | | | | | | | | | | | | | comments on cluster global objects like databases, tablespaces, and roles. It touches a lot of places, but not much in the way of big changes. The only design decision I made was to duplicate the query and manipulation functions rather than to try and have them handle both shared and local comments. I believe this is simpler for the code and not an issue for callers because they know what type of object they are dealing with. This has resulted in a shobj_description function analagous to obj_description and backend functions [Create/Delete]SharedComments mirroring the existing [Create/Delete]Comments functions. pg_shdescription.h goes into src/include/catalog/ Kris Jurka
* Undo changes of trailing space in recently-committed expected files.Tom Lane2006-02-12
| | | | | | This is mostly just over-compulsiveness on my part, but the exercise did reveal one real bug: errors.out has a space difference now where it should not.
* Restore previous psql behavior of not printing useless trailing spacesTom Lane2006-02-12
| | | | after the data in the last column on a line.
* Please find enclosed a patch that lets you use \c to connectBruce Momjian2006-02-12
| | | | | | | | | (optionally) to a new host and port without exiting psql. This eliminates, IMHO, a surprise in that you can now connect to PostgreSQL on a differnt machine from the one where you started your session. This should help people who use psql as an administrative tool. David Fetter
* Actually there's a better way to do this, which is to count tuplesTom Lane2006-02-12
| | | | | | | | | during the vacuumcleanup scan that we're going to do anyway. Should save a few cycles (one calculation per page, not per tuple) as well as not having to depend on assumptions about heap and index being in step. I think this could probably be made to work for GIST too, but that code looks messy enough that I'm disinclined to try right now.
* Skip ambulkdelete scan if there's nothing to delete and the index is notTom Lane2006-02-11
| | | | | | | | | | | partial. None of the existing AMs do anything useful except counting tuples when there's nothing to delete, and we can get a tuple count from the heap as long as it's not a partial index. (hash actually can skip anyway because it maintains a tuple count in the index metapage.) GIST is not currently able to exploit this optimization because, due to failure to index NULLs, GIST is always effectively partial. Possibly we should fix that sometime. Simon Riggs w/ some review by Tom Lane.
* Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAMEBruce Momjian2006-02-11
| | | | Joachim Wieland
* Done:Bruce Momjian2006-02-11
| | | | > o -Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
* Done:Bruce Momjian2006-02-11
| | | | | < o Improve psql's handling of multi-line statements > o -Improve psql's handling of multi-line statements
* o Improve psql's handling of multi-line statementsBruce Momjian2006-02-11
| | | | | | | | Currently, while \e saves a single statement as one entry, interactive statements are saved one line at a time. Ideally all statements would be saved like \e does. Sergey E. Koposov
* Fix incorrect addition, subtraction, and overflow checking in newTom Lane2006-02-11
| | | | inet operators.
* Revert based on Tom's recommendation:Bruce Momjian2006-02-11
| | | | | > Allow VACUUM to complete faster by avoiding scanning the indexes when no > rows were removed from the heap by the VACUUM.
* Allow VACUUM to complete faster by avoiding scanning the indexes when noBruce Momjian2006-02-11
| | | | | | rows were removed from the heap by the VACUUM. Simon Riggs
* Update catalog version for INET additions.Bruce Momjian2006-02-11
|
* Done:Bruce Momjian2006-02-11
| | | | > * -Allow INET + INT8 to increment the host part of the address or
* Add INET/CIDR operators: and, or, not, plus int8, minus int8, and inetBruce Momjian2006-02-11
| | | | | | minus inet. Stephen R. van den Berg
* Clean up signedness warnings and 64-bit bugs in recent psql printingTom Lane2006-02-10
| | | | patch. Martijn van Oosterhout and Tom Lane
* Make it possible to run initdb from an admin account on Windows,Tom Lane2006-02-10
| | | | | | by giving up admin privileges (only works if newer than NT4). Magnus
* Enable pg_ctl to give up admin privileges when starting the server underTom Lane2006-02-10
| | | | | | Windows (if newer than NT4, else works same as before). Magnus
* Check that SID is enabled while checking for Windows admin privileges.Tom Lane2006-02-10
| | | | Magnus
* Change search for default operator classes so that it examines all opclassesTom Lane2006-02-10
| | | | | | | | | | regardless of the current schema search path. Since CREATE OPERATOR CLASS only allows one default opclass per datatype regardless of schemas, this should have minimal impact, and it fixes problems with failure to find a desired opclass while restoring dump files. Per discussion at http://archives.postgresql.org/pgsql-hackers/2006-02/msg00284.php. Remove now-redundant-or-unused code in typcache.c and namespace.c, and backpatch as far as 8.0.
* Clean up some signedness warnings.Tom Lane2006-02-10
|
* Fix psql after newline patch for calloc(0).Bruce Momjian2006-02-10
| | | | Kris Jurka
* Fix fallout from psql line-wrapping patch.Tom Lane2006-02-10
|
* Allow "'" symbol in affixes ("'s" affix in english): it was diallowed duringTeodor Sigaev2006-02-10
| | | | | multibyte support work. Add line number to error output during affix file parsing.
* Fix up remaining library checks.Peter Eisentraut2006-02-10
|
* renew output of regression test accordingly toTeodor Sigaev2006-02-10
| | | | http://archives.postgresql.org/pgsql-committers/2006-02/msg00089.php