- 29 Mar, 2007 7 commits
-
-
Magnus Hagander authored
-
Bruce Momjian authored
< o Add more logical syntax CLUSTER table USING index; > o Add more logical syntax CLUSTER table USING index;
-
Bruce Momjian authored
o Add more logical syntax CLUSTER table USING index; < o Add more logical syntax CLUSTER table ORDER BY index; > o Add more logical syntax CLUSTER table USING index;
-
Tom Lane authored
required memory context when handling client-specified parameter types for an unnamed statement. Per report from Kris Jurka.
-
Magnus Hagander authored
ecpglib supports it. Change configure (patch from Bruce) and msvc build system to no longer require pthreads on win32, since all parts of postgresql can be thread-safe using the native platform functions.
-
Michael Meskes authored
win32 threads. - Fixed regression tests to run threading tests.
-
Tom Lane authored
--- Simon. Also, code review and cleanup for the previous COPY-no-WAL patches --- Tom.
-
- 28 Mar, 2007 6 commits
-
-
Neil Conway authored
properties of the "text" type, and then simplify the code accordingly. Patch from Jeremy Drake.
-
Neil Conway authored
from PuTTY with is under minimal BSD/MIT license. Marko Kreen.
-
Alvaro Herrera authored
its table list and then rechecks pgstat before vacuuming each table to verify that no one has vacuumed the table in the meantime. In the current autovacuum world this only means that a worker will not vacuum a table that a user has vacuumed manually after the worker started. When support for multiple autovacuum workers is introduced, this will reduce the probability of simultaneous workers on the same database doing redundant work.
-
Magnus Hagander authored
ITAGAKI Takahiro
-
Bruce Momjian authored
* Automatically create rules on views so they are updateable, per SQL99 > http://archives.postgresql.org/pgsql-patches/2006-08/msg00255.php
-
Tom Lane authored
-
- 27 Mar, 2007 8 commits
-
-
Tom Lane authored
seen by code inspecting the expression. The best way to do this seems to be to drop the original representation as a function invocation, and instead make a special expression node type that represents applying the element-type coercion function to each array element. In this way the element function is exposed and will be checked for volatility. Per report from Guillaume Smet.
-
Magnus Hagander authored
-
Alvaro Herrera authored
table entries to a separate routine. Don't pass the pgstat database entry to do_autovacuum; rather, have it fetch it by itself.
-
Bruce Momjian authored
< * %Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(), < pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef() < < These would be for application use, not for use by pg_dump. <
-
Bruce Momjian authored
> > * Allow configuration of backend priorities via the operating system > > Though backend priorities make priority inversion during lock > waits possible, research shows that this is not a huge problem. > http://archives.postgresql.org/pgsql-general/2007-02/msg00493.php
-
Bruce Momjian authored
Marko Kreen
-
Tom Lane authored
-
Bruce Momjian authored
mention cvsup last.
-
- 26 Mar, 2007 15 commits
-
-
Bruce Momjian authored
* Improve dead row detection during multi-statement transactions usage
-
Bruce Momjian authored
> * Increase the number of rows recognized as dead during multi-statement > transactions > > http://archives.postgresql.org/pgsql-patches/2007-03/msg00358.php >
-
Bruce Momjian authored
-
Bruce Momjian authored
instructions from Berkeley.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
-
Tom Lane authored
A DBA is allowed to create a language in his database if it's marked "tmpldbacreate" in pg_pltemplate. The factory default is that this is set for all standard trusted languages, but of course a superuser may adjust the settings. In service of this, add the long-foreseen owner column to pg_language; renaming, dropping, and altering owner of a PL now follow normal ownership rules instead of being superuser-only. Jeremy Drake, with some editorialization by Tom Lane.
-
Teodor Sigaev authored
-
Teodor Sigaev authored
Magnus Hagander. Also, now it ignores space symbol after stopwords.
-
Tatsuo Ishii authored
and GB18030. patches from ITAGAKI Takahiro.
-
Tom Lane authored
-
Tom Lane authored
Per report from Jim Rosenberg. This possibly should get back-patched, but I'm a bit suspicious of it still because of the lack of prior reports.
-
Tom Lane authored
table constraints are changed; this is no longer true now that we have a plan invalidation mechanism.
-
Tom Lane authored
reset event, namely invalidate everything. This oversight probably explains the rare failures that some buildfarm machines have been showing for the plancache regression test.
-
- 25 Mar, 2007 4 commits
-
-
Tom Lane authored
if possible. I had left this undone in the first pass at the API change for ProcessUtility, but forgot to revisit it after the plancache changes made it possible to do it.
-
Tom Lane authored
Vadim had included this restriction in the original design of the SPI code, but I'm darned if I can see a reason for it. I left the macro definition of SPI_ERROR_CURSOR in place, so as not to needlessly break any SPI callers that are checking for it, but that code will never actually be returned anymore.
-
Tom Lane authored
pointer" in every Snapshot struct. This allows removal of the case-by-case tests in HeapTupleSatisfiesVisibility, which should make it a bit faster (I didn't try any performance tests though). More importantly, we are no longer violating portable C practices by assuming that small integers are distinct from all pointer values, and HeapTupleSatisfiesDirty no longer has a non-reentrant API involving side-effects on a global variable. There were a couple of places calling HeapTupleSatisfiesXXX routines directly rather than through the HeapTupleSatisfiesVisibility macro. Since these places had to be changed anyway, I chose to make them go through the macro for uniformity. Along the way I renamed HeapTupleSatisfiesSnapshot to HeapTupleSatisfiesMVCC to emphasize that it's only used with MVCC-type snapshots. I was sorely tempted to rename HeapTupleSatisfiesVisibility to HeapTupleSatisfiesSnapshot, but forebore for the moment to avoid confusion and reduce the likelihood that this patch breaks some of the pending patches. Might want to reconsider doing that later.
-
Tatsuo Ishii authored
along with new conversions among EUC_JIS_2004, SHIFT_JIS_2004 and UTF-8. catalog version has been bump up.
-