aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Translation updatesPeter Eisentraut2004-07-30
|
* Fix for pg_ctl -o processing. Report from Sean Chittenden.Bruce Momjian2004-07-29
|
* Translation updatePeter Eisentraut2004-07-29
|
* Revert ill-conceived patch that made elog(FATAL) the same as elog(ERROR)Tom Lane2004-07-28
| | | | | | followed by seeing EOF from client. If we want a safe session-kill capability we will need to write one, not break our error handling mechanism.
* Fix subtransaction behavior for large objects, temp namespace, files,Tom Lane2004-07-28
| | | | | | | password/group files. Also allow read-only subtransactions of a read-write parent, but not vice versa. These are the reasonably noncontroversial parts of Alvaro's recent mop-up patch, plus further work on large objects to minimize use of the TopTransactionResourceOwner.
* Replace nested-BEGIN syntax for subtransactions with spec-compliantTom Lane2004-07-27
| | | | | | | SAVEPOINT/RELEASE/ROLLBACK-TO syntax. (Alvaro) Cause COMMIT of a failed transaction to report ROLLBACK instead of COMMIT in its command tag. (Tom) Fix a few loose ends in the nested-transactions stuff.
* Fix oversight: in case where SIGTERM is received while there areTom Lane2004-07-27
| | | | | | | | | live backends, the archiver and stats processes never got sent a kill signal. They'd eventually exit on their own, but not for awhile, which is a bit annoying when you are trying to replace the executable file on a platform that doesn't allow removal of busy executables. Also, tweak main loop logic so that we will perform the background tasks after select() returns EINTR.
* Add some more logging to simplify diagnosis of problems in IDENTTom Lane2004-07-26
| | | | authorization. Inspired by problem report from Ian Pilcher.
* SQL defines are only used in SQL space in Informix mode.Michael Meskes2004-07-26
|
* Here is a patch that fixes the pipes used in find_other_exec() whenBruce Momjian2004-07-26
| | | | | | | running as a service on windows <= 2000. Required to make the pg_ctl service wrapper to work at all. Magnus Hagander
* Translation updatesPeter Eisentraut2004-07-25
|
* Improve description of release note creation.Bruce Momjian2004-07-25
|
* Fix obsolete comment.Tom Lane2004-07-24
|
* log_destination should only be PGC_SIGHUP, not PGC_POSTMASTER, as perTom Lane2004-07-24
| | | | | discussion yesterday. Also a few improvements in the associated documentation.
* Add steps for creating release notes.Bruce Momjian2004-07-24
|
* Move Win32 defines from port.h to win32.h.Bruce Momjian2004-07-23
|
* Add cross-check that current timeline of pg_control is an ancestor ofTom Lane2004-07-22
| | | | | | recovery_target_timeline --- otherwise there is no path from the backup to the requested timeline. This check was foreseen in the original discussion but I forgot to implement it.
* Add a check on file size as an additional safety check that a WAL fileTom Lane2004-07-22
| | | | | | | | | recovered from archive is not corrupt. It's not much but it will catch one common problem, viz out-of-disk-space. Also, force a WAL recovery scan when recovery.conf is present, even if pg_control shows a clean shutdown. This allows recovery with a tar backup that was taken with the postmaster shut down, as per complaint from Mark Kirkwood.
* Still another try at automatically detecting the best match in the zicTom Lane2004-07-22
| | | | | | timezone database for the system behavior we find ourselves in. Scan backwards from current time and choose the zone that matches furthest back. As per discussion a week or so back.
* Avoid default: followed by no statement, per Dann Corbit.Tom Lane2004-07-22
|
* Add missing <getopt.h>, per Dann Corbit.Tom Lane2004-07-22
|
* Invent WAL timelines, as per recent discussion, to make point-in-timeTom Lane2004-07-21
| | | | | | | | recovery more manageable. Also, undo recent change to add FILE_HEADER and WASTED_SPACE records to XLOG; instead make the XLOG page header variable-size with extra fields in the first page of an XLOG file. This should fix the boundary-case bugs observed by Mark Kirkwood. initdb forced due to change of XLOG representation.
* The attached patch allows 'select foo()' as well as 'select * fromBruce Momjian2004-07-21
| | | | | | foo()' where foo() is a plperl function that returns a single composite. Andrew Dunstan
* The attached patch shows the new column "tablespace" in the mentionedBruce Momjian2004-07-21
| | | | | | views. Klaus Naumann
* Back out pg_autovacuum commit after cvs clean failure causes commit.Bruce Momjian2004-07-21
|
* lease find enclosed a patch that matches the PL/Perl documentationBruce Momjian2004-07-21
| | | | | | (fairly closely, I hope) to the current PL/Perl implementation. David Fetter
* Allow borland compiles.Bruce Momjian2004-07-21
|
* Fix unused variable when Assert() not used.Bruce Momjian2004-07-20
|
* Synced parser and keyword list.Michael Meskes2004-07-20
| | | | Fixed handling of cyclic defines.
* Here is another patch that fixes a stack of pg_dump bugs:Bruce Momjian2004-07-19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Fix help text ordering * Add back --set-session-authorization to pg_dumpall. Updated the docs for that. Updated help for that. * Dump ALTER USER commands for the cluster owner ("pgsql"). These are dumped AFTER the create user and create database commands in case the permissions to do these have been revoked. * Dump ALTER OWNER for public schema (because it's possible to change it). This was done by adding TOC entries for the public schema, and filtering them out at archiver time. I also save the owner in the TOC entry just for the public schema. * Suppress dumping single quotes around schema_path and DateStyle options when they are set using ALTER USER or ALTER DATABASE. Added a comment to the steps in guc.c to remind people to update that list. * Fix dumping in --clean mode against a pre-7.3 server. It just sets all drop statements to assume the public schema, allowing it to restore without error. * Cleaned up text output. eg. Don't output -- Tablespaces comment if there are none. Same for groups and users. * Make the commands to DELETE FROM pg_shadow and DELETE FROM pg_group only be output when -c mode is enabled. I'm not sure why that hasn't been done before?!?! This should be good for application asap, after which I will start on regression dumping 7.0-7.4 databases. Christopher Kings-Lynne
* Fix incorrect tracking of session authorization in the presence of ACLsTom Lane2004-07-19
| | | | | that contain rights granted by non-owners. Per bug report from Nishad Prakash.
* Install recovery.conf.sample into the /share install directory.Tom Lane2004-07-19
|
* Remove unportable use of strptime() to parse recovery target time spec.Tom Lane2004-07-19
| | | | Instead use our own abstimein code, which is more flexible anyway.
* XLOG file archiving and point-in-time recovery. There are still someTom Lane2004-07-19
| | | | | | loose ends and a glaring lack of documentation, but it basically works. Simon Riggs with some editorialization by Tom Lane.
* When renaming a column that participates in a foreign key, we mustTom Lane2004-07-17
| | | | | | force relcache rebuild for the other table as well as the column's own table. Otherwise, already-cached foreign key triggers will stop working. Per example from Alexander Pravking.
* Invent ResourceOwner mechanism as per my recent proposal, and use it toTom Lane2004-07-17
| | | | | | | | keep track of portal-related resources separately from transaction-related resources. This allows cursors to work in a somewhat sane fashion with nested transactions. For now, cursor behavior is non-subtransactional, that is a cursor's state does not roll back if you abort a subtransaction that fetched from the cursor. We might want to change that later.
* Here is a patch required to build plperl with win32. The issues were:Bruce Momjian2004-07-16
| | | | | | | | | * perl_useshrplib gets set to "yes" and not to "true". I assume it's set to "true" on unix, so I left both. * Need to translate backslashes into slashes * The linker config coming out of perl was for MSVC and not for mingw Magnus Hagander
* > pg_ctl --helpBruce Momjian2004-07-15
| | | | | | | | | | | > ---skiped--- > -P user name of account to register PostgreSQL server > -U password of account to register PostgreSQL server > ---skiped--- > > I think that isn't right ;) Claudio Natoli
* For a SQL function declared to return a named composite type, makeTom Lane2004-07-15
| | | | sure the tuple datums it returns actually show that type and not RECORD.
* Add permission display to \db+.Bruce Momjian2004-07-15
|
* Detect locale/encoding mismatch in initdb, or pick a suitable encodingPeter Eisentraut2004-07-14
| | | | automatically if none was specified.
* Have \dn+ show permissions and description for schemas.Bruce Momjian2004-07-13
| | | | Dennis Bjorklund
* Change pg_dump to use ALTER OWNER commands instead of SET SESSIONBruce Momjian2004-07-13
| | | | | | | | | AUTHORIZATION commands by default. Move all GRANT and REVOKE commands to the end of the dump to avoid restore failures in several situations. Bring back --use-set-session-authorization option to get previous SET behaviour Christopher Kings-Lyne
* Can't have blank lines in resultmap; some versions of expr complain.Tom Lane2004-07-13
|
* Add new join file.Bruce Momjian2004-07-13
|
* Move tablespace name up on to the same line in psql \d.Bruce Momjian2004-07-13
|
* Rename join ordering named join_1.outBruce Momjian2004-07-13
|
* Cause libpq and ecpg libraries to be built as proper shared librariesTom Lane2004-07-13
| | | | | | | | | | | | (.dylib format) on Mac OS X, while not messing up loadable modules for the backend (which are the same kind of animal as a shared library on every other platform, but not here). Also get the naming convention to match OS X practice, viz libFOO.version.so not libFOO.so.version. In support of that last, refactor code in Makefile.shlib to make it easier to have platform-specific shlib naming conventions. This patch is loosely based on the Fink project's current postgresql.patch. Tested by yours truly on OS X 10.3.4; does anyone have 10.2.* to check it on?
* Add tablespace location display for psql \d.Bruce Momjian2004-07-12
| | | | Gavin Sherry
* Add has_tablespace_privilege().Bruce Momjian2004-07-12
| | | | Christopher Kings-Lynne
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-30 17:50:34 +0000