OSDN Git Service
Tom Lane [Wed, 20 Feb 2008 22:46:24 +0000 (22:46 +0000)]
Rename miscadmin.h's PG_VERSIONSTR macro to PG_BACKEND_VERSIONSTR to
make it a bit clearer what it is, and get rid of duplicate definitions
in initdb and pg_ctl.
Tom Lane [Wed, 20 Feb 2008 22:44:16 +0000 (22:44 +0000)]
Make pg_regress -V consistent with the corresponding code in other
programs: use puts with a compile-time-constant string.
Tom Lane [Wed, 20 Feb 2008 22:18:15 +0000 (22:18 +0000)]
Fix mistakes in pg_ctl's code for "start -w" that tries to cope with
non-default settings for the postmaster's port number. The code to parse
command line options and postgresql.conf entries wasn't quite right about
whitespace or quotes, and it was coded in a not-very-readable way too.
Per bug #3969 from Itagaki Takahiro, though this is more extensive than his
proposed patch (which fixed only the whitespace problem).
This code has been broken since it was put in in 8.0, so patch all the way
back.
Tom Lane [Wed, 20 Feb 2008 17:44:09 +0000 (17:44 +0000)]
Put a CHECK_FOR_INTERRUPTS call into the loops that try to find a unique new
OID or new relfilenode. If the existing OIDs are sufficiently densely
populated, this could take a long time (perhaps even be an infinite loop),
so it seems wise to allow the system to respond to a cancel interrupt here.
Per a gripe from Jacky Leng.
Backpatch as far as 8.1. Older versions just fail on OID collision,
instead of looping.
Alvaro Herrera [Wed, 20 Feb 2008 14:31:35 +0000 (14:31 +0000)]
Improve error messages emitted when VACUUM and ANALYZE skip a table.
Per gripe from Clodoaldo Pinto Neto on
Message-ID: <a595de7a0801060326qbfc790ax2a60573043c2e2be@mail.gmail.com>
Alvaro Herrera [Wed, 20 Feb 2008 14:01:45 +0000 (14:01 +0000)]
Change error message to be able to differentiate the two cases. Per suggestion
from Jaime Casanova.
Peter Eisentraut [Tue, 19 Feb 2008 18:02:30 +0000 (18:02 +0000)]
Backport fixed AC_FUNC_FSEEKO
Magnus Hagander [Tue, 19 Feb 2008 16:15:14 +0000 (16:15 +0000)]
Un-break msvc port yet again (it started pulling in the Darwin
port files, which obviously didn't compile)
Peter Eisentraut [Tue, 19 Feb 2008 15:29:58 +0000 (15:29 +0000)]
More refactoring, so that the SUBSYS.o rules are now all in one place.
Peter Eisentraut [Tue, 19 Feb 2008 13:08:56 +0000 (13:08 +0000)]
This subdirectory has been unused, dead, and broken for 10 years.
Magnus Hagander [Tue, 19 Feb 2008 12:06:35 +0000 (12:06 +0000)]
Fix function prototype to silence compiler warnings.
Magnus Hagander [Tue, 19 Feb 2008 12:00:03 +0000 (12:00 +0000)]
Unbreak MSVC build after recent addition of HTMLDIR.
Peter Eisentraut [Tue, 19 Feb 2008 11:49:12 +0000 (11:49 +0000)]
Remove another target I forgot during the refactoring
Peter Eisentraut [Tue, 19 Feb 2008 10:30:09 +0000 (10:30 +0000)]
Refactor backend makefiles to remove lots of duplicate code
Bruce Momjian [Tue, 19 Feb 2008 01:05:28 +0000 (01:05 +0000)]
Put back code modularization of fseeko() configure checks.
Bruce Momjian [Tue, 19 Feb 2008 00:46:43 +0000 (00:46 +0000)]
Put fseeko check back in old location, in hopes of silencing build warnings.
Tom Lane [Mon, 18 Feb 2008 23:00:32 +0000 (23:00 +0000)]
Remove unnecessary opening of other relation in RI_FKey_keyequal_upd_pk
and RI_FKey_keyequal_upd_fk, as well as no-longer-needed calls of
ri_BuildQueryKeyFull. Aside from saving a few cycles, this avoids needless
deadlock risks when an update is not changing the columns that participate
in an RI constraint. Per a gripe from Alexey Nalbat.
Back-patch to 8.3. Earlier releases did have a need to open the other
relation due to the way in which they retrieved information about the RI
constraint, so this problem unfortunately can't easily be improved pre-8.3.
Tom Lane and Stephan Szabo
Bruce Momjian [Mon, 18 Feb 2008 21:46:22 +0000 (21:46 +0000)]
autoconf 2.61's AC_FUNC_FSEEKO reports success/failure differently, so
reorganize code for NetBSD/BSDi port/fseeko.c usage, and make code more
modular.
Peter Eisentraut [Mon, 18 Feb 2008 16:04:32 +0000 (16:04 +0000)]
Observe errors in makefile
Peter Eisentraut [Mon, 18 Feb 2008 14:51:48 +0000 (14:51 +0000)]
Added --htmldir option to pg_config, equivalent to the new configure option.
Michael Meskes [Sun, 17 Feb 2008 18:14:29 +0000 (18:14 +0000)]
- Removed duplicate include of ecpgtype.h which meant I had to adapt all expected results.
- Changed INFORMIX mode symbol definition yet again because the old way didn't work on NetBSD. Hopefully this one does.
Peter Eisentraut [Sun, 17 Feb 2008 16:36:43 +0000 (16:36 +0000)]
Upgrade to Autoconf 2.61:
- Change configure.in to use Autoconf 2.61 and update generated files.
- Update build system and documentation to support now directory variables
offered by Autoconf 2.61.
- Replace usages of PGAC_CHECK_ALIGNOF by AC_CHECK_ALIGNOF, now available
in Autoconf 2.61.
- Drop our patched version of AC_C_INLINE, as Autoconf now has the change.
Tom Lane [Sun, 17 Feb 2008 04:21:05 +0000 (04:21 +0000)]
Add back #include <time.h> in a couple of files that seem to need it
on Linux.
Tom Lane [Sun, 17 Feb 2008 02:09:32 +0000 (02:09 +0000)]
Replace time_t with pg_time_t (same values, but always int64) in on-disk
data structures and backend internal APIs. This solves problems we've seen
recently with inconsistent layout of pg_control between machines that have
32-bit time_t and those that have already migrated to 64-bit time_t. Also,
we can get out from under the problem that Windows' Unix-API emulation is not
consistent about the width of time_t.
There are a few remaining places where local time_t variables are used to hold
the current or recent result of time(NULL). I didn't bother changing these
since they do not affect any cross-module APIs and surely all platforms will
have 64-bit time_t before overflow becomes an actual risk. time_t should
be avoided for anything visible to extension modules, however.
Bruce Momjian [Sat, 16 Feb 2008 23:27:34 +0000 (23:27 +0000)]
Move item as done:
<
> * -Allow AS in "SELECT col AS label" to be optional in certain cases
>
< * Allow AS in "SELECT col AS label" to be optional (not wanted)
Tom Lane [Sat, 16 Feb 2008 21:51:04 +0000 (21:51 +0000)]
Update docs to reflect the fact that we can now deal with DST rules
outside the 32-bit-time_t range. Also, refer to Olson's tz database
as the 'zoneinfo' database, a name that upstream sometimes uses, not
'zic database' which they never use.
Tom Lane [Sat, 16 Feb 2008 21:16:04 +0000 (21:16 +0000)]
Update timezone code to track the upstream changes since 2003. In particular
this adds support for 64-bit tzdata files, which is needed to support DST
calculations beyond 2038. Add a regression test case to give some minimal
confidence that that really works.
Heikki Linnakangas
Bruce Momjian [Sat, 16 Feb 2008 21:14:08 +0000 (21:14 +0000)]
No need to use checkpoint_warning to log checkpoints --- we added
log_checkpoints in 8.3.
Bruce Momjian [Sat, 16 Feb 2008 21:11:32 +0000 (21:11 +0000)]
Add suggestion about how to set checkpoint_warning to log all
checkpoints.
Bruce Momjian [Sat, 16 Feb 2008 21:03:30 +0000 (21:03 +0000)]
Rename a libpq NOT_USED SSL function to
verify_peer_name_matches_certificate(), clarify some of the function's
variables and logic, and update a comment. This should make SSL
improvements easier in the future.
Tom Lane [Fri, 15 Feb 2008 22:17:06 +0000 (22:17 +0000)]
Allow AS to be omitted when specifying an output column name in SELECT
(or RETURNING), but only when the output name is not any SQL keyword.
This seems as close as we can get to the standard's syntax without a
great deal of thrashing. Original patch by Hiroshi Saito, amended by me.
Tom Lane [Fri, 15 Feb 2008 17:19:46 +0000 (17:19 +0000)]
Remove ancient restriction that LIMIT/OFFSET can't contain a sub-select.
This was probably protecting some implementation limitation when it was
put in, but as far as I can tell the planner and executor have no such
assumption anymore; the case seems to work fine. Per a gripe from
Grzegorz Jaskiewicz.
Michael Meskes [Fri, 15 Feb 2008 11:20:21 +0000 (11:20 +0000)]
Changed the way symbols are defined in C in INFORMIX mode.
Tom Lane [Thu, 14 Feb 2008 17:33:37 +0000 (17:33 +0000)]
Sync our regex code with upstream changes since last time we did this, which
was Tcl 8.4.8. The main changes are to remove the never-fully-implemented
code for multi-character collating elements, and to const-ify some stuff a
bit more fully. In combination with the recent security patch, this commit
brings us into line with Tcl 8.5.0.
Note that I didn't make any effort to duplicate a lot of cosmetic changes
that they made to bring their copy into line with their own style
guidelines, such as adding braces around single-line IF bodies. Most of
those we either had done already (such as ANSI-fication of function headers)
or there is no point because pgindent would undo the change anyway.
Michael Meskes [Thu, 14 Feb 2008 14:54:48 +0000 (14:54 +0000)]
- EXECUTE can return NOT FOUND so it should be checked here too.
- Changed regression test accordingly.
Michael Meskes [Thu, 14 Feb 2008 12:27:26 +0000 (12:27 +0000)]
Sorry, accidently committed a patch I'm working on. Reverting it.
The only correct change was:
- Added SQLSTATE macro closing bug #3961.
Michael Meskes [Thu, 14 Feb 2008 12:22:36 +0000 (12:22 +0000)]
*** empty log message ***
Bruce Momjian [Wed, 13 Feb 2008 22:46:55 +0000 (22:46 +0000)]
Correct XML markup typo, <book> -> </book>
XMLPARSE (DOCUMENT '<?xml
version="1.0"?><book><title>Manual</title><chapter>...</chapter></book>')
Backpatch to 8.3.X.
Bruce Momjian [Wed, 13 Feb 2008 22:44:06 +0000 (22:44 +0000)]
Add section to Migration talking about typical areas that change between
major releases.
Alvaro Herrera [Wed, 13 Feb 2008 21:09:24 +0000 (21:09 +0000)]
Update minor version bumping policy.
Bruce Momjian [Wed, 13 Feb 2008 18:30:21 +0000 (18:30 +0000)]
As sub-bullet decoration.
Bruce Momjian [Wed, 13 Feb 2008 18:29:08 +0000 (18:29 +0000)]
Update wording for minor library bumping.
Bruce Momjian [Wed, 13 Feb 2008 18:14:46 +0000 (18:14 +0000)]
Bump minor library version numbers for 8.4.
Bruce Momjian [Wed, 13 Feb 2008 18:10:23 +0000 (18:10 +0000)]
No longer necessary:
o update ecpg regression expected files for new library number
Tom Lane [Wed, 13 Feb 2008 03:40:38 +0000 (03:40 +0000)]
Stamp HEAD as 8.4devel.
Tom Lane [Tue, 12 Feb 2008 04:09:44 +0000 (04:09 +0000)]
Fix SPI_cursor_open() and SPI_is_cursor_plan() to push the SPI stack before
doing anything interesting, such as calling RevalidateCachedPlan(). The
necessity of this is demonstrated by an example from Willem Buitendyk:
during a replan, the planner might try to evaluate SPI-using functions,
and so we'd better be in a clean SPI context.
A small downside of this fix is that these two functions will now fail
outright if called when not inside a SPI-using procedure (ie, a
SPI_connect/SPI_finish pair). The documentation never promised or suggested
that that would work, though; and they are normally used in concert with
other functions, mainly SPI_prepare, that always have failed in such a case.
So the odds of breaking something seem pretty low.
In passing, make SPI_is_cursor_plan's error handling convention clearer,
and fix documentation's erroneous claim that SPI_cursor_open would
return NULL on error.
Before 8.3 these functions could not invoke replanning, so there is probably
no need for back-patching.
Magnus Hagander [Mon, 11 Feb 2008 19:55:11 +0000 (19:55 +0000)]
Update timezone mapping for Windows with new timezones added
in windows servicepacks.
Fix timezone mapping for "Mexico 2"
Tom Lane [Mon, 11 Feb 2008 19:14:30 +0000 (19:14 +0000)]
Repair VACUUM FULL bug introduced by HOT patch: the original way of
calculating a page's initial free space was fine, and should not have been
"improved" by letting PageGetHeapFreeSpace do it. VACUUM FULL is going to
reclaim LP_DEAD line pointers later, so there is no need for a guard
against the page being too full of line pointers, and having one risks
rejecting pages that are perfectly good move destinations.
This also exposed a second bug, which is that the empty_end_pages logic
assumed that any page with no live tuples would get entered into the
fraged_pages list automatically (by virtue of having more free space than
the threshold in the do_frag calculation). This assumption certainly
seems risky when a low fillfactor has been chosen, and even without
tunable fillfactor I think it could conceivably fail on a page with many
unused line pointers. So fix the code to force do_frag true when notup
is true, and patch this part of the fix all the way back.
Per report from Tomas Szepe.
Tom Lane [Sun, 10 Feb 2008 20:39:08 +0000 (20:39 +0000)]
Fix PageGetExactFreeSpace() so that it actually behaves sensibly
if pd_lower > pd_upper, rather than merely claiming to. This would
only matter if the page header were corrupt, which shouldn't occur,
but ...
Tom Lane [Fri, 8 Feb 2008 18:18:05 +0000 (18:18 +0000)]
Some small editorialization on the protocol documentation for GSSAPI/SSPI
authentication.
Tom Lane [Fri, 8 Feb 2008 17:58:46 +0000 (17:58 +0000)]
Since GSSAPI and SSPI authentication don't work in protocol version 2,
issue a helpful error message instead of sending unparsable garbage.
(It is clearly a design error that this doesn't work, but fixing it
is not worth the trouble at this point.) Per discussion.
Tom Lane [Thu, 7 Feb 2008 22:58:35 +0000 (22:58 +0000)]
Avoid misbehavior in foreign key checks when casting to a datatype for which
the parser supplies a default typmod that can result in data loss (ie,
truncation). Currently that appears to be only CHARACTER and BIT.
We can avoid the problem by specifying the type's internal name instead
of using SQL-spec syntax. Since the queries generated here are only used
internally, there's no need to worry about portability. This problem is
new in 8.3; before we just let the parser do whatever it wanted to resolve
the operator, but 8.3 is trying to be sure that the semantics of FK checks
are consistent. Per report from Harald Fuchs.
Bruce Momjian [Thu, 7 Feb 2008 22:28:54 +0000 (22:28 +0000)]
Add "automatically" to HOT release note description.
Tom Lane [Thu, 7 Feb 2008 21:07:55 +0000 (21:07 +0000)]
Some variants of ALTER OWNER tried to make the "object" field of the
statement be a list of bare C strings, rather than String nodes, which is
what they need to be for copyfuncs/equalfuncs to work. Fortunately these
node types never go out to disk (if they did, we'd likely have noticed the
problem sooner), so we can just fix it without creating a need for initdb.
This bug has been there since 8.0, but 8.3 exposes it in a more common
code path (Parse messages) than prior releases did. Per bug #3940 from
Vladimir Kokovic.
Tom Lane [Thu, 7 Feb 2008 20:19:47 +0000 (20:19 +0000)]
Add missing copyfuncs/equalfuncs support for AlterTSDictionaryStmt and
AlterTSConfigurationStmt. All utility statement node types are expected
to be supported here, though they do not have to have outfuncs/readfuncs
support. Found by running regression tests with COPY_PARSE_PLAN_TREES
enabled.
Magnus Hagander [Thu, 7 Feb 2008 17:58:16 +0000 (17:58 +0000)]
Fix msvc install for cases where msgfmt (from gettext) is in a directory
that contains spaces.
Per complaint from Gevik Babakhani, like the last one.
Tom Lane [Thu, 7 Feb 2008 17:53:53 +0000 (17:53 +0000)]
Fix silly mistake in expand_indexqual_rowcompare --- in converting a forboth()
into an iteration over three parallel lists, I had accidentally put the lnext
steps outside the loop. Sigh. Per bug #3938.
Tom Lane [Thu, 7 Feb 2008 17:09:51 +0000 (17:09 +0000)]
Fix CREATE TABLE ... LIKE ... INCLUDING INDEXES to not cause unwanted
tablespace permissions failures when copying an index that is in the
database's default tablespace. A side-effect of the change is that explicitly
specifying the default tablespace no longer triggers a permissions check;
this is not how it was done in pre-8.3 releases but is argued to be more
consistent. Per bug #3921 from Andrew Gilligan. (Note: I argued in the
subsequent discussion that maybe LIKE shouldn't copy index tablespaces
at all, but since no one indicated agreement with that idea, I've refrained
from doing it.)
Magnus Hagander [Thu, 7 Feb 2008 13:49:00 +0000 (13:49 +0000)]
Fix msvc install script to properly install NLS files when built with
gettext.
Michael Meskes [Thu, 7 Feb 2008 11:09:13 +0000 (11:09 +0000)]
- Fixed segfault in ecpg when using an array element.
- Free all memory in auto-prepare mode.
Magnus Hagander [Wed, 6 Feb 2008 15:13:25 +0000 (15:13 +0000)]
Fix very broken clean.bat for msvc install. The way we used subroutines
in .bat simply did not work, and it called them in the wrong order,
some several times, and some not at all. So this unrolls all subroutine
calls.
This should fix the issues with clean deleting the wrong files reported
by Dave Page.
While at it, add the "clean dist" option to act like "make distclean",
and no longer remove the flex/bison output files by default. This shuold
fix the problem reported by Pavel Golub in bug #3909.
Magnus Hagander [Tue, 5 Feb 2008 14:17:23 +0000 (14:17 +0000)]
Handle libraries in directories with spaces in them.
Gevik Babakhani
Tom Lane [Sun, 3 Feb 2008 16:24:08 +0000 (16:24 +0000)]
Fix mistaken duplicate reference to max_fsm_pages, per bug #3926.
Also make links clickable.
Tom Lane [Sat, 2 Feb 2008 23:30:23 +0000 (23:30 +0000)]
Minor wordsmithing in release notes' description of asynchronous commit.
Tom Lane [Sat, 2 Feb 2008 23:29:12 +0000 (23:29 +0000)]
Move example of turning off synchronous_commit to a more logical place,
to wit in the description of that variable rather than some other one.
Tom Lane [Sat, 2 Feb 2008 22:26:17 +0000 (22:26 +0000)]
Fix WaitOnLock() to ensure that the process's "waiting" flag is reset after
erroring out of a wait. We can use a PG_TRY block for this, but add a comment
explaining why it'd be a bad idea to use it for any other state cleanup.
Back-patch to 8.2. Prior releases had the same issue, but only with respect
to the process title, which is likely to get reset almost immediately anyway
after the transaction aborts, so it seems not worth changing them. In 8.2
and HEAD, the pg_stat_activity "waiting" flag could remain set incorrectly
for a long time.
Per report from Gurjeet Singh.
Marc G. Fournier [Fri, 1 Feb 2008 04:16:29 +0000 (04:16 +0000)]
configure tag'd 8.3.0 and built witih autoconf 2.59
Bruce Momjian [Fri, 1 Feb 2008 02:59:02 +0000 (02:59 +0000)]
Stamp 8.3 in CVS. _No_ update of configure/configure.in.
Bruce Momjian [Fri, 1 Feb 2008 02:55:41 +0000 (02:55 +0000)]
Update FAQ for most recent release as 8.3.
Bruce Momjian [Fri, 1 Feb 2008 02:41:10 +0000 (02:41 +0000)]
Update item:
< * Improve deadlock detection when deleting items from shared buffers
> * Improve deadlock detection when a page cleaning lock conflicts
> with a shared buffer that is pinned
Bruce Momjian [Thu, 31 Jan 2008 23:31:33 +0000 (23:31 +0000)]
Fix spelling typo in comment.
Bruce Momjian [Thu, 31 Jan 2008 23:30:31 +0000 (23:30 +0000)]
Add comment about possible URL changes for www7.hp.com:
<!-- If this URL chnages replace it with a URL to www.archive.org. -->
Bruce Momjian [Thu, 31 Jan 2008 23:03:16 +0000 (23:03 +0000)]
Update spoofing /tmp symlink instructions to be more specific about the
name of the needed symlink file.
Tom Lane [Thu, 31 Jan 2008 21:31:33 +0000 (21:31 +0000)]
Mention synchronize_seqscans GUC variable in release notes.
Update expected release date.
Tom Lane [Thu, 31 Jan 2008 20:29:30 +0000 (20:29 +0000)]
Remove the old table of "supported platforms" in favor of a link to the
buildfarm plus a narrative description of the CPU types and operating systems
on which Postgres is likely to work. Now that we've almost completely
decoupled CPU and OS considerations, the former tabular style isn't all that
enlightening anyway. Perhaps more importantly, no one seems particularly
interested in maintaining the table by hand when we have the buildfarm.
Tom Lane [Thu, 31 Jan 2008 18:58:30 +0000 (18:58 +0000)]
Fix pg_GSS_error to use conn->errorMessage more sanely, ie, actually
work with the PQExpBuffer code instead of fighting it. This avoids an
unnecessary limit on message length and fixes the latent bug that
errorMessage.len wasn't getting set.
Tom Lane [Thu, 31 Jan 2008 18:40:02 +0000 (18:40 +0000)]
Improve pg_autovacuum documentation to clarify that the enabled field cannot
prevent anti-wraparound vacuuming, and to caution against setting unreasonably
small values of freeze_max_age. Also put in a notice that this catalog is
likely to disappear entirely in some future release. Per discussion of
bug #3898 from Steven Flatt.
Peter Eisentraut [Thu, 31 Jan 2008 18:04:52 +0000 (18:04 +0000)]
Translation updates
Bruce Momjian [Thu, 31 Jan 2008 17:22:43 +0000 (17:22 +0000)]
Document the idea of creating a symbolic link in /tmp to prevent server
spoofing when the socket file has been moved.
Andrew Dunstan [Thu, 31 Jan 2008 16:30:24 +0000 (16:30 +0000)]
Remove 3 hex digit limit on symbol number in recent fix.
Bruce Momjian [Thu, 31 Jan 2008 15:05:09 +0000 (15:05 +0000)]
Add:
> * Improve deadlock detection when deleting items from shared buffers
>
> http://archives.postgresql.org/pgsql-bugs/2008-01/msg00138.php
> http://archives.postgresql.org/pgsql-hackers/2008-01/msg00873.php
> http://archives.postgresql.org/pgsql-committers/2008-01/msg00365.php
Magnus Hagander [Thu, 31 Jan 2008 09:21:17 +0000 (09:21 +0000)]
Add pid to the pgident event name on win32.
Should fix a problem where two clusters are running under
two different service accounts and get colliding names,
causing only the first cluster to contain the pgident
event description.
Per report from Stephen Denne.
Andrew Dunstan [Thu, 31 Jan 2008 03:26:14 +0000 (03:26 +0000)]
Fix test that wrongly excluded some dumpbin symbols.
Keep the intermediate symbol file rather then blowing it away, for easier debugging.
Tom Lane [Wed, 30 Jan 2008 19:46:48 +0000 (19:46 +0000)]
Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent performing these
operations when the current transaction has any open references to the
target relation or index (implying it has an active query using the relation).
The need for this was previously recognized in connection with ALTER TABLE,
but anything that summarily eliminates tuples or moves them around would
confuse an active scan.
While this patch does not in itself fix bug #3883 (the deadlock would happen
before the new check fires), it will discourage people from attempting the
sequence of operations that creates a deadlock risk, so it's at least a
partial response to that problem.
In passing, add a previously-missing check to REINDEX to prevent trying to
reindex another backend's temp table. This isn't a security problem since
only a superuser would get past the schema permission checks, but if we are
testing for this in other utility commands then surely REINDEX should too.
Tom Lane [Wed, 30 Jan 2008 18:35:55 +0000 (18:35 +0000)]
Add a GUC variable "synchronize_seqscans" to allow clients to disable the new
synchronized-scanning behavior, and make pg_dump disable sync scans so that
it will reliably preserve row ordering. Per recent discussions.
Peter Eisentraut [Wed, 30 Jan 2008 11:05:41 +0000 (11:05 +0000)]
Translation updates
Peter Eisentraut [Wed, 30 Jan 2008 10:49:55 +0000 (10:49 +0000)]
Improve table reference
Peter Eisentraut [Wed, 30 Jan 2008 10:37:36 +0000 (10:37 +0000)]
Update key words table for 8.3
Tom Lane [Wed, 30 Jan 2008 04:11:19 +0000 (04:11 +0000)]
Don't putenv() a string that is allocated in a context that will go away
soon. I suspect this explains bug #3902, though I'm still not able to
reproduce that.
Bruce Momjian [Tue, 29 Jan 2008 16:13:09 +0000 (16:13 +0000)]
Update wording:
< * Add anonymous transactions
> * Add autonomous transactions
Bruce Momjian [Tue, 29 Jan 2008 16:11:19 +0000 (16:11 +0000)]
Add item:
> * Add anonymous transactions
>
> http://archives.postgresql.org/pgsql-hackers/2008-01/msg00893.php
>
Bruce Momjian [Tue, 29 Jan 2008 16:09:28 +0000 (16:09 +0000)]
Remove duplicat item:
< o Allow the PITR process to be debugged and data examined
Peter Eisentraut [Tue, 29 Jan 2008 13:03:50 +0000 (13:03 +0000)]
markup correct
from Gevik Babakhani
Tom Lane [Tue, 29 Jan 2008 02:06:30 +0000 (02:06 +0000)]
Fix up closePGconn() so that PQreset() will work on GSSAPI/SSPI connections;
the patch for those features put its cleanup code into freePGconn() which is
really the wrong place. Remove redundant code from freePGconn() and add
comments in hopes of preventing similar mistakes in future.
Noticed while trying (futilely) to reproduce bug #3902.
Tom Lane [Tue, 29 Jan 2008 02:03:39 +0000 (02:03 +0000)]
Arrange to ignore SIGPIPE during SSL_read() and SSL_shutdown(), as these
are known to write on the socket sometimes and thus we are vulnerable to
being killed by the signal if the server happens to go away unexpectedly.
Noticed while trying (futilely) to reproduce bug #3902.
This bug has been there all along, but since the situation is usually
only of interest to developers, I chose not to back-patch the changes.
Bruce Momjian [Mon, 28 Jan 2008 18:43:55 +0000 (18:43 +0000)]
Add "Communication Method" row to HA feature matrix documentation.
Tom Lane [Sun, 27 Jan 2008 19:12:28 +0000 (19:12 +0000)]
Minor editorial improvements in documentation of session_replication_role;
in particular correct the obsolete claim that it can't be changed once
any plans have been cached.
Tom Lane [Sat, 26 Jan 2008 19:55:08 +0000 (19:55 +0000)]
Change StatementCancelHandler() to check the DoingCommandRead flag to decide
whether to execute an immediate interrupt, rather than testing whether
LockWaitCancel() cancelled a lock wait. The old way misclassified the case
where we were blocked in ProcWaitForSignal(), and arguably would misclassify
any other future additions of new ImmediateInterruptOK states too. This
allows reverting the old kluge that gave LockWaitCancel() a return value,
since no callers care anymore. Improve comments in the various
implementations of PGSemaphoreLock() to explain that on some platforms, the
assumption that semop() exits after a signal is wrong, and so we must ensure
that the signal handler itself throws elog if we want cancel or die interrupts
to be effective. Per testing related to bug #3883, though this patch doesn't
solve those problems fully.
Perhaps this change should be back-patched, but since pre-8.3 branches aren't
really relying on autovacuum to respond to SIGINT, it doesn't seem critical
for them.
Tom Lane [Fri, 25 Jan 2008 20:42:10 +0000 (20:42 +0000)]
Fix two different copy-and-paste-os in CSV log rotation logic; one that led to
a double-pfree crash and another that effectively disabled size-based rotation
for CSV logs. Also suppress a memory leak and make some trivial cosmetic
improvements. Per bug #3901 from Chris Hoover and additional code-reading.
Andrew Dunstan [Fri, 25 Jan 2008 15:28:35 +0000 (15:28 +0000)]
Fix example of de-escaping bytea argument, per Florian Weimer. Also fix example
of escaping bytea return value. Both cases did not handle backslash values properly.