aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* 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
* Done:Bruce Momjian2006-02-10
| | | | | < o Allow multi-line column values to align in the proper columns > o -Allow multi-line column values to align in the proper columns
* Allow psql multi-line column values to align in the proper columnsBruce Momjian2006-02-10
| | | | | | | | | | | | | | | | | | | | | | | 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
* This fixes pg_dump so that when using the '-O' no owners option it doesBruce Momjian2006-02-09
| | | | | | | | | | | | | | | | | | | | | not print the owner name in the object comment. eg: -- -- Name: actor; Type: TABLE; Schema: public; Owner: chriskl; Tablespace: -- Becomes: -- -- Name: actor; Type: TABLE; Schema: public; Owner: -; Tablespace: -- This makes it far easier to do 'user independent' dumps. Especially for distribution to third parties. Christopher Kings-Lynne
* Provide the libpq error message when PQputline or PQendcopy fails.Tom Lane2006-02-09
|
* 1 Fix bug with very short word: prefix and suffix might be overlapped,Teodor Sigaev2006-02-09
| | | | | | | sorry but fix can't be applyed to previous version: it's require refill tsvector... 2 Small optimize of load time for huge dictionaries 3 use palloc instead of malloc during load dict file
* Use "bitwise" rather than "binary for AND/OR descriptions in \d, toBruce Momjian2006-02-09
| | | | match SGML documentation.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-06 10:31:15 +0000