summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2010-07-18Fix up poor handling of unsupported-platform case in requirepeer patch.Tom Lane
2010-07-18Fix thinko in recent patch: 'sock' should be 'conn->sock'.Tom Lane
2010-07-18Add SO_PEERCRED check in new unix domain socket permission checking code.Bruce Momjian
2010-07-18Add server authentication over Unix-domain socketsPeter Eisentraut
This adds a libpq connection parameter requirepeer that specifies the user name that the server process is expected to run under. reviewed by KaiGai Kohei
2010-07-18Simplify missing tablespace replay error hint message, but only in HEADBruce Momjian
so we don't need to re-translate for 9.0.
2010-07-16Add a log_file_mode GUC that allows control of the file permissions set onTom Lane
log files created by the syslogger process. In passing, make unix_file_permissions display its value in octal, same as log_file_mode now does. Martin Pihlak
2010-07-16Fix typo spotted by Thom Brown.Heikki Linnakangas
2010-07-16Add a paragraph explaining what restartpoints are. Mention thatHeikki Linnakangas
wal_keep_segments does not take effect during recovery. Fujii Masao
2010-07-16Add support for dividing money by money (yielding a float8 result) and forTom Lane
casting between money and numeric. Andy Balholm, reviewed by Kevin Grittner
2010-07-16Remove a sanity check in the exclusion-constraint code that prevented usersTom Lane
from defining non-self-conflicting constraints. Jeff Davis Note: I (tgl) objected to removing this check in 9.0 on the grounds that it was an important sanity check in new, poorly tested code. However, it should be all right to remove it for 9.1, since we'll get field testing from the 9.0 branch.
2010-07-16Remove duplicate code in DefineOpFamily().Tom Lane
The code was probably meant to be this way all along, since the subroutine CreateOpFamily previously had only one caller. But it wasn't. KaiGai Kohei
2010-07-14Use an <xref> for restore_command reference. Marko TiikkajaTom Lane
2010-07-14Fix several problems in pg_dump's handling of SQL/MED objects, notably failureTom Lane
to dump a PUBLIC user mapping correctly, as per bug #5560 from Shigeru Hanada. Use the pg_user_mappings view rather than trying to access pg_user_mapping directly, so that the code doesn't fail when run by a non-superuser. And clean up some minor carelessness such as unsafe usage of fmtId(). Back-patch to 8.4 where this code was added.
2010-07-14Allow full SSL certificate verification (wherein libpq checks its host nameTom Lane
parameter against server cert's CN field) to succeed in the case where both host and hostaddr are specified. As with the existing precedents for Kerberos, GSSAPI, SSPI, it is the calling application's responsibility that host and hostaddr match up --- we just use the host name as given. Per bug #5559 from Christopher Head. In passing, make the error handling and messages for the no-host-name-given failure more consistent among these four cases, and correct a lie in the documentation: we don't attempt to reverse-lookup host from hostaddr if host is missing. Back-patch to 8.4 where SSL cert verification was introduced.
2010-07-13Teach EXPLAIN to print PARAM_EXEC Params as the referenced expressions,Tom Lane
rather than just $N. This brings the display of nestloop-inner-indexscan plans back to where it's been, and incidentally improves the display of SubPlan parameters as well. In passing, simplify the EXPLAIN code by having it deal primarily in the PlanState tree rather than separately searching Plan and PlanState trees. This is noticeably cleaner for subplans, and about a wash elsewhere. One small difference from previous behavior is that EXPLAIN will no longer qualify local variable references in inner-indexscan plan nodes, since it no longer sees such nodes as possibly referencing multiple tables. Vars referenced through PARAM_EXEC Params are still forcibly qualified, though, so I don't think the display is any more confusing than before. Adjust a couple of examples in the documentation to match this behavior.
2010-07-13On Win32, pg_upgrade cannot sent any server log output to the log fileBruce Momjian
because of file access limitations on that platform.
2010-07-13Remove incorrect email address for pg_upgrade bug reports.Bruce Momjian
2010-07-13In pg_upgrade, report /bin directory checks independent of /data checks.Bruce Momjian
2010-07-13Print each test_fsync description while test is running, rather than atBruce Momjian
the end.
2010-07-13In pg_upgrade, prevent psql AUTOCOMMIT=off by not loading .psqlrc.Bruce Momjian
2010-07-13Oops, in the previous fix to prevent a cursor that's being used in a FORHeikki Linnakangas
loop from being dropped, I missed subtransaction cleanup. Pinned portals must be dropped at subtransaction cleanup just as they are at main transaction cleanup. Per bug #5556 by Robert Walker. Backpatch to 8.0, 7.4 didn't have subtransactions.
2010-07-12Restore pl/pgsql default install release note item.Bruce Momjian
2010-07-129.0 release note improvementsBruce Momjian
Erik Rijkers
2010-07-12Spellcheck 9.0 release notes.Bruce Momjian
2010-07-12Make NestLoop plan nodes pass outer-relation variables into their innerTom Lane
relation using the general PARAM_EXEC executor parameter mechanism, rather than the ad-hoc kluge of passing the outer tuple down through ExecReScan. The previous method was hard to understand and could never be extended to handle parameters coming from multiple join levels. This patch doesn't change the set of possible plans nor have any significant performance effect, but it's necessary infrastructure for future generalization of the concept of an inner indexscan plan. ExecReScan's second parameter is now unused, so it's removed.
2010-07-12Document bump of minor library version numbers.Bruce Momjian
2010-07-12Bump minor library version numbers, for 9.1 release.Bruce Momjian
2010-07-10Add a note about preferred window width to the section about codeTom Lane
formatting conventions.
2010-07-10Clarify that "psql -c" ignores psqlrc files.Robert Haas
Tim Landscheidt
2010-07-09Avoid an Assert failure in deconstruct_array() by making get_attstatsslot()Tom Lane
use the actual element type of the array it's disassembling, rather than trusting the type OID passed in by its caller. This is needed because sometimes the planner passes in a type OID that's only binary-compatible with the target column's type, rather than being an exact match. Per an example from Bernd Helmle. Possibly we should refactor get_attstatsslot/free_attstatsslot to not expect the caller to supply type ID data at all, but for now I'll just do the minimum-change fix. Back-patch to 7.4. Bernd's test case only crashes back to 8.0, but since these subroutines are the same in 7.4, I suspect there may be variant cases that would crash 7.4 as well.
2010-07-09Fix ruleutils' get_variable() to print something useful for Vars referencingTom Lane
resjunk outputs of subquery tlists, instead of throwing an error. Per bug #5548 from Daniel Grace. We might at some point find we ought to back-patch this further than 9.0, but I think that such Vars can only occur as resjunk members of upper-level tlists, in which case the problem can't arise because prior versions didn't print resjunk tlist items in EXPLAIN VERBOSE.
2010-07-09Properly report errno/out-of-disk-space error from pg_upgrade when inBruce Momjian
copy mode, per report from depstein@alliedtesting.com. Patch suggestion from Magnus. Backpatch to 9.0.X.
2010-07-09Add a hook in ExecCheckRTPerms().Robert Haas
This hook allows a loadable module to gain control when table permissions are checked. It is expected to be used by an eventual SE-PostgreSQL implementation, but there are other possible applications as well. A sample contrib module can be found in the archives at: http://archives.postgresql.org/pgsql-hackers/2010-05/msg01095.php Robert Haas and Stephen Frost
2010-07-09Stamp HEAD as 9.1devel.Tom Lane
(And there was much rejoicing.)
2010-07-09tag beta3REL9_0_BETA3Marc G. Fournier
2010-07-08Update release notes for 9.0 beta 3.Bruce Momjian
2010-07-08Some small changes for plperl.sgml:Peter Eisentraut
- wrapped long code-lines, for pdf - typo Erik Rijkers
2010-07-08Translation updates for 9.0beta3Peter Eisentraut
2010-07-08Minor kibitzing on previous patch: no need to run check more than once.Tom Lane
(_PG_init should be called only once anyway, but as long as it's got an internal guard against repeat calls, that should be in front of the version check.)
2010-07-08Install safeguard against running PL/Python 2 and 3 in the same sessionPeter Eisentraut
2010-07-08Doc change: effected -> affected, per correction from Matthew WakelingBruce Momjian
2010-07-08Add a cross-reference to precedence information to CREATE OPERATOR'sTom Lane
documentation. Per suggestion from Marc Cousin.
2010-07-08Make the Windows tcp keepalive support depend on the existance of theMagnus Hagander
SIO_KEEPALIVE_VALS define instead of just WIN32, since MingW doesn't support this API (yet?).
2010-07-08Update obsolete comment. Noted by Josh Tolley.Tom Lane
2010-07-08Fix variant float8 expected files to have exactly the expected spacing.Tom Lane
This wasn't important when we used diff's -w (--ignore-all-space) option to compare regression result files, but it is now. Per buildfarm member canary, which evidently has been offline since we did that in November, but came to life again today.
2010-07-08Add support for TCP keepalives on Windows, both for backend and the newMagnus Hagander
libpq support.
2010-07-08Fix "cannot handle unplanned sub-select" error that can occur when aTom Lane
sub-select contains a join alias reference that expands into an expression containing another sub-select. Per yesterday's report from Merlin Moncure and subsequent off-list investigation. Back-patch to 7.4. Older versions didn't attempt to flatten sub-selects in ways that would trigger this problem.
2010-07-07Adjust mbutils.c so it won't get broken by future pgindent runs.Tom Lane
To do that, replace L'\0' by (WCHAR) 0. Perhaps someday we should teach pgindent about wide-character literals, but so long as this is the only use-case in the entire Postgres sources, a workaround seems easier.
2010-07-07Document the interaction of write-barrier-enabled file systems, and BBUBruce Momjian
caches, per June email thread.
2010-07-06Make log_temp_files based on kB, and revert docs & comments to match.Robert Haas
Per extensive discussion on pgsql-hackers. We are deliberately not back-patching this even though the behavior of 8.3 and 8.4 is unquestionably broken, for fear of breaking existing users of this parameter. This incompatibility should be release-noted.