| Commit message (Collapse) | Author | Age |
... | |
|
|
|
|
|
| |
statement
Pavel Stehule
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
the cheapest-total inner path as a new candidate while truncating the
sort key list, if it already matched the full sort key list. This is
too much of a corner case to be worth back-patching, since it's unusual
for the cheapest total path to be sorted, and anyway no real harm is
done (except in JOIN_SEMI/ANTI cases where cost_mergejoin is a bit
broken at the moment). But it wasn't behaving as intended, so fix it.
Noted while examining a test case from Kevin Grittner. This error doesn't
explain his issue, but it does explain why "set enable_seqscan = off"
seemed to reproduce it for me.
|
| |
|
|
|
|
|
|
|
| |
behavior of concurrent commands in cases where rows are being added and
removed from matching query criteria.
Minor word-smithing.
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
| |
unnecessary thread address output parameter, to make this code look more
like that in pg_restore.
|
|
|
|
|
|
| |
per gripe from David Wheeler that this was mentioned nowhere.
In passing, editorialize a bit on the description of the SQL:2008
equivalent syntax.
|
|
|
|
|
|
|
|
| |
in the string, not just at the start. Per bug #4629 from Martin Blazek.
Back-patch to 8.2; prior versions don't have the problem, at least not in
the reported case, because they don't try to recognize INTO in non-SELECT
statements. (IOW, this is really fallout from the RETURNING patch.)
|
|
|
|
|
|
|
|
| |
post-data step is run in a separate worker child (a thread on Windows, a child
process elsewhere) up to the concurrent number specified by the new pg_restore
command-line --multi-thread | -m switch.
Andrew Dunstan, with some editing by Tom Lane.
|
|
|
|
|
|
|
|
| |
qualifier, and add support for this in pg_dump.
This allows TOAST tables to have user-defined fillfactor, and will also
enable us to move the autovacuum parameters to reloptions without taking
away the possibility of setting values for TOAST tables.
|
|
|
|
| |
output file.
|
| |
|
| |
|
| |
|
| |
|
|
|
|
| |
Alvaro.
|
|
|
|
|
|
| |
It's missing in older versions too, but it doesn't seem worth
back-porting. All negative are just harmlessly treated as "no limit", and
tightening the check might even brake an application that relies on it.
|
| |
|
| |
|
| |
|
|
|
|
|
| |
as the preferred spelling of that zone name, corrects historical DST
information for Switzerland and Cuba.
|
|
|
|
|
|
|
|
|
|
|
|
| |
encoding conversion functions. These are not can't-happen cases because
it's possible to create a conversion with the wrong conversion function
for the specified encoding pair. That would lead to an Assert crash in
an Assert-enabled build, or incorrect conversion otherwise, neither of
which is desirable. This would be a DOS issue if production databases
were customarily built with asserts enabled, but fortunately that's not so.
Per an observation by Heikki.
Back-patch to all supported branches.
|
|
|
|
| |
Per Tommy Gildseth <tommy.gildseth@usit.uio.no> report
|
| |
|
|
|
|
|
| |
data should be restored.
Backpatch only for 8.3 because previous versions haven't such layer.
|
|
|
|
|
|
| |
casting the value of the variable later.
Per comments from Tom.
|
|
|
|
|
|
|
|
| |
to the documented API value. The previous code got it right as
it's implemented, but accepted too much/too little compared to
the API documentation.
Per comment from Zdenek Kotala.
|
|
|
|
|
|
| |
the JOB_OBJECT_UILIMIT_HANDLES flag.
Dave Page & Magnus Hagander
|
|
|
|
| |
ITAGAKI Takahiro
|
|
|
|
|
|
| |
when building on mingw.
ITAGAKI Takahiro
|
| |
|
|
|
|
|
|
| |
refactor the relcache code that used to do that. This allows other callers
(particularly autovacuum) to do the same without necessarily having to open
and lock a table.
|
| |
|
|
|
|
|
| |
yet another failure case in AIX's getaddrinfo(). Per report and patch
by Andrew Chernow.
|
|
|
|
| |
results out of order because of locking, per bug report 4593
|
| |
|
|
|
|
|
| |
RestoreBkpBlocks. Went missing in my recent refactoring patch, as pointed
out by Simon's hot standby patch.
|
|
|
|
|
| |
way pg_config.h is handled. This avoids reruns of config.status on every
build, if configure has been rerun.
|
|
|
|
| |
Stephen Frost, with help from KaiGai Kohei and others
|
|
|
|
|
|
|
| |
pages were marked as clean as well. The idea is to avoid defeating OS
readahead by skipping a page here and there, and also makes it less likely
that we miss an opportunity to advance relfrozenxid, for the sake of only
a few skipped pages.
|
|
|
|
| |
Jonah Harris, with minor tinkering by me.
|
|
|
|
| |
Bernd Helmle
|
|
|
|
| |
Original patch from Hiroshi Inoue.
|
|
|
|
|
| |
For some reason it broke OpenBSD compile even when it's inside a
#ifdef WIN32 block.....
|
| |
|
|
|
|
|
|
|
| |
case that the command is rewritten into another type of command. The old
behavior to return the command tag of the last executed command was
pretty surprising. In PL/pgSQL, for example, it meant that if a command
was rewritten to a utility statement, FOUND wasn't set at all.
|