| Commit message (Collapse) | Author | Age |
... | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
|
| |
--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
|
|
|
|
| |
Joachim Wieland
|
|
|
|
| |
> * -Add COMMENT ON for all cluster global objects (roles, databases
|
|
|
|
| |
it to report reasonable errors in error cases.
|
|
|
|
| |
Hiroshi Saito
|
|
|
|
|
|
| |
records and row types.
Pavel Stehule
|
|
|
|
|
| |
used by multi-byte sequences, but futher invesetigation might prove this
to be false.
|
|
|
|
|
|
|
|
|
| |
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.
|
|
|
|
| |
> * -Allow to_char() to print localized month names
|
|
|
|
| |
Euler Taveira de Oliveira
|
|
|
|
|
|
| |
-1 or --single-transaction
Simon Riggs
|
|
|
|
|
|
| |
-1 or --single-transaction
Simon Riggs
|
|
|
|
| |
> * -Add system view to show free space map contents
|
|
|
|
| |
Mark Kirkwood
|
|
|
|
|
|
|
| |
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
|
|
| |
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.
|
|
|
|
| |
after the data in the last column on a line.
|
|
|
|
|
|
|
|
|
| |
(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
|
|
|
|
|
|
|
|
|
| |
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.
|
|
|
|
|
|
|
|
|
|
|
| |
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.
|
|
|
|
| |
Joachim Wieland
|
|
|
|
| |
> o -Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
|
|
|
|
|
| |
< o Improve psql's handling of multi-line statements
> o -Improve psql's handling of multi-line statements
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
| |
inet operators.
|
|
|
|
|
| |
> Allow VACUUM to complete faster by avoiding scanning the indexes when no
> rows were removed from the heap by the VACUUM.
|
|
|
|
|
|
| |
rows were removed from the heap by the VACUUM.
Simon Riggs
|
| |
|
|
|
|
| |
> * -Allow INET + INT8 to increment the host part of the address or
|
|
|
|
|
|
| |
minus inet.
Stephen R. van den Berg
|
|
|
|
| |
patch. Martijn van Oosterhout and Tom Lane
|
|
|
|
|
|
| |
by giving up admin privileges (only works if newer than NT4).
Magnus
|
|
|
|
|
|
| |
Windows (if newer than NT4, else works same as before).
Magnus
|
|
|
|
| |
Magnus
|
|
|
|
|
|
|
|
|
|
| |
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.
|
| |
|
|
|
|
| |
Kris Jurka
|
| |
|
|
|
|
|
| |
multibyte support work.
Add line number to error output during affix file parsing.
|
| |
|
|
|
|
| |
http://archives.postgresql.org/pgsql-committers/2006-02/msg00089.php
|