hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-26 08:17:01 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • a393fbf937 Restructure error handling as recently discussed. It is now really possible to trap an error inside a function rather than letting it propagate out to PostgresMain. You still have to use AbortCurrentTransaction to clean up, but at least the error handling itself will cooperate. Tom Lane 2004-07-31 00:45:57 +00:00
  • 94f8f63fdb Must guard against NULL return from localtime() when probing pre-1970 dates. Per Magnus Hagander. Tom Lane 2004-07-30 17:31:24 +00:00
  • d01af7730e Fix number for FAQ item. Bruce Momjian 2004-07-30 16:51:59 +00:00
  • adf57cd7e2 PostgreSQL extension makefile framework ("pgxs"), by Fabien Coelho, with some massaging by Peter Eisentraut. This is basically a simple generalization of the existing contrib makefiles. Peter Eisentraut 2004-07-30 12:26:40 +00:00
  • f82d99be7e Translation updates Peter Eisentraut 2004-07-30 05:28:53 +00:00
  • 66917fcff5 Add: Bruce Momjian 2004-07-29 16:47:07 +00:00
  • a3b9a02716 Update Turkish FAQ. Bruce Momjian 2004-07-29 16:30:32 +00:00
  • e57243ea7e Add: Bruce Momjian 2004-07-29 16:24:02 +00:00
  • 7f42dabca8 Fix for pg_ctl -o processing. Report from Sean Chittenden. Bruce Momjian 2004-07-29 16:11:11 +00:00
  • 5bd458c89a Translation update Peter Eisentraut 2004-07-29 14:54:09 +00:00
  • 98c120a203 Revert ill-conceived patch that made elog(FATAL) the same as elog(ERROR) 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. Tom Lane 2004-07-28 22:05:47 +00:00
  • d79dc61df9 Update release notes with better wording. Bruce Momjian 2004-07-28 14:28:57 +00:00
  • 1bf3d61504 Fix subtransaction behavior for large objects, temp namespace, files, 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. Tom Lane 2004-07-28 14:23:31 +00:00
  • cc813fc2b8 Replace nested-BEGIN syntax for subtransactions with spec-compliant 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. Tom Lane 2004-07-27 05:11:48 +00:00
  • b1ee93884d Update tuple header size. Bruce Momjian 2004-07-27 03:27:48 +00:00
  • 0177f43070 Fix oversight: in case where SIGTERM is received while there are 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. Tom Lane 2004-07-27 01:46:03 +00:00
  • 23671f5a0e Add some more logging to simplify diagnosis of problems in IDENT authorization. Inspired by problem report from Ian Pilcher. Tom Lane 2004-07-26 18:53:38 +00:00
  • b14158f405 SQL defines are only used in SQL space in Informix mode. Michael Meskes 2004-07-26 10:28:28 +00:00
  • 5b2f4afffe Here is a patch that fixes the pipes used in find_other_exec() when running as a service on windows <= 2000. Required to make the pg_ctl service wrapper to work at all. Bruce Momjian 2004-07-26 01:48:00 +00:00
  • 25a1324703 Adjust release notes based on community feedback. Bruce Momjian 2004-07-26 00:26:42 +00:00
  • 0ee0e73c9b Translation updates Peter Eisentraut 2004-07-25 12:00:07 +00:00
  • 3306cdfe08 Change declared encoding Peter Eisentraut 2004-07-25 11:49:20 +00:00
  • 22bfb343d6 New translation Peter Eisentraut 2004-07-25 11:44:57 +00:00
  • a2abe9fe58 Update 7.5 release notes. Bruce Momjian 2004-07-25 04:18:05 +00:00
  • 839fe69259 Improve description of release note creation. Bruce Momjian 2004-07-25 03:30:31 +00:00
  • 1e5d82493c Fix obsolete comment. Tom Lane 2004-07-24 20:01:42 +00:00
  • 0655b26282 log_destination should only be PGC_SIGHUP, not PGC_POSTMASTER, as per discussion yesterday. Also a few improvements in the associated documentation. Tom Lane 2004-07-24 19:51:23 +00:00
  • cbcd8b5bec First draft of 7.5 release notes. Still needs markup, additional major items, and detailed text descriptions. Bruce Momjian 2004-07-24 09:36:53 +00:00
  • 97729fa154 Add steps for creating release notes. Bruce Momjian 2004-07-24 03:06:47 +00:00
  • 25c161eba6 Move Win32 defines from port.h to win32.h. Bruce Momjian 2004-07-23 01:58:36 +00:00
  • acd907bfcc Add cross-check that current timeline of pg_control is an ancestor of 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. Tom Lane 2004-07-22 21:09:37 +00:00
  • 3dba9cb694 Add a check on file size as an additional safety check that a WAL file 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. Tom Lane 2004-07-22 20:18:40 +00:00
  • 406e8aa294 Updated wording: Bruce Momjian 2004-07-22 12:24:13 +00:00
  • e15c432302 Done: Bruce Momjian 2004-07-22 11:49:19 +00:00
  • e31c8cf20b Still another try at automatically detecting the best match in the zic 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. Tom Lane 2004-07-22 05:28:30 +00:00
  • 664291107e Avoid default: followed by no statement, per Dann Corbit. Tom Lane 2004-07-22 01:44:36 +00:00
  • 68938c4770 Add missing <getopt.h>, per Dann Corbit. Tom Lane 2004-07-22 01:41:24 +00:00
  • 2042b3428d Invent WAL timelines, as per recent discussion, to make point-in-time 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. Tom Lane 2004-07-21 22:31:26 +00:00
  • 8d3517dc1f The attached patch allows 'select foo()' as well as 'select * from foo()' where foo() is a plperl function that returns a single composite. Bruce Momjian 2004-07-21 20:45:54 +00:00
  • 8eeae3e11c Please find enclosed a patch that matches the PL/Perl documentation (fairly closely, I hope) to the current PL/Perl implementation. Bruce Momjian 2004-07-21 20:44:52 +00:00
  • 4690cc9c7f The attached patch shows the new column "tablespace" in the mentioned views. Bruce Momjian 2004-07-21 20:43:53 +00:00
  • 7a55ba7615 Back out pg_autovacuum commit after cvs clean failure causes commit. Bruce Momjian 2004-07-21 20:34:50 +00:00
  • 8dec0c1bf2 lease find enclosed a patch that matches the PL/Perl documentation (fairly closely, I hope) to the current PL/Perl implementation. Bruce Momjian 2004-07-21 20:23:05 +00:00
  • 83997560b7 Mention plpgsql: Bruce Momjian 2004-07-21 13:46:44 +00:00
  • fd7c3f67e0 Allow borland compiles. Bruce Momjian 2004-07-21 03:07:40 +00:00
  • 53cee20f67 As per the following: Bruce Momjian 2004-07-20 22:56:40 +00:00
  • 6f0d96f8c8 Fix unused variable when Assert() not used. Bruce Momjian 2004-07-20 22:56:29 +00:00
  • 851bcee425 Update: Bruce Momjian 2004-07-20 22:28:16 +00:00
  • cd66b86be2 Add: Bruce Momjian 2004-07-20 21:01:22 +00:00
  • b8a89da230 Suppress readline usage in mingw in configure. Bruce Momjian 2004-07-20 20:37:13 +00:00
  • 5406955541 Add: Bruce Momjian 2004-07-20 19:52:03 +00:00
  • 3df8b47a5e Done: Bruce Momjian 2004-07-20 19:37:36 +00:00
  • a7d68b42f0 Fixed handling of cyclic defines. Michael Meskes 2004-07-20 18:22:53 +00:00
  • 5420ed3a81 Synced parser and keyword list. Fixed handling of cyclic defines. Michael Meskes 2004-07-20 18:06:41 +00:00
  • 45995219a0 Here is another patch that fixes a stack of pg_dump bugs: Bruce Momjian 2004-07-19 21:39:48 +00:00
  • ab50cb14a4 Fix incorrect tracking of session authorization in the presence of ACLs that contain rights granted by non-owners. Per bug report from Nishad Prakash. Tom Lane 2004-07-19 21:02:42 +00:00
  • 465edca3ec Fix incorrect tracking of session authorization in the presence of ACLs that contain rights granted by non-owners. Per bug report from Nishad Prakash. Tom Lane 2004-07-19 21:02:17 +00:00
  • 8459b2d472 Done: Bruce Momjian 2004-07-19 20:57:30 +00:00
  • 6ce4738eca No CVS FAQ, just CVS docs. Bruce Momjian 2004-07-19 20:30:16 +00:00
  • 050976321b *** empty log message *** Bruce Momjian 2004-07-19 20:28:43 +00:00
  • 4ef47f0618 Install recovery.conf.sample into the /share install directory. Tom Lane 2004-07-19 17:03:56 +00:00
  • 9c7a765f02 Remove unportable use of strptime() to parse recovery target time spec. Instead use our own abstimein code, which is more flexible anyway. Tom Lane 2004-07-19 14:34:39 +00:00
  • 66ec2db728 XLOG file archiving and point-in-time recovery. There are still some loose ends and a glaring lack of documentation, but it basically works. Tom Lane 2004-07-19 02:47:16 +00:00
  • d0c1bbdcc6 Rename AC_PROG_LD* macros to PGAC_PROG_LD*. This avoids clashes with the macros provided by the real libtool, when other packages borrow some macros from PostgreSQL, as in the case of the ODBC driver. Peter Eisentraut 2004-07-17 18:53:56 +00:00
  • 3998d0fdca When renaming a column that participates in a foreign key, we must 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. Tom Lane 2004-07-17 17:28:47 +00:00
  • 7f72fd8c47 When renaming a column that participates in a foreign key, we must 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. Tom Lane 2004-07-17 17:28:29 +00:00
  • 694b9ef783 Fix broken markup, per Jonathan Gardner. Tom Lane 2004-07-17 16:33:31 +00:00
  • 6275419446 Add: Bruce Momjian 2004-07-17 10:50:05 +00:00
  • fe548629c5 Invent ResourceOwner mechanism as per my recent proposal, and use it to 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. Tom Lane 2004-07-17 03:32:14 +00:00
  • f4c069ca8f Here is a patch required to build plperl with win32. The issues were: Bruce Momjian 2004-07-16 19:18:24 +00:00
  • 14755f87ee Properly order mysql links. Bruce Momjian 2004-07-15 18:53:44 +00:00
  • 1e0415d96d Add French FAQ. Bruce Momjian 2004-07-15 15:25:25 +00:00
  • 036ecf7afb > pg_ctl --help > ---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 ;) Bruce Momjian 2004-07-15 15:23:32 +00:00
  • 473165aff8 For a SQL function declared to return a named composite type, make sure the tuple datums it returns actually show that type and not RECORD. Tom Lane 2004-07-15 13:51:38 +00:00
  • 7b2c575d4e When retrieving an array of numerics it attempted to set the scale on the retrieved data to zero, which doesn't work for non-integer values. Kris Jurka 2004-07-15 10:00:20 +00:00
  • 93a1fce5cc Add permission display to \db+. Bruce Momjian 2004-07-15 03:56:06 +00:00
  • a837ed88b1 Detect locale/encoding mismatch in initdb, or pick a suitable encoding automatically if none was specified. Peter Eisentraut 2004-07-14 17:55:10 +00:00
  • bbcee544aa Have \dn+ show permissions and description for schemas. Bruce Momjian 2004-07-13 16:48:16 +00:00
  • dc0e76ca36 Change pg_dump to use ALTER OWNER commands instead of SET SESSION 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 Bruce Momjian 2004-07-13 03:00:17 +00:00
  • e419c84c56 Can't have blank lines in resultmap; some versions of expr complain. Tom Lane 2004-07-13 02:55:25 +00:00
  • 6577f178e6 Add new join file. Bruce Momjian 2004-07-13 02:54:08 +00:00
  • ca95bcb1d8 Move tablespace name up on to the same line in psql \d. Bruce Momjian 2004-07-13 02:46:21 +00:00
  • 74f7630093 Rename join ordering named join_1.out Bruce Momjian 2004-07-13 02:05:09 +00:00
  • 9df3086972 Cause libpq and ecpg libraries to be built as proper shared libraries (.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? Tom Lane 2004-07-13 00:06:46 +00:00
  • 8b6f76af46 Make installation instructions match reality. Peter Eisentraut 2004-07-12 22:12:34 +00:00
  • b6335b4fb4 Add tablespace location display for psql \d. Bruce Momjian 2004-07-12 20:41:13 +00:00
  • e47cbb3bad Add has_tablespace_privilege(). Bruce Momjian 2004-07-12 20:23:59 +00:00
  • 1a0f3e476b Add Win32-specific join ordering. Bruce Momjian 2004-07-12 20:11:37 +00:00
  • 15c8fd70e8 Add blank line to new canonicalize_path file, which handles "a b\" properly. Bruce Momjian 2004-07-12 19:27:31 +00:00
  • 5ee0a8dcb6 canonicalization adjustments. Bruce Momjian 2004-07-12 19:18:18 +00:00
  • a4c71af2c0 Put back canonicalization of PGDATA environment variable. Bruce Momjian 2004-07-12 19:15:14 +00:00
  • 76e7e2e776 Use strdup in pg_ctl for canonicalize_path on environment variable. Simplify postmaster call too. Bruce Momjian 2004-07-12 18:17:13 +00:00
  • a0db74a35c This patch adds the following options to pg_dumpall, to be passed to pg_dump: Bruce Momjian 2004-07-12 14:35:45 +00:00
  • 96b9dc1aef The attached patch, which incorporates the previous one sent and currently unapplied regarding spi_internal.c, makes some additional fixes relating to return types, and also contains the fix for preventing the use of insecure versions of Safe.pm. Bruce Momjian 2004-07-12 14:31:04 +00:00
  • f4c5e06edf > win32 doesn't support a static initializer for mutexes, thus the first > user must initialize the lock. The problem are concurrent "first" users > - the pthread_mutex_t initialization must be synchronized. > The current implementation is broken, the attached patches fixes that: > mutex_initlock is a spinlock. If the pthread_mutex_t mutex is not > initialized, then the spinlock is acquired, if the pthread_mutex_t is > initialized if it's not yet initialized and then the spinlock is dropped. Bruce Momjian 2004-07-12 14:23:28 +00:00
  • a29d26a3cd Back out thread fix until I get clarification. Bruce Momjian 2004-07-12 14:16:28 +00:00
  • a41463e31c win32 doesn't support a static initializer for mutexes, thus the first user must initialize the lock. The problem are concurrent "first" users - the pthread_mutex_t initialization must be synchronized. The current implementation is broken, the attached patches fixes that: mutex_initlock is a spinlock. If the pthread_mutex_t mutex is not initialized, then the spinlock is acquired, if the pthread_mutex_t is initialized if it's not yet initialized and then the spinlock is dropped. Bruce Momjian 2004-07-12 14:11:17 +00:00
  • c14a43f657 Remove TABLESPACE option of CREATE SEQUENCE; sequences will now always live in database or schema's default tablespace, as per today's discussion. Also, remove some unused keywords from the grammar (PATH, PENDANT, VERSION), and fix ALSO, which was added as a keyword but not added to the keyword classification lists, thus making it worse-than-reserved. Tom Lane 2004-07-12 05:38:11 +00:00
  • c5ff895c48 New text. Bruce Momjian 2004-07-12 03:58:34 +00:00
  • 298e58cbc4 Fix library_path with canonicalization. Bruce Momjian 2004-07-12 02:22:51 +00:00