aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Added new version of ecpg's parser test script which was written by Andy ↵Michael Meskes2011-03-08
| | | | Colson <andy@squeakycode.net>.
* Truncate predicate lock manager's SLRU lazily at checkpoint. That's saferHeikki Linnakangas2011-03-08
| | | | | | | | than doing it aggressively whenever the tail-XID pointer is advanced, because this way we don't need to do it while holding SerializableXactHashLock. This also fixes bug #5915 spotted by YAMAMOTO Takashi, and removes an obsolete comment spotted by Kevin Grittner.
* Fix behavior when raising plpy.Fatal()Peter Eisentraut2011-03-07
| | | | | | | It should cause a elog(FATAL) error, and it fact it was simply causing a elog(ERROR). Jan Urbański
* Report Python errors from iterators with PLy_elogPeter Eisentraut2011-03-07
| | | | | | | | | | This improves reporting, as the error string now includes the actual Python exception. As a side effect, this no longer sets the errcode to ERRCODE_DATA_EXCEPTION, which might be considered a feature, as it's not documented and not clear why iterator errors should be treated differently. Jan Urbański
* Improve description of inquiry functions that accept regclass.Tom Lane2011-03-07
| | | | Per a suggestion from Thom Brown, though this is not his proposed patch.
* Minor copy-editing in CREATE TRIGGER reference page.Tom Lane2011-03-07
| | | | Per suggestions from Thom Brown and Robert Haas.
* If recovery_target_timeline is set to 'latest' and standby mode is enabled,Heikki Linnakangas2011-03-07
| | | | | | | | | | | | | | | | | periodically rescan the archive for new timelines, while waiting for new WAL segments to arrive. This allows you to set up a standby server that follows the TLI change if another standby server is promoted to master. Before this, you had to restart the standby server to make it notice the new timeline. This patch only scans the archive for TLI changes, it won't follow a TLI change in streaming replication. That is much needed too, but it would be a much bigger patch than I dare to sneak in this late in the release cycle. There was discussion on improving the sanity checking of the WAL segments so that the system would notice more reliably if the new timeline isn't an ancestor of the current one, but that is not included in this patch. Reviewed by Fujii Masao.
* Reword alpha release note item on SSI.Robert Haas2011-03-07
| | | | Per Josh Berkus; some additional explanatory text by me.
* Synchronous replication doc corrections.Robert Haas2011-03-07
| | | | Thom Brown
* Zero out vacuum_count and related counters in pgstat_recv_tabstat().Tom Lane2011-03-07
| | | | | | This fixes an oversight in commit 946045f04d11d246a834b917a2b8bc6e4f884a37 of 2010-08-21, as reported by Itagaki Takahiro. Also a couple of minor cosmetic adjustments.
* Document the DEFERRABLE option in SET TRANSACTION command.Heikki Linnakangas2011-03-07
| | | | Kevin Grittner
* Begin error message with lower-case letter.Heikki Linnakangas2011-03-07
|
* Silence compiler warning about undefined function when compiling withoutHeikki Linnakangas2011-03-07
| | | | assertions.
* Tighten pg_upgrade check for pre-8.4 toast table name matching.Bruce Momjian2011-03-06
|
* Suppress some "variable might be clobbered by longjmp" warnings.Tom Lane2011-03-06
| | | | | | Seen with an older gcc version. I'm not sure these represent any real risk factor, but still a bit scary. Anyway we have lots of other volatile-marked variables in this code, so a couple more won't hurt.
* Fix a couple more missing "static" markers.Tom Lane2011-03-06
|
* Add missing "static" marker to internal_ping().Tom Lane2011-03-06
| | | | Per testing with a compiler that doesn't like that.
* Dynamic array required within pg_stat_replication.Simon Riggs2011-03-07
|
* Catversion increment for pg_stat_replication changes for syncrepSimon Riggs2011-03-06
|
* Add new files for syncrep missed in previous commitSimon Riggs2011-03-06
|
* Fix pg_dump's dump order for collations versus extensions.Tom Lane2011-03-06
| | | | | Mixing them together alphabetically won't be nice. Per my gripe of 2011-02-12.
* Efficient transaction-controlled synchronous replication.Simon Riggs2011-03-06
| | | | | | | | | | | | | | | | | | If a standby is broadcasting reply messages and we have named one or more standbys in synchronous_standby_names then allow users who set synchronous_replication to wait for commit, which then provides strict data integrity guarantees. Design avoids sending and receiving transaction state information so minimises bookkeeping overheads. We synchronize with the highest priority standby that is connected and ready to synchronize. Other standbys can be defined to takeover in case of standby failure. This version has very strict behaviour; more relaxed options may be added at a later date. Simon Riggs and Fujii Masao, with reviews by Yeb Havinga, Jaime Casanova, Heikki Linnakangas and Robert Haas, plus the assistance of many other design reviewers.
* Fix incorrect access to pg_index.indcollation.Tom Lane2011-03-06
| | | | | | | | | Since this field is after a variable-length field, it can't simply be accessed via the C struct for pg_index. Fortunately, the relcache already did the dirty work of pulling the information out to where it can be accessed easily, so this is a one-line fix. Andres Freund
* Improve pg_upgrade relation name check logic for pre-8.4 servers.Bruce Momjian2011-03-06
|
* Update new pg_upgrade comment about pre-8.4 TOAST tables.Bruce Momjian2011-03-05
|
* Restructure pg_upgrade checks because pre-8.4 Postgres did not renameBruce Momjian2011-03-05
| | | | toast file names to match the new relfilenode.
* Fix pg_upgrade to print the proper database name for file transferBruce Momjian2011-03-05
| | | | failures.
* Print clearer failure message when pg_upgrade fails due to a fatalBruce Momjian2011-03-05
| | | | error.
* Fix parallel gmake for extension directory addition in PL languages.Bruce Momjian2011-03-05
|
* Add PL extension files to MSVC Install procedure.Andrew Dunstan2011-03-05
|
* Adjust documentation about pg_pltemplate to reflect latest thinking.Tom Lane2011-03-05
| | | | | It's more likely that pg_pltemplate will go away in the future than that we'll add additional specialized infrastructure for it.
* Make plpythonu language use plpython2 shared library directly.Tom Lane2011-03-05
| | | | | | | | | The original scheme for this was to symlink plpython.$DLSUFFIX to plpython2.$DLSUFFIX, but that doesn't work on Windows, and only accidentally failed to fail because of the way that CREATE LANGUAGE created or didn't create new C functions. My changes of yesterday exposed the weakness of that approach. To fix, get rid of the symlink and make pg_pltemplate show what's really going on.
* Convert createlang/droplang to use CREATE/DROP EXTENSION.Tom Lane2011-03-05
| | | | | | | | | | In createlang this is a one-line change. In droplang there's a whole lot of cruft that can be discarded since the extension mechanism now manages removal of the language's support functions. Also, add deprecation notices to these two programs' reference pages, since per discussion we may toss them overboard altogether in a release or two.
* Remove one copy of duplicated alpha4 release note.Robert Haas2011-03-05
| | | | Noted by Andy Colson
* Update of SQL feature conformancePeter Eisentraut2011-03-05
|
* Add missing word.Robert Haas2011-03-05
|
* First cut at 9.1alpha4 release notes.Robert Haas2011-03-05
|
* Remove emphasis from 9.1alpha3 items.Robert Haas2011-03-05
| | | | | In preparation for 9.1alpha4 release notes, where only the 9.1alpha4 features will be emphasized.
* Update documentation to reflect that standard PLs are now extensions.Tom Lane2011-03-05
| | | | | | Recommend use of CREATE EXTENSION rather than plain CREATE LANGUAGE where relevant. Encourage PL authors to provide extension wrappers for their PLs.
* Create extension infrastructure for the core procedural languages.Tom Lane2011-03-04
| | | | | | | | | | | | | | | | | | | | This mostly just involves creating control, install, and update-from-unpackaged scripts for them. However, I had to adjust plperl and plpython to not share the same support functions between variants, because we can't put the same function into multiple extensions. catversion bump forced due to new contents of pg_pltemplate, and because initdb now installs plpgsql as an extension not a bare language. Add support for regression testing these as extensions not bare languages. Fix a couple of other issues that popped up while testing this: my initial hack at pg_dump binary-upgrade support didn't work right, and we don't want an extra schema permissions test after all. Documentation changes still to come, but I'm committing now to see whether the MSVC build scripts need work (likely they do).
* Refactor seclabel.c to use the new check_object_ownership function.Robert Haas2011-03-04
| | | | | This avoids duplicate (and not-quite-matching) code, and makes the logic for SECURITY LABEL match COMMENT and ALTER EXTENSION ADD/DROP.
* Don't allow CREATE TABLE AS to create a column with invalid collationPeter Eisentraut2011-03-04
| | | | | | | | | It is possible that an expression ends up with a collatable type but without a collation. CREATE TABLE AS could then create a table based on that. But such a column cannot be dumped with valid SQL syntax, so we disallow creating such a column. per test report from Noah Misch
* Allow non-superusers to create (some) extensions.Tom Lane2011-03-04
| | | | | | | | | | | | | | | | | | | | | | | | | | | Remove the unconditional superuser permissions check in CREATE EXTENSION, and instead define a "superuser" extension property, which when false (not the default) skips the superuser permissions check. In this case the calling user only needs enough permissions to execute the commands in the extension's installation script. The superuser property is also enforced in the same way for ALTER EXTENSION UPDATE cases. In other ALTER EXTENSION cases and DROP EXTENSION, test ownership of the extension rather than superuserness. ALTER EXTENSION ADD/DROP needs to insist on ownership of the target object as well; to do that without duplicating code, refactor comment.c's big switch for permissions checks into a separate function in objectaddress.c. I also removed the superuserness checks in pg_available_extensions and related functions; there's no strong reason why everybody shouldn't be able to see that info. Also invent an IF NOT EXISTS variant of CREATE EXTENSION, and use that in pg_dump, so that dumps won't fail for installed-by-default extensions. We don't have any of those yet, but we will soon. This is all per discussion of wrapping the standard procedural languages into extensions. I'll make those changes in a separate commit; this is just putting the core infrastructure in place.
* When creating a collation, check that the locales can be loadedPeter Eisentraut2011-03-04
| | | | | | This is the same check that would happen later when the collation is used, but it's friendlier to check the collation already when it is created.
* In initialize_SSL, don't fail unnecessarily when home dir is unavailable.Tom Lane2011-03-04
| | | | | | | | | | Instead, just act as though the certificate file(s) are not present. There is only one case where this need be a hard failure condition: when sslmode is verify-ca or verify-full, not having a root cert file is an error. Change the logic so that we complain only in that case, and otherwise fall through cleanly. This is how it used to behave pre-9.0, but my patch 4ed4b6c54e5fab24ab2624d80e26f7546edc88ad of 2010-05-26 broke the case. Per report from Christian Kastner.
* You must hold a lock on the heap page when you callHeikki Linnakangas2011-03-04
| | | | | | CheckForSerializableConflictOut(), because it can set hint bits. YAMAMOTO Takashi
* Add a comment explaining the recent fix for plpython breakage in commit 4c966d9.Andrew Dunstan2011-03-03
| | | | Mostly text supplied by Jan Urbański.
* Further refine patch for commenting operator implementation functions.Tom Lane2011-03-03
| | | | | | | | Instead of manually maintaining the "implementation of XXX operator" comments in pg_proc.h, delete all those entries and let initdb create them via a join. To let initdb figure out which name to use when there is a conflict, change the comments for deprecated operators to say they are deprecated --- which seems like a good thing to do anyway.
* Fix citext's upgrade-from-unpackaged script to set its collation correctly.Tom Lane2011-03-03
| | | | | | Although there remains some debate about how CREATE TYPE should represent the collation property, this doesn't really affect what we need to do in citext's script, so go ahead and fix that.
* Run a portal's cleanup hook immediately when pushing it to DONE state.Tom Lane2011-03-03
| | | | | | | | | This works around the problem noted by Yamamoto Takashi in bug #5906, that there were code paths whereby we could reach AtCleanup_Portals with a portal's cleanup hook still unexecuted. The changes I made a few days ago were intended to prevent that from happening, and I think that on balance it's still a good thing to avoid, so I don't want to remove the Assert in AtCleanup_Portals. Hence do this instead.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-07 01:10:39 +0000