- 28 Jul, 2010 4 commits
-
-
Tom Lane authored
list in ExecLockRows() forgot to allow for the possibility that some of the rowmarks are for child tables that aren't relevant to the current row. Per report from Kenichiro Tanaka.
-
Simon Riggs authored
Avoid hard-coding lockmode used for many altering DDL commands, allowing easier future changes of lock levels. Implementation of initial analysis on DDL sub-commands, so that many lock levels are now at ShareUpdateExclusiveLock or ShareRowExclusiveLock, allowing certain DDL not to block reads/writes. First of number of planned changes in this area; additional docs required when full project complete.
-
Tom Lane authored
a pass-by-reference datatype with a nontrivial projection step. We were using the same memory context for the projection operation as for the temporary context used by the hashtable routines in execGrouping.c. However, the hashtable routines feel free to reset their temp context at any time, which'd lead to destroying input data that was still needed. Report and diagnosis by Tao Ma. Back-patch to 8.1, where the problem was introduced by the changes that allowed us to work with "virtual" tuples instead of materializing intermediate tuple values everywhere. The earlier code looks quite similar, but it doesn't suffer the problem because the data gets copied into another context as a result of having to materialize ExecProject's output tuple.
-
Peter Eisentraut authored
These two settings ought to be independent of each other.
-
- 27 Jul, 2010 5 commits
-
-
Robert Haas authored
Review by Dave Page.
-
Robert Haas authored
Backpatch to 8.4. Marc Cousin. Review by Kevin Grittner.
-
Peter Eisentraut authored
-
Robert Haas authored
We used to be consistent about this, but my recent patch to add a restart_after_crash GUC failed to follow the existing convention. Report and patch from Fujii Masao.
-
Alvaro Herrera authored
Author: Alex Hunsaker
-
- 26 Jul, 2010 3 commits
-
-
Peter Eisentraut authored
backpatched to 8.1
-
Peter Eisentraut authored
from John Gage
-
Bruce Momjian authored
-
- 25 Jul, 2010 4 commits
-
-
Robert Haas authored
Reviewed by Bernd Helmle.
-
Peter Eisentraut authored
from John Gage
-
Bruce Momjian authored
migrations. Backpatch to 9.0.
-
Bruce Momjian authored
where the oid is not preserved by pg_upgrade (everything but pg_type). Update documentation. Per bug report from depstein@alliedtesting.com.
-
- 24 Jul, 2010 3 commits
-
-
Peter Eisentraut authored
-
Peter Eisentraut authored
by Thom Brown
-
Peter Eisentraut authored
-
- 23 Jul, 2010 3 commits
-
-
Peter Eisentraut authored
- Prohibit altering column type - Prohibit changing inheritance - Move checks from Exec to Prep phases in ALTER TABLE code backpatched to 9.0
-
Robert Haas authored
We now use the phrase 'via local socket in' rather than 'on host' in both \c and \conninfo output, when applicable. Fujii Masao, with some kibitzing by me.
-
Robert Haas authored
Backpatch to 8.0. Andres Freund, with cleanup and adjustment for older branches by me.
-
- 22 Jul, 2010 4 commits
-
-
Robert Haas authored
Fujii Masao
-
Robert Haas authored
-
Robert Haas authored
I've added a quote_all_identifiers GUC which affects the behavior of the backend, and a --quote-all-identifiers argument to pg_dump and pg_dumpall which sets the GUC and also affects the quoting done internally by those applications. Design by Tom Lane; review by Alex Hunsaker; in response to bug #5488 filed by Hartmut Goebel.
-
Robert Haas authored
Remove bespoke code in DoCopy and RI_Initial_Check, which now instead fabricate call ExecCheckRTPerms with a manufactured RangeTblEntry. This is intended to make it feasible for an enhanced security provider to actually make use of ExecutorCheckPerms_hook, but also has the advantage that RI_Initial_Check can allow use of the fast-path when column-level but not table-level permissions are present. KaiGai Kohei. Reviewed (in an earlier version) by Stephen Frost, and by me. Some further changes to the comments by me.
-
- 20 Jul, 2010 8 commits
-
-
Bruce Momjian authored
Does modification just of CVS tag text cause an empty CVS diff for the commit?
-
Bruce Momjian authored
directory/symlink before creation. Report from Tom Lane. Backpatch to 9.0.
-
Robert Haas authored
Per discussion with David Christensen, there can be multiple instances of PG accessible via local sockets, and you need the port to see which one you're actually connected to. David's original patch worked this way, but I inadvertently ripped it out during commit.
-
Robert Haas authored
David Christensen. Reviewed by Steve Singer. Some further changes by me.
-
Robert Haas authored
Per buildfarm, again.
-
Robert Haas authored
Per buildfarm.
-
Robert Haas authored
Normally, we automatically restart after a backend crash, but in some cases when PostgreSQL is invoked by clusterware it may be desirable to suppress this behavior, so we provide an option which does this. Since no existing GUC group quite fits, create a new group called "error handling options" for this and the previously undocumented GUC exit_on_error, which is now documented. Review by Fujii Masao.
-
Robert Haas authored
This change should be publicized to driver maintainers at once and release-noted as an incompatibility with previous releases.
-
- 19 Jul, 2010 1 commit
-
-
Peter Eisentraut authored
per report from Dave Page
-
- 18 Jul, 2010 5 commits
-
-
Tom Lane authored
path when CSV logging is configured but not yet operational. It's sufficient to send the message to stderr, as we were already doing, and the "Not safe" gripe has already confused at least two core members ... Backpatch to 9.0, but not further --- doesn't seem appropriate to change this behavior in stable branches.
-
Tom Lane authored
any implicit casting previously applied to the targetlist item. This is reasonable because the implicit cast, by definition, wasn't written by the user; so we are preserving the expected behavior that ORDER BY items match textually equivalent tlist items. The case never arose before because there couldn't be any implicit casting of a top-level SELECT item before we process ORDER BY etc. But now it can arise in the context of aggregates containing ORDER BY clauses, since the "targetlist" is the already-casted list of arguments for the aggregate. The net effect is that the datatype used for ORDER BY/DISTINCT purposes is the aggregate's declared input type, not that of the original input column; which is a bit debatable but not horrendous, and to do otherwise would require major rework that doesn't seem justified. Per bug #5564 from Daniel Grace. Back-patch to 9.0 where aggregate ORDER BY was implemented.
-
Tom Lane authored
-
Tom Lane authored
-
Bruce Momjian authored
-