- 10 10月, 2002 6 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
precision. vacuum.patch updates ref/vacuum.sgml to explicitly state that an exclusive lock is not obtained during normal (non-FULL) vacuum. Rod Taylor
-
由 Bruce Momjian 提交于
Added Tom's patch fix for heap_close. Rod Taylor
-
由 Bruce Momjian 提交于
contrib/contrib-global.mk library and _generally_ behave like Makefiles for other contrib modules. Besides it fixes Perl's interpolation of $libdir variable, which should be passed to backend instead. This patch is done against PostgreSQL 7.3b2 Besides, I want to thank Peter Eisentraut for his very friendly and helpful attitude and politely ask him to check whether contrib modules actually continue to work after he implements another major change to their build process. Alexey Borzov
-
由 Bruce Momjian 提交于
> > > > found in the postmaster and not included from elsewhere) > > > > shared libs on AIX need to be able to resolve all symbols at linkage time. > > Those two symbols are in backend/utils/SUBSYS.o but not in the postgres > > executable. > > They are defined in backend/utils/mb/conv.c and declared in > include/mb/pg_wchar.h. They're also linked into the > postmaster. I don't see anything unusual. Attached is a patch to fix the mb linking problems on AIX. As a nice side effect it reduces the duplicate symbol warnings to linking libpq.so and libecpg.so (all shlibs that are not postmaster loadable modules). Please apply to current (only affects AIX). The _LARGE_FILES problem is unfortunately still open, unless Peter has fixed it per his recent idea. Zeugswetter Andreas SB SD
-
由 Bruce Momjian 提交于
> > I'm looking at pg_dump/common.c:flagInhAttrs() and suspect that it can > > be more or less rewritten completely, and probably should to get rigth > > all the cases mentioned in the past attisinherited discussion. Is this > > desirable for 7.3? It can probably be hacked around and the rewrite > > kept for 7.4, but I think it will be much simpler after the rewrite. > > If it's a bug then it's fair game to fix in 7.3. But keep in mind that > pg_dump has to behave at least somewhat sanely when called against older > servers ... will your rewrite behave reasonably if the server does not > offer attinhcount values? Nah. I don't think it's worth it: I had forgotten that older versions should be supported. I just left the code as is and added a version-specific test. This patch allows pg_dump to dump correctly local definition of columns. In particular, CREATE TABLE p1 (f1 int, f2 int); CREATE TABLE p2 (f1 int); CREATE TABLE c () INHERITS (p1, p2); ALTER TABLE ONLY p1 DROP COLUMN f1; CREATE TABLE p3 (f1 int); CREATE TABLE c2 (f1 int) INHERITS (p3); Will be dumped as CREATE TABLE p1 (f2 int); CREATE TABLE p2 (f1 int); CREATE TABLE c (f1 int) INHERITS (p1, p2); CREATE TABLE c2 (f1 int) INHERITS (p3); (Previous version will dump CREATE TABLE c () INHERITS (p1, p2) CREATE TABLE c2 () INHERITS (p3) ) Alvaro Herrera
-
- 09 10月, 2002 5 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> o Allow SHOW of non-modifiable variables, like pg_controldata
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
into postgres.c; make sure it happens for all cases that seem to need it. Perhaps it would be better to explicitly exclude just a few utility statement types from setting a snapshot?
-
- 08 10月, 2002 2 次提交
-
-
由 Dave Cramer 提交于
-
由 Tom Lane 提交于
in our write/flush operation any WAL entries that got queued while we were waiting to get the WALWriteLock. This improves throughput when transactions are small enough that several can be committed per WAL write (ie, per disk revolution).
-
- 07 10月, 2002 1 次提交
-
-
由 Tatsuo Ishii 提交于
false. per Tom Lane's suggestion. See: Subject: Suggested change to pgbench From: Tom Lane <tgl@sss.pgh.pa.us> To: Tatsuo Ishii <t-ishii@sra.co.jp> Cc: pgsql-patches@postgreSQL.org Date: Sun, 06 Oct 2002 12:37:27 -0400 for more details.
-
- 06 10月, 2002 4 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> * Add now("transaction|statement|clock") functionality
-
由 Bruce Momjian 提交于
Also, code < and > as </> for cleaner SGML.
-
- 05 10月, 2002 7 次提交
-
-
由 Bruce Momjian 提交于
> * Allow sorting, temp files, temp tables to use multiple work directories
-
由 Tom Lane 提交于
ago.
-
由 Tom Lane 提交于
discussion some weeks ago. Also, add a check that two types to be binary-equivalenced match as to typlen, typbyval, and typalign; if they don't then it's surely a mistake to equivalence them.
-
由 Bruce Momjian 提交于
> * Allow sorting/temp files to use multiple work directories
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
> * Allow sorting to use multiple work directories
-
由 Tom Lane 提交于
just the significant fields of FunctionCallInfoData, rather than MemSet'ing the whole struct to zero. Unused positions in the arg[] array will thereby contain garbage rather than zeroes. This buys back some of the performance hit from increasing FUNC_MAX_ARGS. Also tweak tuplesort.c code for more speed by marking some routines 'inline'. All together these changes speed up simple sorts, like count(distinct int4column), by about 25% on a P4 running RH Linux 7.2.
-
- 04 10月, 2002 15 次提交
-
-
由 Bruce Momjian 提交于
> * Add floor(float8) and other missing functions
-
由 Tom Lane 提交于
are missing the FROM clause (due to a long-ago pg_dump bug). Patch by Stephan Szabo, minor tweaking by Tom Lane.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
< * Provide automatic running of vacuum in the background (Tom) > * Provide automatic running of vacuum in the background (Tom) [vacuum]
-
由 Bruce Momjian 提交于
> * Check GUC geqo_threshold to see if it is still accurate
-
由 Tom Lane 提交于
to avoid unnecessary consumption of semaphores.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
test expected output. Tweak contrib/spi Makefile so that refint.so is by default built with appropriate NOTICE support for regression testing.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
/contrib/vacuumlo Mario Weilguni
-
由 Bruce Momjian 提交于
entries, and attributes some JDBC changes to the right people. Neil Conway
-
由 Bruce Momjian 提交于
Teodor Sigaev
-
由 Bruce Momjian 提交于
behavior of connectby() in the presence of infinite recursion. Please apply this one in addition to the one sent earlier. Joe Conway
-
由 Bruce Momjian 提交于
> contrib/tablefunc/tablefunc.c:connectby. But, other unmanageable error > seems to occur even if a table has commonplace tree data(see below). > > I would think the patch, ancestor check, should be > > if (strstr(branch_delim || branchstr->data || branch_delim, > branch_delim || current_key || branch_delim)) > > This is my image, not a real code. However, if branchstr->data includes > branch_delim, my image will not be perfect. Good point. Thank you Masaru for the suggested fix. Attached is a patch to fix the bug found by Masaru. His example now produces: regression=# SELECT * FROM connectby('connectby_tree', 'keyid', 'parent_keyid', '11', 0, '-') AS t(keyid int, parent_keyid int, level int, branch text); keyid | parent_keyid | level | branch -------+--------------+-------+---------- 11 | | 0 | 11 10 | 11 | 1 | 11-10 111 | 11 | 1 | 11-111 1 | 111 | 2 | 11-111-1 (4 rows) While making the patch I also realized that the "no show branch" form of the function was not going to work very well for recursion detection. Therefore there is now a default branch delimiter ('~') that is used internally, for that case, to enable recursion detection to work. If you need a different delimiter for your specific data, you will have to use the "show branch" form of the function. Joe Conway
-
由 Bruce Momjian 提交于
client utilities (libpq.dll and psql.exe) for win32 (missing defines, adjustments to includes, pedantic casting, non-existent functions) per: http://developer.postgresql.org/docs/postgres/install-win32.html. It compiles cleanly under Windows 2000 using Visual Studio .net. Also compiles clean and passes all regression tests (regular and contrib) under Linux. In addition to a review by the usual suspects, it would be very desirable for someone well versed in the peculiarities of win32 to take a look. Joe Conway
-