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

Commit Graph

  • 457f0b8919 Add fulltextindex TODO list. Bruce Momjian 2000-12-09 15:52:11 +00:00
  • 9ed7237110 Update FAQ_DEV. Bruce Momjian 2000-12-09 04:57:31 +00:00
  • a860a403a9 Fix a bug in conversion from big5 to EUC_TW (CNS 11643-1992 Plane 3) Thanks Chih-Chang Hsieh <cch@cc.kmu.edu.tw> for finding the bug. Tatsuo Ishii 2000-12-09 04:30:04 +00:00
  • 5dd9fc724e Update FAQ_DEV. Bruce Momjian 2000-12-09 04:29:43 +00:00
  • 5eced96f2c Update FAQ. Bruce Momjian 2000-12-09 04:29:38 +00:00
  • cfe26c0fb1 Fix a bug in conversion from big5 to EUC_TW (CNS 11643-1992 Plane 3) Thanks Chih-Chang Hsieh <cch@cc.kmu.edu.tw> for finding the bug. Tatsuo Ishii 2000-12-09 04:27:36 +00:00
  • 376784cf8a Repair erroneous use of hashvarlena() for MACADDR, which is not a varlena type. (I did not force initdb, but you won't see the fix unless you do one.) Also, make sure all index support operators and functions are careful not to leak memory for toasted inputs; I had missed some hash and rtree support ops on this point before. Tom Lane 2000-12-08 23:57:03 +00:00
  • fb47385fc8 Resurrect -F switch: it controls fsyncs again, though the fsyncs are mostly just on the WAL logfile nowadays. But if people want to disable fsync for performance, why should we say no? Tom Lane 2000-12-08 22:21:33 +00:00
  • 57c499a463 Fix Westwood/Westward, from Wessel van Norel. Bruce Momjian 2000-12-08 20:11:11 +00:00
  • 90bdb64be8 Add missing copyright and RCS identification header. Tom Lane 2000-12-08 20:10:19 +00:00
  • b44e46cfce Remove error check that disallowed setval() on a sequence with cache value greater than one. The behavior this sought to disallow doesn't seem any less confusing than the other behaviors of cached sequences. Improve wording of some error messages, too. Update documentation accordingly. Also add an explanation that aborted transactions do not roll back their nextval() calls; this seems to be a FAQ, so it ought to be mentioned here... Tom Lane 2000-12-08 20:06:58 +00:00
  • ce1748406b Cache invalidation for vacuum of system tables. Hiroshi Inoue 2000-12-08 06:43:44 +00:00
  • d7892e0263 REINDEX under WAL. Hiroshi Inoue 2000-12-08 06:17:58 +00:00
  • 8d7c0851a3 Improve error message for erroneous use of 'opaque' as plperl argument or return type. Tom Lane 2000-12-08 00:11:55 +00:00
  • 6e646c7313 Improve error message for erroneous use of 'opaque' as pltcl argument or return type. Tom Lane 2000-12-08 00:09:07 +00:00
  • 74c14995f1 Improve error message for erroneous use of 'opaque' as plpgsql argument or return type. Tom Lane 2000-12-08 00:03:02 +00:00
  • 2a7a75ee7e Change lpad() and rpad() to behave more Oracle-compatibly when target length is less than original string length. Tom Lane 2000-12-07 23:22:56 +00:00
  • 288afd95a3 typo correction Peter Eisentraut 2000-12-07 22:37:08 +00:00
  • 289e6fd2a4 Do not use 'ar cq' to build library archives, use 'ar cr' instead. Peter Eisentraut 2000-12-07 19:43:49 +00:00
  • cbc5f4f127 checkretval() failed to cope with an empty SQL function body. Tom Lane 2000-12-07 19:40:56 +00:00
  • 821f4673ff Make OVERLAPS operators conform to SQL92 spec regarding NULL handling. As I read it, the spec requires a non-null result in some cases where one of the inputs is NULL: specifically, if the other endpoint of that interval is between the endpoints of the other interval, then the result is known TRUE despite the missing endpoint. The spec could've been a lot simpler if they did not intend this behavior. I did not force an initdb for this change, but if you don't do one you'll still see the old strict-function behavior. Tom Lane 2000-12-07 18:38:59 +00:00
  • 8bb4dab94d RecordTransactionAbort() shouldn't log XLOG_XACT_ABORT if the transaction has already been committed ? Hiroshi Inoue 2000-12-07 10:03:46 +00:00
  • 5cf81b3c06 Silence compiler warning. Tom Lane 2000-12-07 02:52:27 +00:00
  • 06dde51ef0 Silence compiler warning. Tom Lane 2000-12-07 02:04:30 +00:00
  • 7711e40b9f Make application of FOR UPDATE to a view work exactly like the parser's transformForUpdate does: it should recurse into subqueries. Tom Lane 2000-12-07 01:22:25 +00:00
  • 0a844e84a1 transformForUpdate() mustn't assume rowMarks list is initially empty. It could be recursing into a sub-query where there was already a FOR UPDATE clause. Tom Lane 2000-12-07 01:12:08 +00:00
  • 73d2a3595a Clean up handling of FOR UPDATE inside views and subselects ... make it work where we can (given that the executor only handles it at top level) and generate an error where we can't. Note that while the parser has been allowing views to say SELECT FOR UPDATE for a few weeks now, that hasn't actually worked until just now. Tom Lane 2000-12-06 23:55:19 +00:00
  • db0de2241d update VERSION to 7.1beta1.. Marc G. Fournier 2000-12-06 20:26:53 +00:00
  • ecab48f5ec -L linker options are now in LDFLAGS, not LIBS. The word hadn't gotten through to here yet. Peter Eisentraut 2000-12-06 19:37:08 +00:00
  • 5fb1022212 Don't include miscadmin.h in elog.h, since the former is not part of the installed header file set. Tom Lane 2000-12-06 17:25:46 +00:00
  • a0f863637f I've just seen what happens when the MEMORY_CONTEXT_CHECKING code fires an error at end of transaction ... and I did *not* like it. Reduce ERROR to NOTICE so that this situation doesn't cause an infinite loop. Tom Lane 2000-12-05 23:40:36 +00:00
  • 614d951a54 In SELECT FOR UPDATE, silently ignore null CTIDs, rather than generating an error as we used to. In an OUTER JOIN scenario, retrieving a null CTID from one of the input relations is entirely expected. We still want to lock the input rows from the other relations, so just ignore the null and keep going. Tom Lane 2000-12-05 22:03:57 +00:00
  • 981a7d32d1 From Stephan Szabo: I believe this should fix the issue that Philip Warner noticed about the check for unique constraints meeting the referenced keys of a foreign key constraint allowing the specification of a subset of a foreign key instead of rejecting it. I also added tests for a base case of this to the foreign key and alter table tests and patches for expected output. Tom Lane 2000-12-05 19:57:56 +00:00
  • 5ce8ab96f5 Add regress test case for INSERT ... SELECT in rules. Tom Lane 2000-12-05 19:15:49 +00:00
  • a51f004d29 Repair breakage of rules containing INSERT ... SELECT actions, per bug report from Joel Burton. Turns out that my simple idea of turning the SELECT into a subquery does not interact well *at all* with the way the rule rewriter works. Really what we need to make INSERT ... SELECT work cleanly is to decouple targetlists from rangetables: an INSERT ... SELECT wants to have two levels of targetlist but only one rangetable. No time for that for 7.1, however, so I've inserted some ugly hacks to make the rewriter know explicitly about the structure of INSERT ... SELECT queries. Ugh :-( Tom Lane 2000-12-05 19:15:10 +00:00
  • d9466046c0 Fix bogus makefiles ... these didn't build on platforms that are sticky about being given accurate references to referenced libraries ... REL7_1_BETA Tom Lane 2000-12-04 01:32:19 +00:00
  • 74b8fe1717 Seems to have been missed in GetPgUserName updates. Tom Lane 2000-12-04 01:25:35 +00:00
  • 7a4cc54e58 Eliminate some of the more blatant platform-dependencies ... it builds here now, anyway ... Tom Lane 2000-12-04 01:20:38 +00:00
  • 2bf2ee7814 Seems like make clean or make distclean should clean out contrib directories too, not only src and doc. Tom Lane 2000-12-04 00:34:40 +00:00
  • 3d0e49623b corrections Peter Eisentraut 2000-12-03 21:12:19 +00:00
  • a27b691e29 Ensure that all uses of <ctype.h> functions are applied to unsigned-char values, whether the local char type is signed or not. This is necessary for portability. Per discussion on pghackers around 9/16/00. Tom Lane 2000-12-03 20:45:40 +00:00
  • 4d2a506526 Update for new tests. These are extrapolations and will need to be confirmed correct on the relevant platforms. Tom Lane 2000-12-03 17:53:26 +00:00
  • f3e988443c Update for new tests. Tom Lane 2000-12-03 17:37:26 +00:00
  • 68ed296301 Don't use 'private' as a parameter name in visible headers ... makes C++ very unhappy ... Tom Lane 2000-12-03 17:18:10 +00:00
  • e7c80220d3 Fix counting of lines in scripts with 'copy from stdin'. Peter Eisentraut 2000-12-03 15:39:38 +00:00
  • 6969b8fa11 Repair usage of the OVERLAPS operator. Allow some operator-like tokens to be used as function names. Flesh out support for time, timetz, and interval operators and interactions. Regression tests pass, but non-reference-platform horology test results will need to be updated. Thomas G. Lockhart 2000-12-03 14:51:12 +00:00
  • 1131261270 Clarify the allowed length of the text data type. Thomas G. Lockhart 2000-12-03 14:47:18 +00:00
  • 20efb264f6 Convert files from DOS format to normal text. Thomas G. Lockhart 2000-12-03 14:43:59 +00:00
  • 48781d44e4 Support IBM S/390. Patches from Neale Ferguson@softwareAG-usa.com. Thomas G. Lockhart 2000-12-03 14:41:47 +00:00
  • 13dbd0276a Final(?) GUC clean-up. Update psql tab completion. Peter Eisentraut 2000-12-03 14:36:47 +00:00
  • 65b362fae1 Disable elog(ERROR|FATAL) in signal handlers in critical sections of code. Vadim B. Mikheev 2000-12-03 10:27:29 +00:00
  • 5e3bc5ebcd Avoid memory leakage during regular COPY when outputting toasted values. COPY BINARY is still broken for toasted data, however. Tom Lane 2000-12-02 20:49:24 +00:00
  • 77698e11a9 Avoid repeated detoasting (and possible memory leaks) when processing a toasted datum in VACUUM ANALYZE. Tom Lane 2000-12-02 19:38:34 +00:00
  • 079c60abc0 Don't cause --enable-cassert to define COPY_PARSE_PLAN_TREES automatically anymore. That won't teach us anything new for the rest of this release cycle, so it seems better to keep the --assert environment more like the non-assert environment for beta. I'm going to leave CLOBBER_FREED_MEMORY and MEMORY_CONTEXT_CHECKING turned on by --enable-cassert for now, however. Tom Lane 2000-12-02 18:16:40 +00:00
  • 217d1566bf Make tuple receive/print routines TOAST-aware. Formerly, printtup would leak memory when printing a toasted attribute, and printtup_internal didn't work at all... Tom Lane 2000-12-01 22:10:31 +00:00
  • f5371feef9 Fix inadequate tree-walking code in exec_eval_clear_fcache. Tom Lane 2000-12-01 20:43:59 +00:00
  • 08ede423d1 Make elog() switch to ErrorContext while invoking libpq output routines, since those routines may do palloc's. We want to be fairly sure we can send the error message to the client even under low-memory conditions. That's what we stashed away 8K in ErrorContext for, after all ... Tom Lane 2000-12-01 19:52:04 +00:00
  • a49436d7e9 Pursuant to a pghackers discussion back around 11-Jul-00, get rid of aset.c's not-very-good handling of mid-size allocation requests. Do everything via either the "small" case (chunk size rounded up to power of 2) or the "large" case (pass it straight off to malloc()). Increase the number of freelists a little to set the breakpoint between these behaviors at 8K. Tom Lane 2000-12-01 18:14:29 +00:00
  • eb743d0f98 It seems appropriate that the extended MEMORY_CONTEXT_CHECKING code immediately uncovered three of Karel's own bugs, including a routine that scribbled on its input (naughty naughty!) Tom Lane 2000-12-01 05:17:19 +00:00
  • dd2b56d623 Clean up MEMORY_CONTEXT_CHECKING code, and apply it more thoroughly. Also, apply Karel Zak's patch to recycle residual space in an exhausted allocation block. (Bet you thought I'd forgot about that, Karel?) Tom Lane 2000-12-01 05:16:45 +00:00
  • b7c3784417 Repair residual sillinesses from UUNET virtual host/socket path patch. I hope all the dust has settled out now ... Tom Lane 2000-11-30 23:20:51 +00:00
  • 73d0514dea Make default socket directory location configurable from config.h. If we're going to let it be run-time configurable, might as well allow this too... Tom Lane 2000-11-30 23:19:04 +00:00
  • 796754778d Correct obsolete entry for strpos(). Tom Lane 2000-11-30 23:02:04 +00:00
  • 6f09df7f40 Minor tweaks in installation instructions, regenerate INSTALL file. Peter Eisentraut 2000-11-30 21:44:07 +00:00
  • 37b7d5c39e Remove DISABLE_COMPLEX_MACRO definitions, since people seem to be getting by without them. Peter Eisentraut 2000-11-30 21:16:12 +00:00
  • bf14fb8fa3 Remove old regression test drivers. Peter Eisentraut 2000-11-30 20:43:31 +00:00
  • e5ba2fc5b5 Make all commands that link a program look like Peter Eisentraut 2000-11-30 20:36:13 +00:00
  • 309112267f misc Vadim B. Mikheev 2000-11-30 19:06:37 +00:00
  • 8247f47fc7 Hope that this is valid localbuf.c version Vadim B. Mikheev 2000-11-30 19:03:26 +00:00
  • b73ecebf05 Remove obsolete claim that char(n) is more efficient than other text types. Tom Lane 2000-11-30 18:46:42 +00:00
  • 1f5cc8c78a Remove VARLENA_FIXED_SIZE hack, which is irreversibly broken now that both MULTIBYTE and TOAST prevent char(n) from being truly fixed-size. Simplify and speed up fastgetattr() and index_getattr() macros by eliminating special cases for attnum=1. It's just as fast to handle the first attribute by presetting its attcacheoff to zero; so do that instead when loading the tupledesc in relcache.c. Tom Lane 2000-11-30 18:38:47 +00:00
  • 59a9735fc8 Sort out things after fe-connect.c cleanup after unix socket patch. Peter Eisentraut 2000-11-30 18:34:36 +00:00
  • ef54e0d08e Remove remaining unixsocket-setting interfaces, since the host parameter does that. Disable URL-style connection parameter specification code, which doesn't work. Peter Eisentraut 2000-11-30 18:32:52 +00:00
  • 81c8c244b2 No more #ifdef XLOG. Vadim B. Mikheev 2000-11-30 08:46:26 +00:00
  • b16516b887 It seems some platforms declare kill(2) in signal.h not unistd.h. Tom Lane 2000-11-30 03:11:24 +00:00
  • 741510521c XLOG stuff for sequences. CommitDelay in guc.c Vadim B. Mikheev 2000-11-30 01:47:33 +00:00
  • 680b7357ce Rearrange bufmgr header files so that buf_internals.h need not be included by everything that includes bufmgr.h --- it's supposed to be internals, after all, not part of the API! This fixes the conflict against FreeBSD headers reported by Rosenman, by making it unnecessary for s_lock.h to be included by plperl.c. Tom Lane 2000-11-30 01:39:08 +00:00
  • 9f20852f87 all options are allowed if not under postmaster: Vadim B. Mikheev 2000-11-30 01:27:19 +00:00
  • 3c0f3c9a7e Just noticed that with -S switch, MyProcPid is permanently wrong in postmaster, because it isn't updated after forking away from the terminal. Apparently it's not used anyplace in the postmaster ... but seems best to make it show the correct PID ... Tom Lane 2000-11-29 22:04:04 +00:00
  • 792b0f4666 Get rid of not-very-portable fcntl(F_SETLK) mechanism for locking the Unix socket file, in favor of having an ordinary lockfile beside the socket file. Clean up a few robustness problems in the lockfile code. If postmaster is going to reject a connection request based on database state, it will now tell you so before authentication exchange not after. (Of course, a failure after is still possible if conditions change meanwhile, but this makes life easier for a yet-to-be-written pg_ping utility.) Tom Lane 2000-11-29 20:59:54 +00:00
  • 1efd7330cb Rewrite system catalog documentation man page in DocBook with more recent information. Peter Eisentraut 2000-11-29 20:15:59 +00:00
  • 175f52083b aclitemout() shouldn't coredump when it finds an ACL item for a now-vanished group. Instead, display the numeric group ID, same as it does for vanished users. Tom Lane 2000-11-28 23:42:31 +00:00
  • c715fdea26 Significant cleanups in SysV IPC handling (shared mem and semaphores). IPC key assignment will now work correctly even when multiple postmasters are using same logical port number (which is possible given -k switch). There is only one shared-mem segment per postmaster now, not 3. Rip out broken code for non-TAS case in bufmgr and xlog, substitute a complete S_LOCK emulation using semaphores in spin.c. TAS and non-TAS logic is now exactly the same. When deadlock is detected, "Deadlock detected" is now the elog(ERROR) message, rather than a NOTICE that comes out before an unhelpful ERROR. Tom Lane 2000-11-28 23:27:57 +00:00
  • 914822713c Remove PQunixsocket from dll file. Bruce Momjian 2000-11-28 07:27:01 +00:00
  • 0791b6de51 Remove PQunixsocket prototype Bruce Momjian 2000-11-28 07:25:08 +00:00
  • 5173fc411f Remove PQunixsocket, per Peter's recommendation. PQhost shows the socket directory. Bruce Momjian 2000-11-28 06:53:33 +00:00
  • 811749bb6e Update TODO list. Bruce Momjian 2000-11-27 21:16:10 +00:00
  • f6a756e49a Make PQhost return socket path. Bruce Momjian 2000-11-27 21:12:25 +00:00
  • 6f11e6dffa This patch allow pg_dump save name of primary key constraint (if primary key exist). Bruce Momjian 2000-11-27 20:51:40 +00:00
  • 579f8f09fa Added pg_execute command behaving like spi_exec of PL/Tcl Jan Wieck 2000-11-27 13:29:32 +00:00
  • 230cf8d373 Check for link(2) failure. Tom Lane 2000-11-27 05:36:12 +00:00
  • 9ee598e0ee Not invoke CheckPoint process while postmaster is waiting for all backends to die. Hiroshi Inoue 2000-11-27 04:03:20 +00:00
  • c6f0bff1f1 Pay attention to fgets() failure return. Tom Lane 2000-11-27 03:58:58 +00:00
  • c5bbbb2845 Pay attention to fgets() failure return. Tom Lane 2000-11-27 03:53:13 +00:00
  • a568b2273c Be a little more careful with strtok(). Tom Lane 2000-11-27 03:46:01 +00:00
  • f749b4ca9c Pay attention to fgets() failure return. Tom Lane 2000-11-27 03:43:49 +00:00
  • 92fd384779 After going to the trouble of finding where psql lives, seems like pg_ctl should invoke it from there, not use whatever random psql might (or might not) live in its $PATH. Tom Lane 2000-11-27 02:50:17 +00:00
  • 9c5327b99b Pay attention to failure returns from fgets() in all cases. Avoid infinite loop prompting for password at stdin EOF. Tom Lane 2000-11-27 02:20:36 +00:00
  • e8a72c0db2 Prevent simple_prompt() from locking up in a tight loop at stdin EOF. Tom Lane 2000-11-27 01:28:40 +00:00
  • 0a829cb865 current cvs tree does build because of a small problem in ECPG. Here is a little patch which correct that. Bruce Momjian 2000-11-26 20:45:19 +00:00