summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2006-02-12Update back branch release notes.Bruce Momjian
2006-02-12Fix release markup.Bruce Momjian
2006-02-12Update release checlist.Bruce Momjian
2006-02-12Update for 8.1.3.Bruce Momjian
2006-02-12Update release notes for 8.1.3.Bruce Momjian
2006-02-12Improve tab completion macro for default keywords.Bruce Momjian
2006-02-12When performing a parallel build (make -j N) with ./configureBruce Momjian
--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
2006-02-12List psql tab completion for various default keywords.Bruce Momjian
Joachim Wieland
2006-02-12Done:Bruce Momjian
> * -Add COMMENT ON for all cluster global objects (roles, databases
2006-02-12Apply code-reviewed version of for-scalar-list patch: mostly, fixingTom Lane
it to report reasonable errors in error cases.
2006-02-12Add MSVC support for utility commands and pg_dump.Bruce Momjian
Hiroshi Saito
2006-02-12Allow PL/pgSQL FOR statement to return values to scalars as well asBruce Momjian
records and row types. Pavel Stehule
2006-02-12Use 0x01 for newlines in saved history. It was determined to be notBruce Momjian
used by multi-byte sequences, but futher invesetigation might prove this to be false.
2006-02-12Clean up plpgsql grammar to make sure that check_assignable() is appliedTom Lane
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.
2006-02-12Done:Bruce Momjian
> * -Allow to_char() to print localized month names
2006-02-12Allow to_char() to print localized month and day names.Bruce Momjian
Euler Taveira de Oliveira
2006-02-12As part of previous commit, add pg_restore option:Bruce Momjian
-1 or --single-transaction Simon Riggs
2006-02-12Add psql option:Bruce Momjian
-1 or --single-transaction Simon Riggs
2006-02-12Done:Bruce Momjian
> * -Add system view to show free space map contents
2006-02-12Add contrib/pg_freespacemap to display free space map information.Bruce Momjian
Mark Kirkwood
2006-02-12Fix more fallout from line-wrap patch, to wit, arbitrarily changingTom Lane
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.
2006-02-12I've created a new shared catalog table pg_shdescription to storeBruce Momjian
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
2006-02-12Undo changes of trailing space in recently-committed expected files.Tom Lane
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.
2006-02-12Restore previous psql behavior of not printing useless trailing spacesTom Lane
after the data in the last column on a line.
2006-02-12Please find enclosed a patch that lets you use \c to connectBruce Momjian
(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
2006-02-12Actually there's a better way to do this, which is to count tuplesTom Lane
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.
2006-02-11Skip ambulkdelete scan if there's nothing to delete and the index is notTom Lane
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.
2006-02-11Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAMEBruce Momjian
Joachim Wieland
2006-02-11Done:Bruce Momjian
> o -Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
2006-02-11Done:Bruce Momjian
< o Improve psql's handling of multi-line statements > o -Improve psql's handling of multi-line statements
2006-02-11o Improve psql's handling of multi-line statementsBruce Momjian
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
2006-02-11Fix incorrect addition, subtraction, and overflow checking in newTom Lane
inet operators.
2006-02-11Revert based on Tom's recommendation:Bruce Momjian
> Allow VACUUM to complete faster by avoiding scanning the indexes when no > rows were removed from the heap by the VACUUM.
2006-02-11Allow VACUUM to complete faster by avoiding scanning the indexes when noBruce Momjian
rows were removed from the heap by the VACUUM. Simon Riggs
2006-02-11Update catalog version for INET additions.Bruce Momjian
2006-02-11Done:Bruce Momjian
> * -Allow INET + INT8 to increment the host part of the address or
2006-02-11Add INET/CIDR operators: and, or, not, plus int8, minus int8, and inetBruce Momjian
minus inet. Stephen R. van den Berg
2006-02-10Clean up signedness warnings and 64-bit bugs in recent psql printingTom Lane
patch. Martijn van Oosterhout and Tom Lane
2006-02-10Make it possible to run initdb from an admin account on Windows,Tom Lane
by giving up admin privileges (only works if newer than NT4). Magnus
2006-02-10Enable pg_ctl to give up admin privileges when starting the server underTom Lane
Windows (if newer than NT4, else works same as before). Magnus
2006-02-10Check that SID is enabled while checking for Windows admin privileges.Tom Lane
Magnus
2006-02-10Change search for default operator classes so that it examines all opclassesTom Lane
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.
2006-02-10Clean up some signedness warnings.Tom Lane
2006-02-10Fix psql after newline patch for calloc(0).Bruce Momjian
Kris Jurka
2006-02-10Fix fallout from psql line-wrapping patch.Tom Lane
2006-02-10Allow "'" symbol in affixes ("'s" affix in english): it was diallowed duringTeodor Sigaev
multibyte support work. Add line number to error output during affix file parsing.
2006-02-10Fix up remaining library checks.Peter Eisentraut
2006-02-10renew output of regression test accordingly toTeodor Sigaev
http://archives.postgresql.org/pgsql-committers/2006-02/msg00089.php
2006-02-10Done:Bruce Momjian
< o Allow multi-line column values to align in the proper columns > o -Allow multi-line column values to align in the proper columns
2006-02-10Allow psql multi-line column values to align in the proper columnsBruce Momjian
If the second output column value is 'a\nb', the 'b' should appear in the second display column, rather than the first column as it does now. Change libpq's PQdsplen() to return more useful values. > Note: this changes the PQdsplen function, it can now return zero or > minus one which was not possible before. It doesn't appear anyone is > actually using the functions other than psql but it is a change. The > functions are not actually documentated anywhere so it's not like we're > breaking a defined interface. The new semantics follow the Unicode > standard. BACKWARD COMPATIBLE CHANGE. The only user-visible change I saw in the regression tests is that a SELECT * on a table where all the columns have been dropped doesn't return a blank line like before. This seems like a step forward. Martijn van Oosterhout