hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-24 23:37:03 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • bce5fd63fd Don't crash when a rowtype argument to a plpgsql function is NULL. Per report from Chris Campbell. Tom Lane 2004-02-24 01:44:47 +00:00
  • 55fb172739 Don't crash when a rowtype argument to a plpgsql function is NULL. Per report from Chris Campbell. Tom Lane 2004-02-24 01:44:33 +00:00
  • 3f2cf812af Fix obsolete comment. Tom Lane 2004-02-23 23:55:08 +00:00
  • 6b534f3c33 Replace opendir/closedir calls throughout the backend with AllocateDir and FreeDir routines modeled on the existing AllocateFile/FreeFile. Like the latter, these routines will avoid failing on EMFILE/ENFILE conditions whenever possible, and will prevent leakage of directory descriptors if an elog() occurs while one is open. Also, reduce PANIC to ERROR in MoveOfflineLogs() --- this is not critical code and there is no reason to force a DB restart on failure. All per recent trouble report from Olivier Hubaut. Tom Lane 2004-02-23 23:03:43 +00:00
  • 7a57a67278 Replace opendir/closedir calls throughout the backend with AllocateDir and FreeDir routines modeled on the existing AllocateFile/FreeFile. Like the latter, these routines will avoid failing on EMFILE/ENFILE conditions whenever possible, and will prevent leakage of directory descriptors if an elog() occurs while one is open. Also, reduce PANIC to ERROR in MoveOfflineLogs() --- this is not critical code and there is no reason to force a DB restart on failure. All per recent trouble report from Olivier Hubaut. Tom Lane 2004-02-23 23:03:10 +00:00
  • 4f571319d3 NOFILE isn't used anywhere any more. Tom Lane 2004-02-23 20:48:03 +00:00
  • 95a6dbf12b Do a direct probe during postmaster startup to determine the maximum number of openable files and the number already opened. This eliminates depending on sysconf(_SC_OPEN_MAX), and allows much saner behavior on platforms where open-file slots are used up by semaphores. Tom Lane 2004-02-23 20:46:16 +00:00
  • f83356c7f5 Do a direct probe during postmaster startup to determine the maximum number of openable files and the number already opened. This eliminates depending on sysconf(_SC_OPEN_MAX), and allows much saner behavior on platforms where open-file slots are used up by semaphores. Tom Lane 2004-02-23 20:45:59 +00:00
  • fd7d98a271 Fixed incorrect output of indicator structs using the name of the data struct. Michael Meskes 2004-02-23 18:14:30 +00:00
  • b4c8dcb294 Fixed incorrect output of indicator structs using the name of the data struct. Michael Meskes 2004-02-23 18:14:18 +00:00
  • 6b7763d1c1 Write #include <dl.h>, not #include "dl.h", to correctly reflect the fact that dl.h is a system header and not one of ours. Tom Lane 2004-02-23 04:11:10 +00:00
  • 780cba9880 Move responsibility for copying argv[] array into ps_status.c, where it logically belongs. Arrange to update the _NSGetArgv() copy of the argv pointer on Darwin. (It seems likely that other NeXT-derived platforms also have an _NSGetArgv() problem, but until we have some reports I'll just make this #ifdef __darwin__.) Tom Lane 2004-02-22 21:26:55 +00:00
  • 45f5eba90b Document the family() function (added during the 7.4 dev cycle but not documented), and fix a typo. Neil Conway 2004-02-22 04:14:06 +00:00
  • a81b9d679f Fix random build breakage from log_disconnections patch. Tom Lane 2004-02-21 06:29:58 +00:00
  • 41d9c5e067 The following bug has been logged online: Bruce Momjian 2004-02-21 03:48:55 +00:00
  • 8c99671a3b Implement a solution to the 'Turkish locale downcases I incorrectly' problem, per previous discussion. Make some additional changes to centralize the knowledge of just how identifier downcasing is done, in hopes of simplifying any future tweaking in this area. Tom Lane 2004-02-21 00:35:13 +00:00
  • 59f9a0b9df Implement a solution to the 'Turkish locale downcases I incorrectly' problem, per previous discussion. Make some additional changes to centralize the knowledge of just how identifier downcasing is done, in hopes of simplifying any future tweaking in this area. Tom Lane 2004-02-21 00:34:53 +00:00
  • 1d567aee07 The following bug has been logged online: Bruce Momjian 2004-02-20 20:42:29 +00:00
  • 0d02533943 Add: Bruce Momjian 2004-02-20 20:37:11 +00:00
  • e53c56d34a Add: Bruce Momjian 2004-02-20 18:45:35 +00:00
  • 5e4b9d1ef0 Add to PL/java description. Bruce Momjian 2004-02-20 18:31:03 +00:00
  • 4b39aa3a7c Re-implement psql's input scanning to use a flex-generated lexer, as per recent discussion. The lexer is used for both SQL command text and backslash commands. The purpose of this change is to make it easier to track the behavior of the backend's SQL lexer --- essentially identical flex rules are now used by psql. Also, this cleans up a lot of very squirrelly code in mainloop.c and command.c. The flex code is somewhat bulkier than the removed code, but should be lots easier to maintain. Tom Lane 2004-02-19 19:40:09 +00:00
  • 737f1cd44b Cosmetic changes (mostly whitespace) to make it easier to diff the backend lexer against psql's. Tom Lane 2004-02-19 19:11:30 +00:00
  • 2e3d5f1160 Update: Bruce Momjian 2004-02-18 21:42:22 +00:00
  • af3b182a57 Here is a patch that implements setitimer() on win32. With this patch applied, deadlock detection and statement_timeout now works. Bruce Momjian 2004-02-18 16:25:12 +00:00
  • f8257734e4 Added missing rule for DOUBLE variables. Michael Meskes 2004-02-18 08:42:02 +00:00
  • 4553e1d80f Improve the consistency of the error message emitted when rejecting invalid input to the oid type. Also, remove some long-unused code from adt/numutils.c Neil Conway 2004-02-18 00:01:34 +00:00
  • afcc6fbb60 Remove a caveat from the "backup" documentation: pg_dump now does a better job of handling dependencies between database objects. Neil Conway 2004-02-17 23:56:07 +00:00
  • 0128c17c93 Done: > * -Change CVS ID to PostgreSQL Bruce Momjian 2004-02-17 15:46:44 +00:00
  • e170701712 Add: Bruce Momjian 2004-02-17 15:37:48 +00:00
  • 9c8d5f0be1 Add a few more <xref> tags to the SGML docs, where appropriate. Original patch from Michael Glaesemann, additional changes by Neil Conway. Neil Conway 2004-02-17 09:07:16 +00:00
  • d46b1f904e Minor editorializing on cost-based vacuum description. Tom Lane 2004-02-17 07:36:47 +00:00
  • ee33fe889e Significant improvements to the documentation for the new cost-based vacuum delay feature, including updating the docs for Tom's recent improvements. There is still more work to be done here: for example, adding some more information on the practical use of cost-based vacuum delay to the "maintenance" section would probably be a good idea. Neil Conway 2004-02-17 06:28:05 +00:00
  • 11acc1ffd6 Fix a minor SGML markup infelicity in recently-applied log_disconnections patch. Neil Conway 2004-02-17 05:45:17 +00:00
  • 530570c598 Rename function log_session_end to log_disconnections. Bruce Momjian 2004-02-17 04:09:26 +00:00
  • 96f134550c Fix prototype for on_proc_exit in log_disconnections patch. Bruce Momjian 2004-02-17 04:06:26 +00:00
  • c53611e3e7 This patch brings up to date what I did last year (now unfortunately bitrotted) to allow the logging of the end of a session, enabled by the config setting "log_disconnections". Bruce Momjian 2004-02-17 03:54:57 +00:00
  • 1f17316a3d Here is an updated version of the win32 readdir patch. Bruce Momjian 2004-02-17 03:45:17 +00:00
  • ec6feaaed4 Under Win32, stat() returns an st_ino field, but it has no meaning (on Win2K, and possibly all Win32 variants, it is always 0). This causes a number of problems in the dfmgr.c logic, which basically all revolve around the fact that *any* two files will appear to have the same inode. Bruce Momjian 2004-02-17 03:35:57 +00:00
  • 51b363ec24 Please apply this patch to contrib/dbmirror In incorperates changes from myself and a number of contributors. Bruce Momjian 2004-02-17 03:34:35 +00:00
  • 6dfb2b2517 Minor SGML markup improvements. Neil Conway 2004-02-17 02:53:03 +00:00
  • a536ed53bc Make use of statistics on index expressions. There are still some corner cases that could stand improvement, but it does all the basic stuff. A byproduct is that the selectivity routines are no longer constrained to working on simple Vars; we might in future be able to improve the behavior for subexpressions that don't match indexes. Tom Lane 2004-02-17 00:52:53 +00:00
  • d372bba02d Change may -> might, and remove an extra tab. Bruce Momjian 2004-02-16 23:07:57 +00:00
  • f464ad0bfd - Cleaned up parser a little bit. It does not make sense to allow a typename to be typedef'ed that cannot be parsed as variable type. - Allowed some SQL keywords to be used as C variable names. Michael Meskes 2004-02-16 07:41:54 +00:00
  • f0c9397f80 First steps towards statistics on expressional (nee functional) indexes. This commit teaches ANALYZE to store such stats in pg_statistic, but nothing is done yet about teaching the planner to use 'em. Also, repair longstanding oversight in separate ANALYZE command: it updated the pg_class.relpages and reltuples counts for the table proper, but not for indexes. Tom Lane 2004-02-15 21:01:39 +00:00
  • 4b8f125973 New translation Peter Eisentraut 2004-02-15 19:38:29 +00:00
  • fe92ed8b78 - Allowed some C keywords to be used as SQL column names. This used to work in 7.3.* Michael Meskes 2004-02-15 15:40:54 +00:00
  • 2a545255cf - Allowed some C keywords to be used as SQL column names. Michael Meskes 2004-02-15 15:38:20 +00:00
  • 67893da1c1 - Added missing braces to array parsing. - Set ecpg version to 3.1.1. - Removed that old debugging output that I forgot the last time. Michael Meskes 2004-02-15 13:50:02 +00:00
  • a05977edd9 - Added missing braces to array parsing. - Set ecpg version to 3.1.1. - Removed that old debugging output that I forgot the last time. Michael Meskes 2004-02-15 13:48:54 +00:00
  • effd0dea7e Minor documentation tweak. Neil Conway 2004-02-15 06:27:37 +00:00
  • a9e08392dd Create crosstype comparison operators for date vs. timestamp and date vs. timestamptz. This allows use of indexes for expressions like datecol >= date 'today' - interval '1 month' which were formerly not indexable without casting the righthand side down from timestamp to date. Tom Lane 2004-02-14 20:16:18 +00:00
  • 0d4c8f26ae Repair optimization bug I introduced in a moment of brain fade back in Nov 2002: when constant-expression simplification removes all the aggregate function calls from a query, that doesn't mean we can act as though there never were any aggregates. Per bug report from Gabor Szucs. Tom Lane 2004-02-13 22:26:43 +00:00
  • 2e5fe483a3 Repair optimization bug I introduced in a moment of brain fade back in Nov 2002: when constant-expression simplification removes all the aggregate function calls from a query, that doesn't mean we can act as though there never were any aggregates. Per bug report from Gabor Szucs. Tom Lane 2004-02-13 22:26:30 +00:00
  • f884090371 Documentation for vacuum_cost config options. Jan Wieck 2004-02-13 12:25:09 +00:00
  • 8787bc8ef3 After further thought about support for gathering stats on functional indexes, it seems like we ought to put another layer of indirection between the compute_stats functions and the actual data storage. This would allow us to compute the values on-the-fly, for example. Tom Lane 2004-02-13 06:39:49 +00:00
  • 1a4652333b Mention psql variable names are case-sensitive. Bruce Momjian 2004-02-13 05:10:02 +00:00
  • 72509752df Fix typo: Bruce Momjian 2004-02-13 04:47:13 +00:00
  • 3d6dabfc70 Tom Lane wrote: > momjian@svr1.postgresql.org (Bruce Momjian) writes: >> someone asked me about the FK deadlock fix, mentioned in the 7.3.3 >> release notes as 3rd change: >> http://www.postgresql.org/docs/current/static/release-7-3-3.html >> Actually, that fix was available with 7.4, not 7.3. Don't know if we can >> retroactively change the release-notes though. > > This is completely erroneous, please undo it. > > 2003-05-21 14:14 tgl > > * src/: backend/utils/adt/ri_triggers.c, > test/regress/expected/foreign_key.out (REL7_3_STABLE): Back-patch > Jan's fix to avoid primary key lookup (and lock) if foreign key > does not change on UPDATE. Bruce Momjian 2004-02-13 04:40:43 +00:00
  • 1decc208ac Tom Lane wrote: > momjian@svr1.postgresql.org (Bruce Momjian) writes: >> someone asked me about the FK deadlock fix, mentioned in the 7.3.3 >> release notes as 3rd change: >> http://www.postgresql.org/docs/current/static/release-7-3-3.html >> Actually, that fix was available with 7.4, not 7.3. Don't know if we can >> retroactively change the release-notes though. > > This is completely erroneous, please undo it. > > 2003-05-21 14:14 tgl > > * src/: backend/utils/adt/ri_triggers.c, > test/regress/expected/foreign_key.out (REL7_3_STABLE): Back-patch > Jan's fix to avoid primary key lookup (and lock) if foreign key > does not change on UPDATE. Bruce Momjian 2004-02-13 04:40:06 +00:00
  • 1e376bfb5e Add: Bruce Momjian 2004-02-13 04:36:02 +00:00
  • 65010e34e0 Add: Bruce Momjian 2004-02-13 02:30:53 +00:00
  • 96656f7dd7 Try to make 'cross-database references are not implemented' errors a bit more helpful by identifying the specific qualified name being complained of. Tom Lane 2004-02-13 01:08:20 +00:00
  • 69946411d3 Add hooks for type-specific calculation of ANALYZE statistics. Idea and coding by Mark Cave-Ayland, some kibitzing by Tom Lane. initdb forced due to new column in pg_type. Tom Lane 2004-02-12 23:41:04 +00:00
  • d27471fe0a Add from Joe Conway: Bruce Momjian 2004-02-12 23:27:52 +00:00
  • 565606654a Add CVS ID tags to port/win32/files. Bruce Momjian 2004-02-12 20:37:34 +00:00
  • c37a75a529 Jan: Bruce Momjian 2004-02-12 20:18:13 +00:00
  • e850e30fc8 Jan: Bruce Momjian 2004-02-12 20:17:34 +00:00
  • da99cce7cd Avoid delaying postmaster shutdown by up to 10 seconds on platforms where signals do not terminate sleep() delays. Tom Lane 2004-02-12 20:07:26 +00:00
  • 4a1c29f87e Improve \? wording, remove 'internal'. Bruce Momjian 2004-02-12 19:58:16 +00:00
  • c60128e54b Translation updates Peter Eisentraut 2004-02-12 19:19:32 +00:00
  • f8cdde14da Translation updates Peter Eisentraut 2004-02-12 19:17:41 +00:00
  • 6a13bdd8f3 Add bitmap discussion to performance TODO.detail. Bruce Momjian 2004-02-12 18:13:29 +00:00
  • 2b721d3d41 Remove TODO.detail files that contained useless or very old information. Update TODO accordingly. Bruce Momjian 2004-02-12 18:11:54 +00:00
  • 5de02e283f Done: Bruce Momjian 2004-02-12 18:11:16 +00:00
  • b3efb9f037 File not needed: Bruce Momjian 2004-02-12 18:09:43 +00:00
  • b8369db5fc Mostly done: Bruce Momjian 2004-02-12 18:05:51 +00:00
  • f66f437fac File not needed: Bruce Momjian 2004-02-12 18:01:20 +00:00
  • b23d694544 Remove: Bruce Momjian 2004-02-12 17:59:50 +00:00
  • db55d7a212 Merge files: Bruce Momjian 2004-02-12 17:51:03 +00:00
  • b4c0b196fb Not needed: Bruce Momjian 2004-02-12 17:38:50 +00:00
  • b3fbb4b801 Not needed: Bruce Momjian 2004-02-12 17:32:38 +00:00
  • ebf4bb7f2e Not needed: Bruce Momjian 2004-02-12 17:31:09 +00:00
  • de4b486eed Remove crossdb content. Bruce Momjian 2004-02-12 17:23:30 +00:00
  • fbfc9dc20b Add, dblink doesn't do this: Bruce Momjian 2004-02-12 17:22:39 +00:00
  • 329207e817 Done, mostly by dblink, I think: Bruce Momjian 2004-02-12 17:21:41 +00:00
  • 209e866a5a Fix typo: Bruce Momjian 2004-02-12 16:38:04 +00:00
  • 43d37a81dd Add: < > * Allow substring/replace() to get/set bit values Bruce Momjian 2004-02-12 16:05:15 +00:00
  • fc65a3e1fd Fixed bug where FlushRelationBuffers() did call StrategyInvalidateBuffer() for already empty buffers because their buffer tag was not cleard out when the buffers have been invalidated before. Jan Wieck 2004-02-12 15:06:56 +00:00
  • 76f02b51b6 Remove URL for specific pljava implementation: Bruce Momjian 2004-02-12 14:41:13 +00:00
  • 7bed6df184 Check only live tuples for OID validity, to avoid issues after ALTER TABLE. Per recent discussion. Tom Lane 2004-02-12 05:39:55 +00:00
  • 1ecd035b31 Added hints about the reason, why the command string in the view pg_stat_activity is missing, as per Bruces suggestion. Jan Wieck 2004-02-12 01:44:22 +00:00
  • c3c09be34b Commit the reasonably uncontroversial parts of J.R. Nield's PITR patch, to wit: Add a header record to each WAL segment file so that it can be reliably identified. Avoid splitting WAL records across segment files (this is not strictly necessary, but makes it simpler to incorporate the header records). Make WAL entries for file creation, deletion, and truncation (as foreseen but never implemented by Vadim). Also, add support for making XLOG_SEG_SIZE configurable at compile time, similarly to BLCKSZ. Fix a couple bugs I introduced in WAL replay during recent smgr API changes. initdb is forced due to changes in pg_control contents. Tom Lane 2004-02-11 22:55:26 +00:00
  • 0cb117eb33 Repair some problems in bgwriter start/stop logic. In particular, don't allow the bgwriter to start before the startup subprocess has finished ... it tends to crash otherwise. (The same problem may have existed for the checkpointer, I'm not entirely sure.) Remove some code that was redundant because the bgwriter is handled as a member of the backend list. Tom Lane 2004-02-11 22:25:02 +00:00
  • 3b6bf0c07d Add: Bruce Momjian 2004-02-11 22:04:35 +00:00
  • c6f0559371 Check and set thread-safe functions separately, rather than as a single variable. Bruce Momjian 2004-02-11 21:44:06 +00:00
  • 29760bbdaf Properly set NEED_REENTRANT_FUNCS for threaded libpq/ecpg. Bruce Momjian 2004-02-11 17:32:09 +00:00
  • 15b330b648 Properly set NEED_REENTRANT_FUNCS for threaded libpq/ecpg. Bruce Momjian 2004-02-11 17:29:01 +00:00
  • ac4ad7bf2c Does not apply anymore: Bruce Momjian 2004-02-11 17:04:04 +00:00
  • 94a67cce7e No need to link libpq into these programs ... Tom Lane 2004-02-10 23:24:13 +00:00