aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Split heapam_xlog.h from heapam.hAlvaro Herrera2012-08-28
| | | | | | | | | | | | The heapam XLog functions are used by other modules, not all of which are interested in the rest of the heapam API. With this, we let them get just the XLog stuff in which they are interested and not pollute them with unrelated includes. Also, since heapam.h no longer requires xlog.h, many files that do include heapam.h no longer get xlog.h automatically, including a few headers. This is useful because heapam.h is getting pulled in by execnodes.h, which is in turn included by a lot of files.
* remove catcache.h from syscache.hAlvaro Herrera2012-08-28
| | | | | Instead, place a forward struct declaration for struct catclist in syscache.h. This reduces header proliferation somewhat.
* Split resowner.hAlvaro Herrera2012-08-28
| | | | | This lets files that are mere users of ResourceOwner not automatically include the headers for stuff that is managed by the resowner mechanism.
* add #includes to plpy_subxactobject.h to make it compile standaloneAlvaro Herrera2012-08-28
|
* Remove pg_stat_statements--1.0.sql, too.Tom Lane2012-08-28
| | | | Per Peter Geoghegan.
* Remove hstore--1.0.sql.Tom Lane2012-08-28
| | | | | Since we're not installing this file anymore, it has no reason to exist, other than as historical reference; but we have an SCM for that.
* Adjust pg_test_timing to show shortest test durations first, placeBruce Momjian2012-08-28
| | | | percentage column before count column. Docs updated.
* Prevent psql tab completion in SET from adding TO when the equals signBruce Momjian2012-08-28
| | | | | | has no space before it. Report by Erik Rijkers
* Update doc mention of how to compute bigint advisory lock value, per TomBruce Momjian2012-08-28
| | | | Lane's correction.
* syncrep.h must include xlogdefs.hAlvaro Herrera2012-08-28
|
* Small punctuation fixesPeter Eisentraut2012-08-28
|
* Document how to create advisory lock "bigint" values in SQL.Bruce Momjian2012-08-27
| | | | David E. Wheeler
* Improve a couple of 9.2 release note entries.Tom Lane2012-08-27
| | | | | Clarify the compatibility notes about EXTRACT() and about statistics timing columns.
* Add section IDs to subsections of syntax.sgml that lacked them.Tom Lane2012-08-27
| | | | | | | This is so that these sections will have stable HTML tags that one can link to, rather than things like "AEN1902". Perhaps we should mount a campaign to do this everywhere, but I've found myself pointing at syntax.sgml subsections often enough to be sure it's useful here.
* Document the lack of reading the PGDATABASE environment variable inBruce Momjian2012-08-27
| | | | pg_restore.
* pg_upgrade: Fix exec_prog API to be less flakyAlvaro Herrera2012-08-27
| | | | | | | | | | The previous signature made it very easy to pass something other than the printf-format specifier in the corresponding position, without any warning from the compiler. While at it, move some of the escaping, redirecting and quoting responsibilities from the callers into exec_prog() itself. This makes the callsites cleaner.
* Fix thinko in commentAlvaro Herrera2012-08-27
| | | | It was confusing symlinks with hard links.
* Remove analyze_new_cluster.sh on make clean, tooAlvaro Herrera2012-08-27
|
* Fix DROP INDEX CONCURRENTLY IF EXISTS.Tom Lane2012-08-27
| | | | | | | | This threw ERROR, not the expected NOTICE, if the index didn't exist. The bug was actually visible in not-as-expected regression test output, so somebody wasn't paying too close attention in commit 8cb53654dbdb4c386369eb988062d0bbb6de725e. Per report from Brendan Byrd.
* Have pgindent requre pg_bsd_indent version 1.2 now that a new versionBruce Momjian2012-08-27
| | | | | | has been created by adding #include <stdlib.h> to parse.c. per request from Kevin Grittner.
* Collect and use histograms of lower and upper bounds for range types.Heikki Linnakangas2012-08-27
| | | | | | | | | | | | | | | This enables selectivity estimation of the <<, >>, &<, &> and && operators, as well as the normal inequality operators: <, <=, >=, >. "range @> element" is also supported, but the range-variant @> and <@ operators are not, because they cannot be sensibly estimated with lower and upper bound histograms alone. We would need to make some assumption about the lengths of the ranges for that. Alexander's patch included a separate histogram of lengths for that, but I left that out of the patch for simplicity. Hopefully that will be added as a followup patch. The fraction of empty ranges is also calculated and used in estimation. Alexander Korotkov, heavily modified by me.
* pg_basebackup: Correct error messagePeter Eisentraut2012-08-27
| | | | | It still thought that the --xlog-method option argument could be empty, as in a previous version of this feature.
* Update FreeBSD kernel configuration documentation.Bruce Momjian2012-08-26
| | | | Brad Davis
* Fix up planner infrastructure to support LATERAL properly.Tom Lane2012-08-26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | This patch takes care of a number of problems having to do with failure to choose valid join orders and incorrect handling of lateral references pulled up from subqueries. Notable changes: * Add a LateralJoinInfo data structure similar to SpecialJoinInfo, to represent join ordering constraints created by lateral references. (I first considered extending the SpecialJoinInfo structure, but the semantics are different enough that a separate data structure seems better.) Extend join_is_legal() and related functions to prevent trying to form unworkable joins, and to ensure that we will consider joins that satisfy lateral references even if the joins would be clauseless. * Fill in the infrastructure needed for the last few types of relation scan paths to support parameterization. We'd have wanted this eventually anyway, but it is necessary now because a relation that gets pulled up out of a UNION ALL subquery may acquire a reltargetlist containing lateral references, meaning that its paths *have* to be parameterized whether or not we have any code that can push join quals down into the scan. * Compute data about lateral references early in query_planner(), and save in RelOptInfo nodes, to avoid repetitive calculations later. * Assorted corner-case bug fixes. There's probably still some bugs left, but this is a lot closer to being real than it was before.
* Clarify documentation that primary key and unique constraints are copiedBruce Momjian2012-08-26
| | | | | | for CREATE TABLE LIKE ... INCLUDING INDEXES. Per report from david.sahagian@emc.com
* Use psql_error() for most psql error calls, per request from Magnus.Bruce Momjian2012-08-25
|
* Document clearly that psql \! parameter interpretation limitations areBruce Momjian2012-08-25
| | | | the same as \copy.
* Allow text timezone designations, e.g. "America/Chicago", when using theBruce Momjian2012-08-25
| | | | ISO "T" timestamptz format.
* Some spelling adjustments in release notesPeter Eisentraut2012-08-24
|
* Normalize some British spellingsPeter Eisentraut2012-08-24
|
* Fix issues with checks for unsupported transaction states in Hot Standby.Tom Lane2012-08-24
| | | | | | | | | | | | | | | | | | | | | | | | | The GUC check hooks for transaction_read_only and transaction_isolation tried to check RecoveryInProgress(), so as to disallow setting read/write mode or serializable isolation level (respectively) in hot standby sessions. However, GUC check hooks can be called in many situations where we're not connected to shared memory at all, resulting in a crash in RecoveryInProgress(). Among other cases, this results in EXEC_BACKEND builds crashing during child process start if default_transaction_isolation is serializable, as reported by Heikki Linnakangas. Protect those calls by silently allowing any setting when not inside a transaction; which is okay anyway since these GUCs are always reset at start of transaction. Also, add a check to GetSerializableTransactionSnapshot() to complain if we are in hot standby. We need that check despite the one in check_XactIsoLevel() because default_transaction_isolation could be serializable. We don't want to complain any sooner than this in such cases, since that would prevent running transactions at all in such a state; but a transaction can be run, if SET TRANSACTION ISOLATION is done before setting a snapshot. Per report some months ago from Robert Haas. Back-patch to 9.1, since these problems were introduced by the SSI patch. Kevin Grittner and Tom Lane, with ideas from Heikki Linnakangas
* Put options on man page and in help output in slightly better orderPeter Eisentraut2012-08-24
|
* libpq: Fix memory leak in URI parserPeter Eisentraut2012-08-23
| | | | | | When an invalid query parameter is reported, some memory leaks. found by Coverity
* Fix cascading privilege revoke to notice when privileges are still held.Tom Lane2012-08-23
| | | | | | | | | | | | If we revoke a grant option from some role X, but X still holds the option via another grant, we should not recursively revoke the privilege from role(s) Y that X had granted it to. This was supposedly fixed as one aspect of commit 4b2dafcc0b1a579ef5daaa2728223006d1ff98e9, but I must not have tested it, because in fact that code never worked: it forgot to shift the grant-option bits back over when masking the bits being revoked. Per bug #6728 from Daniel German. Back-patch to all active branches, since this has been wrong since 8.0.
* Fix typo in example.Heikki Linnakangas2012-08-23
|
* Add instructions for setting up documentation tool chain on Mac OS XPeter Eisentraut2012-08-23
|
* pg_upgrade: Run the created scripts in the test suitePeter Eisentraut2012-08-23
| | | | Just to check that they actually work.
* Remove overly-pessimistic statement about constraint exclusion.Tom Lane2012-08-22
| | | | | | | As of 9.2, constraint exclusion should work okay with prepared statements: the planner will try custom plans with actual values of the parameters, and observe that they are a lot cheaper than the generic plan, and thus never fall back to using the generic plan. Noted by Tatsuhito Kasahara.
* Make a cut at a major-features list for 9.2.Tom Lane2012-08-22
| | | | | This is open to debate of course, but it's past time we had *something* here.
* Make an editorial pass over the 9.2 release notes.Tom Lane2012-08-22
| | | | A very large number of small improvements ...
* Fix erroneous documentation of synchronous_commit = remote_write.Tom Lane2012-08-22
| | | | | | | The docs claimed that this mode only waits for the standby to receive WAL data, but actually it waits for the data to be written out to the standby's OS; which is a pretty significant difference because it removes the risk of crash of the walreceiver process.
* Fix typo.Bruce Momjian2012-08-22
|
* Document that pg_reload_conf() is also an easy way to reload theBruce Momjian2012-08-22
| | | | configuration file.
* Fix install-strip on Mac OS XPeter Eisentraut2012-08-21
| | | | | | | | | | | There was a hack put into install-sh to call strip with the correct options on Mac OS X. But that never worked, because configure disabled stripping on that platform altogether. So remove that dead code, and while we're at it, update install-sh to the latest upstream source (from Automake). Instead, set up the right strip options in programs.m4, so this now actually works the way it was originally intended.
* Mark DateTimeParseError() noreturnPeter Eisentraut2012-08-21
| | | | | This avoids a warning from clang 3.2 about an uninitialized variable 'dtype' in date_in().
* Update 9.2 release notes to reflect commits to date.Tom Lane2012-08-21
| | | | | I was unable to entirely resist the temptation to copy-edit related entries, but will save most of that for a separate pass.
* Avoid somewhat-theoretical overflow risks in RecordIsValid().Tom Lane2012-08-21
| | | | | | | | | | | | | This improves on commit 51fed14d73ed3acd2282b531fb1396877e44e86a by eliminating the assumption that we can form <some pointer value> + <some offset> without overflow. The entire point of those tests is that we don't trust the offset value, so coding them in a way that could wrap around if the buffer happens to be near the top of memory doesn't seem sound. Instead, track the remaining space as a size_t variable and compare offsets against that. Also, improve comment about why we need the extra early check on xl_tot_len.
* Fix dumping of security_barrier views with circular dependencies.Tom Lane2012-08-21
| | | | | | | | | If a view has circular dependencies, pg_dump splits it into a CREATE TABLE and a CREATE RULE command to break the dependency loop. However, if the view has reloptions, those options cannot be applied in the CREATE TABLE command, because views and tables have different allowed reloptions so CREATE TABLE would reject them. Instead apply the reloptions after the CREATE RULE, using ALTER VIEW SET.
* Improve C comments in GetSnapshotData.Robert Haas2012-08-21
| | | | | | Move discussion of why our algorithm for taking snapshots in recovery to a more appropriate location in the function, and delete incorrect mention of taking a lock.
* Add a note to the MVCC chapter that some things aren't transactional.Robert Haas2012-08-21
| | | | Craig Ringer, slightly edited by me.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-04 05:34:41 +0000