summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2004-07-30Must guard against NULL return from localtime() when probing pre-1970Tom Lane
dates. Per Magnus Hagander.
2004-07-30PostgreSQL extension makefile framework ("pgxs"), by Fabien Coelho, withPeter Eisentraut
some massaging by Peter Eisentraut. This is basically a simple generalization of the existing contrib makefiles.
2004-07-30Translation updatesPeter Eisentraut
2004-07-29Fix for pg_ctl -o processing. Report from Sean Chittenden.Bruce Momjian
2004-07-29Translation updatePeter Eisentraut
2004-07-28Revert ill-conceived patch that made elog(FATAL) the same as elog(ERROR)Tom Lane
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.
2004-07-28Fix subtransaction behavior for large objects, temp namespace, files,Tom Lane
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.
2004-07-27Replace nested-BEGIN syntax for subtransactions with spec-compliantTom Lane
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.
2004-07-27Fix oversight: in case where SIGTERM is received while there areTom Lane
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.
2004-07-26Add some more logging to simplify diagnosis of problems in IDENTTom Lane
authorization. Inspired by problem report from Ian Pilcher.
2004-07-26SQL defines are only used in SQL space in Informix mode.Michael Meskes
2004-07-26Here is a patch that fixes the pipes used in find_other_exec() whenBruce Momjian
running as a service on windows <= 2000. Required to make the pg_ctl service wrapper to work at all. Magnus Hagander
2004-07-25Translation updatesPeter Eisentraut
2004-07-25Improve description of release note creation.Bruce Momjian
2004-07-24Fix obsolete comment.Tom Lane
2004-07-24log_destination should only be PGC_SIGHUP, not PGC_POSTMASTER, as perTom Lane
discussion yesterday. Also a few improvements in the associated documentation.
2004-07-24Add steps for creating release notes.Bruce Momjian
2004-07-23Move Win32 defines from port.h to win32.h.Bruce Momjian
2004-07-22Add cross-check that current timeline of pg_control is an ancestor ofTom Lane
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.
2004-07-22Add a check on file size as an additional safety check that a WAL fileTom Lane
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.
2004-07-22Still another try at automatically detecting the best match in the zicTom Lane
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.
2004-07-22Avoid default: followed by no statement, per Dann Corbit.Tom Lane
2004-07-22Add missing <getopt.h>, per Dann Corbit.Tom Lane
2004-07-21Invent WAL timelines, as per recent discussion, to make point-in-timeTom Lane
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.
2004-07-21The attached patch allows 'select foo()' as well as 'select * fromBruce Momjian
foo()' where foo() is a plperl function that returns a single composite. Andrew Dunstan
2004-07-21The attached patch shows the new column "tablespace" in the mentionedBruce Momjian
views. Klaus Naumann
2004-07-21Back out pg_autovacuum commit after cvs clean failure causes commit.Bruce Momjian
2004-07-21lease find enclosed a patch that matches the PL/Perl documentationBruce Momjian
(fairly closely, I hope) to the current PL/Perl implementation. David Fetter
2004-07-21Allow borland compiles.Bruce Momjian
2004-07-20Fix unused variable when Assert() not used.Bruce Momjian
2004-07-20Synced parser and keyword list.Michael Meskes
Fixed handling of cyclic defines.
2004-07-19Here is another patch that fixes a stack of pg_dump bugs:Bruce Momjian
* 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
2004-07-19Fix incorrect tracking of session authorization in the presence of ACLsTom Lane
that contain rights granted by non-owners. Per bug report from Nishad Prakash.
2004-07-19Install recovery.conf.sample into the /share install directory.Tom Lane
2004-07-19Remove unportable use of strptime() to parse recovery target time spec.Tom Lane
Instead use our own abstimein code, which is more flexible anyway.
2004-07-19XLOG file archiving and point-in-time recovery. There are still someTom Lane
loose ends and a glaring lack of documentation, but it basically works. Simon Riggs with some editorialization by Tom Lane.
2004-07-17When renaming a column that participates in a foreign key, we mustTom Lane
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.
2004-07-17Invent ResourceOwner mechanism as per my recent proposal, and use it toTom Lane
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.
2004-07-16Here is a patch required to build plperl with win32. The issues were:Bruce Momjian
* 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
2004-07-15> pg_ctl --helpBruce Momjian
> ---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
2004-07-15For a SQL function declared to return a named composite type, makeTom Lane
sure the tuple datums it returns actually show that type and not RECORD.
2004-07-15Add permission display to \db+.Bruce Momjian
2004-07-14Detect locale/encoding mismatch in initdb, or pick a suitable encodingPeter Eisentraut
automatically if none was specified.
2004-07-13Have \dn+ show permissions and description for schemas.Bruce Momjian
Dennis Bjorklund
2004-07-13Change pg_dump to use ALTER OWNER commands instead of SET SESSIONBruce Momjian
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
2004-07-13Can't have blank lines in resultmap; some versions of expr complain.Tom Lane
2004-07-13Add new join file.Bruce Momjian
2004-07-13Move tablespace name up on to the same line in psql \d.Bruce Momjian
2004-07-13Rename join ordering named join_1.outBruce Momjian
2004-07-13Cause libpq and ecpg libraries to be built as proper shared librariesTom Lane
(.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?
generated by cgit v1.2.3 (git 2.46.0) at 2025-08-18 15:59:48 +0000