- 12 Feb, 2006 31 commits
-
-
Bruce Momjian authored
Joshua D. Drake
-
Bruce Momjian authored
> o %Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
-
Bruce Momjian authored
Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME Joachim Wieland
-
Bruce Momjian authored
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
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
--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
-
Bruce Momjian authored
Joachim Wieland
-
Bruce Momjian authored
> * -Add COMMENT ON for all cluster global objects (roles, databases
-
Tom Lane authored
it to report reasonable errors in error cases.
-
Bruce Momjian authored
Hiroshi Saito
-
Bruce Momjian authored
records and row types. Pavel Stehule
-
Bruce Momjian authored
used by multi-byte sequences, but futher invesetigation might prove this to be false.
-
Tom Lane authored
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.
-
Bruce Momjian authored
> * -Allow to_char() to print localized month names
-
Bruce Momjian authored
Euler Taveira de Oliveira
-
Bruce Momjian authored
-1 or --single-transaction Simon Riggs
-
Bruce Momjian authored
-1 or --single-transaction Simon Riggs
-
Bruce Momjian authored
> * -Add system view to show free space map contents
-
Bruce Momjian authored
Mark Kirkwood
-
Tom Lane authored
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.
-
Bruce Momjian authored
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
-
Tom Lane authored
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.
-
Tom Lane authored
after the data in the last column on a line.
-
Bruce Momjian authored
(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
-
Tom Lane authored
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.
-
- 11 Feb, 2006 9 commits
-
-
Tom Lane authored
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.
-
Bruce Momjian authored
Joachim Wieland
-
Bruce Momjian authored
> o -Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
-
Bruce Momjian authored
< o Improve psql's handling of multi-line statements > o -Improve psql's handling of multi-line statements
-
Bruce Momjian authored
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
-
Tom Lane authored
inet operators.
-
Bruce Momjian authored
> Allow VACUUM to complete faster by avoiding scanning the indexes when no > rows were removed from the heap by the VACUUM.
-
Bruce Momjian authored
rows were removed from the heap by the VACUUM. Simon Riggs
-
Bruce Momjian authored
-