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

Commit Graph

  • 610abfd57b Do table renaming in a sane order: physical file rename must happen *last*, after all updating of system catalogs. In old code, an error detected during TypeRename left the relation hosed. Also, add a call to flush the relation's relcache entry, rather than trusting to shared cache invalidation to flush it for us. Tom Lane 2000-05-25 21:30:20 +00:00
  • 445f1acf7a heap_drop() should flush the relcache entry for the relation being dropped. Tom Lane 2000-05-25 21:25:32 +00:00
  • 69cc16f47e Quote database name so that not-all-lowercase names are handled safely. Tom Lane 2000-05-25 20:18:15 +00:00
  • 61f5e13c43 ! * Users doing non-blocking connections need to handle the reset ! * themselves, they'll need to check the connection status if we ! * return an error. Bruce Momjian 2000-05-25 19:09:55 +00:00
  • 936b27fa87 Update TODO list. Bruce Momjian 2000-05-25 16:10:01 +00:00
  • a802433917 Spell fix Bruce Momjian 2000-05-25 15:32:03 +00:00
  • 07d4d36aae On solaris, createdb/dropdb fails because of strange behavior of system(). (it returns error with errno ECHILD upon successful completion of commands). This fix ignores an error from system() if errno == ECHILD. Tatsuo Ishii 2000-05-25 06:53:43 +00:00
  • c439756ffd Make the world safe for QNX's busted shell ... Tom Lane 2000-05-24 22:43:59 +00:00
  • ae8a2c3589 Make the world safe for QNX's busted shell ... Tom Lane 2000-05-24 22:32:59 +00:00
  • 69b323f4bc add a --with-setproctitle switch to configure that leaves the use of setproctitle() disabled by default ... Marc G. Fournier 2000-05-24 14:58:21 +00:00
  • f19ae14612 Update so init displays status with setproctitle too, like the rest of them. Bruce Momjian 2000-05-24 00:24:17 +00:00
  • a267c88d3b Make setproctitle update for every query. Bruce Momjian 2000-05-24 00:14:26 +00:00
  • 962c258027 Comment out no-op ps updates for setproctitle(), until we figure out what to do. Bruce Momjian 2000-05-23 22:50:55 +00:00
  • d264fb4157 comment cleanup Bruce Momjian 2000-05-23 22:16:27 +00:00
  • 75478861a4 pg_ctl does not use -S by default anymore so update documentation Bruce Momjian 2000-05-23 21:46:57 +00:00
  • 1c5b902018 Fix problem in which sloppily-coded test in ExecInitIndexScan would think that both sides of indexqual look like index keys. An example is create table inside (f1 float8 primary key); create table outside (g1 float8, g2 float8); select * from inside,outside where f1 = atan2(g1+1, g2); ERROR: ExecInitIndexScan: both left and right ops are rel-vars (note that failure is potentially platform-dependent). Solution is a cleanup I had had in mind to make anyway: functional index keys should be represented as Var nodes in the fixed indexqual, just like regular index keys. Tom Lane 2000-05-23 16:56:37 +00:00
  • 1c8244ec67 Twiddle C++ configuration checks so that we #include <string> (if it exists) before testing 'using namespace std'. This is necessary on some C++ setups where the compiler won't take a 'using' until you've included a header that mentions namespace std. (Pretty braindead if you ask me, but...) Tom Lane 2000-05-23 04:55:44 +00:00
  • ac6637485b Transmit -I switches selected by configure (particularly those from --with-includes) to makefiles for pltcl and plperl, so that these switches will be used even though we do not want other top-level CFLAGS. Ain't it fun trying to support multiple-compiler platforms? Tom Lane 2000-05-23 02:12:46 +00:00
  • aca5b34427 Cast parameters to ckfree to (char *) to suppress compiler warnings. Tom Lane 2000-05-23 01:59:05 +00:00
  • b1b9059427 Irix fixes from Murad Nayal Bruce Momjian 2000-05-22 23:56:44 +00:00
  • 8ac35b3249 Reformatted the install file as it used to be Peter Eisentraut 2000-05-22 22:04:47 +00:00
  • 569a1431ca Cleanup Bruce Momjian 2000-05-22 02:41:39 +00:00
  • 0460f0502b I am attempting to integrate postgres (v 7.0) with an open source project I am working on (Recall - a distributed, fault-tolerant, replicated, storage framework @ http://www.fault-tolerant.org). Recall is written in C++. I need to include the postgres headers and there are some problems when including the headers w/C++. Bruce Momjian 2000-05-22 02:34:23 +00:00
  • 1f0aff03c0 Remove calls to getprotobyname(), which we now know leaks memory on some platforms --- and I also see that it is documented as not thread- safe on HPUX and possibly other platforms. No good reason not to just use IPPROTO_TCP constant from <netinet/in.h> instead. Tom Lane 2000-05-21 21:19:53 +00:00
  • 9dab9ab5e4 Repair memory leaks that caused CacheCxt to grow without bound. We really ought to fix relcache entry construction so that it does not do so much with CurrentMemoryContext = CacheCxt. As is, relatively harmless leaks in either sequential or index scanning translate to permanent leaks if they occur when called from relcache build. For the moment, however, the path of least resistance is to repair all such leaks... Tom Lane 2000-05-21 02:28:55 +00:00
  • aa16179118 Add debug code to aid in memory-leak tracking: if SHOW_MEMORY_STATS is defined then statistics about memory usage of all the global memory contexts are printed after each commit. Tom Lane 2000-05-21 02:23:30 +00:00
  • 25a7a7f446 Clean up grotty references to CacheCxt (externs inside functions, duplicate global declarations, no points for style at all!) Tom Lane 2000-05-20 23:11:29 +00:00
  • aa387054d2 Multibyte documentations update Tatsuo Ishii 2000-05-20 13:40:13 +00:00
  • 1a6daef70d Enhance multibyte support. SJIS UDC (NEC selection IBM kanji) support contributed by Eiji Tokuya Tatsuo Ishii 2000-05-20 13:12:26 +00:00
  • f1cb756c38 Add KEEPALIVE option to the socket of backend. This will automatically terminate the backend that has no frontend anymore. Tatsuo Ishii 2000-05-20 13:10:54 +00:00
  • 0d62ecdf72 Update rules man pages. Bruce Momjian 2000-05-20 11:38:25 +00:00
  • c99e851eea Clean up sql functions examples. Bruce Momjian 2000-05-20 11:24:37 +00:00
  • a9876533d6 Update TODO list. Bruce Momjian 2000-05-20 03:45:20 +00:00
  • 8b5b3e0011 pg_dump barfs on negative values for index column numbers --- like, say, an index on a table's OID column. Mea maxima culpa ... but how'd we get through beta with no one noticing this? Tom Lane 2000-05-19 23:00:00 +00:00
  • 4763cddaf5 Update TODO list. Bruce Momjian 2000-05-19 19:27:56 +00:00
  • f923260ec8 Revise FlushRelationBuffers/ReleaseRelationBuffers per discussion with Hiroshi. ReleaseRelationBuffers now removes rel's buffers from pool, instead of merely marking them nondirty. The old code would leave valid buffers for a deleted relation, which didn't cause any known problems but can't possibly be a good idea. There were several places which called ReleaseRelationBuffers *and* FlushRelationBuffers, which is now unnecessary; but there were others that did not. FlushRelationBuffers no longer emits a warning notice if it finds dirty buffers to flush, because with the current bufmgr behavior that's not an unexpected condition. Also, FlushRelationBuffers will flush out all dirty buffers for the relation regardless of block number. This ensures that pg_upgrade's expectations are met about tuple on-row status bits being up-to-date on disk. Lastly, tweak BufTableDelete() to clear the buffer's tag so that no one can mistake it for being a still-valid buffer for the page it once held. Formerly, the buffer would not be found by buffer hashtable searches after BufTableDelete(), but it would still be thought to belong to its old relation by the routines that sequentially scan the shared-buffer array. Again I know of no bugs caused by that, but it still can't be a good idea. Tom Lane 2000-05-19 03:22:31 +00:00
  • db90fdf9ab Correct busted syntax of CC invocation for tas.s. Tom Lane 2000-05-19 02:50:32 +00:00
  • e7be9d3303 Unset PGHOST Bruce Momjian 2000-05-18 16:11:39 +00:00
  • 6108a7ed6a Change remove function warning for built-ins. Bruce Momjian 2000-05-18 16:09:38 +00:00
  • 61f06bc2f1 Use postmaster -i only on certain platforms. Bruce Momjian 2000-05-18 15:58:43 +00:00
  • feaf1fc137 Throw NOTICE on built-in function removal Bruce Momjian 2000-05-18 15:45:00 +00:00
  • e17cfa8ff1 Add QNX localhost flag to regression tests Bruce Momjian 2000-05-18 15:37:56 +00:00
  • f63ba5cd6a Fix WARN->NOTICE in docs. Change libpgeasy connection parameters to use PQconnectdb() style connections. Bruce Momjian 2000-05-18 14:24:38 +00:00
  • ba26aeebc1 Reduce COPY IN lock from AccessExclusive to a more reasonable RowExclusive (my fault). Also, install a check to prevent people from trying COPY BINARY to stdout/from stdin. No way that will work unless we redesign the frontend COPY protocol ... which is not worth the trouble in the near future ... Tom Lane 2000-05-18 01:52:45 +00:00
  • 52d95db1a3 Update trigger.sgml Bruce Momjian 2000-05-17 18:30:02 +00:00
  • 21258c35a0 Clean up trigger sgml docs. Bruce Momjian 2000-05-17 17:44:13 +00:00
  • 362a0f68d9 The check of class string in configure (line 1732) fails because this class is in <string> and not in <string.h> on QNX4/egcs-2.91.60. Probably this can be changed for all platforms. The test in line 1705 uses <string> as well. Because I am not sure, I havn't this included into the patch. Bruce Momjian 2000-05-17 16:57:41 +00:00
  • a8020a78ec Back out odbc changes until 7.1. Bruce Momjian 2000-05-17 15:36:37 +00:00
  • e39a118694 *** empty log message *** Michael Meskes 2000-05-17 06:03:14 +00:00
  • 76da5b80b1 Change plpgsql example from SELECT * INTO rec to SELECT INTO rec *. Bruce Momjian 2000-05-17 00:15:48 +00:00
  • d446c129ac Fix typo Bruce Momjian 2000-05-16 21:16:12 +00:00
  • a47e20b049 Several compilation and run-time problems occur when building on SGI IRIX systems using the native compilers. A summary is: - Various files use "//" as a comment delimiter in c files. - Problems caused by assuming "char" is signed. cash.in: building -signed the rules regression test fails as described in FAQ_QNX4. If CHAR_MAX is "255U" then ((signed char)CHAR_MAX) is -1. postmaster.c: random number regression test failed without this change. - Some generic build issues and warning message cleanup. Bruce Momjian 2000-05-16 20:48:52 +00:00
  • 5128d145a8 Cleanup plpgsql man page typo Bruce Momjian 2000-05-16 19:29:43 +00:00
  • 21517e5960 The old init file won't run under bash on my box. Joseph Shraibman Bruce Momjian 2000-05-16 03:18:43 +00:00
  • 6dd06737ba Remove configure check for how to abbreviate 'tr A-Z a-z', and instead just use the portable form, tr ABCDEFGHIJKLMNOPQRSTUVWXYZ abcdefghijklmnopqrstuvwxyz There were a bunch of places that weren't paying attention to configure's result anyway (including configure itself!?); clean them up too. Tom Lane 2000-05-16 02:14:15 +00:00
  • 33bb1aee91 Fixed the message Makefile produces after compiling. It still said about the old Driver class, not the new package. Spotted by Joseph Shraibman <jks@p1.selectacast.net> Peter Mount 2000-05-15 21:32:51 +00:00
  • 6cb0fff31d cleanup Bruce Momjian 2000-05-15 16:20:45 +00:00
  • dcec5ae2cd cleanup Bruce Momjian 2000-05-15 16:16:23 +00:00
  • 52831da26c Fix createlang -l dbname so it works, update sgml. Bruce Momjian 2000-05-15 16:12:39 +00:00
  • 5a72eadc98 Add mention of lo_unlink to manual Bruce Momjian 2000-05-15 12:42:23 +00:00
  • ce2a9f372d *** empty log message *** Michael Meskes 2000-05-15 09:36:06 +00:00
  • 1bea3c3c46 Fix atan3-> atan2. Bruce Momjian 2000-05-15 01:41:18 +00:00
  • d64aa21570 That psql option should be --no-readline (as it used to be), not --noreadline. Peter Eisentraut 2000-05-14 18:05:05 +00:00
  • f87772b722 Remove array file, per Tom Lane. Bruce Momjian 2000-05-14 03:47:27 +00:00
  • 568df05028 Remove arrays file, already have array file. Bruce Momjian 2000-05-14 03:26:38 +00:00
  • bdeeb4fe8a Finally fix LISTEN problem. Bruce Momjian 2000-05-14 03:18:35 +00:00
  • f301fabf4e Back out listen fix. Bruce Momjian 2000-05-14 02:53:49 +00:00
  • efc6b7ddfc Update TODO list. Bruce Momjian 2000-05-14 01:29:07 +00:00
  • a316339e6c Update bug template. Bruce Momjian 2000-05-14 01:14:01 +00:00
  • 6dedc79b1e Fix create user for pgaccess. Bruce Momjian 2000-05-14 00:50:16 +00:00
  • e8e7b6305a Tweak selectivity for area-based operators. Still a crock... Tom Lane 2000-05-13 06:04:46 +00:00
  • 2cfb14e8ea Fix the off by one errors in ResultSet from 6.5.3, and more. Bruce Momjian 2000-05-12 20:54:22 +00:00
  • a28f117790 This is the second time I've answered this exact same problem in two days. It seems to be a FAQ, and I think I know why. When creating a 'c' language function, CREATE FUNCTION is fed the shared object filename, and seems to succeed. Only when trying to use the function is an error thrown, by which time the coder thinks something's wrong with executing the code, not with loading it. Bruce Momjian 2000-05-12 18:51:59 +00:00
  • 5e02f6b6ac Update TODO list. Bruce Momjian 2000-05-12 17:20:14 +00:00
  • e9e42f6f5f Remove cluster TODO e-mail file Bruce Momjian 2000-05-12 16:33:29 +00:00
  • 40c992c7dd Back out -\?. Didn't look good to Peter. Bruce Momjian 2000-05-12 16:28:31 +00:00
  • 9d31e3a991 /home/peter/commit-msg Peter Eisentraut 2000-05-12 16:13:44 +00:00
  • 475cb157b9 Squash some more CLUSTER bugs. Never has worked on multiple-column indexes, apparently, nor on functional indexes with more than one input column (force of natts = 1 was in the wrong branch of IF statement). Coredumped if source relation contained any uncommitted tuples, due to failure to test for success return from heap_fetch. Fetched tuple was passed directly to heap_insert, which clobbers the TID and commit status in the tuple header it's given, which meant that the source relation's tuples all got trashed as the copy proceeded. Abort partway through, and you're left with a lot of missing tuples. I wonder what else is lurking here ... Tom Lane 2000-05-12 16:10:09 +00:00
  • be4ae8f4b2 this fixes the bug where setting the entry in he process table no longer works under FreeBSD ... basically, if setproctitle() exists, use it ... Marc G. Fournier 2000-05-12 14:33:08 +00:00
  • 3383e8b828 Add two checks ... one for setproctitle and one for -lutil ... Marc G. Fournier 2000-05-12 13:58:25 +00:00
  • 5160a5db0a Update TODO list. Bruce Momjian 2000-05-12 12:33:48 +00:00
  • 845fb15e78 Update TODO list. Bruce Momjian 2000-05-12 12:24:45 +00:00
  • 01911c98db Repair list-vs-node confusion that resulted in failure for INNER JOIN ON. Make it behave correctly when there are more than two tables being joined, also. Update regression test expected outputs. Tom Lane 2000-05-12 01:33:56 +00:00
  • 4624b84cf2 Small cleanup of file. Bruce Momjian 2000-05-12 00:54:53 +00:00
  • 7da0f5d7de More psql help cleanup Bruce Momjian 2000-05-11 18:41:00 +00:00
  • 8101d0c571 Makefile CFLAGS cleanups. Bruce Momjian 2000-05-11 17:46:35 +00:00
  • eead0e77a4 Update SGML for FETCH and url's. Bruce Momjian 2000-05-11 17:32:33 +00:00
  • 023fdd6bbb Fix url reference with missing fields. Reported by Adrian Oboroc <aoboroc@btr.md>. Thomas G. Lockhart 2000-05-11 15:18:13 +00:00
  • 992e7dd4e3 Oops, plpgsql didn't have the datetime->timestamp and timespan->interval mappings. In fact, it had them backward because it was using the 6.5.* code. Copied them from parser/gram.y, so it is fixed now. Looks like our first 7.0.1 fix. Oops, seems Tom has beat me to it as I was typing this. Bruce Momjian 2000-05-11 04:00:00 +00:00
  • 37c652f89b Fix CLUSTER ... or at least undo the bit-rot it's suffered since 6.5. It's still pretty fundamentally bogus :-(. Freebie side benefit: ALTER TABLE RENAME works on indexes now. Tom Lane 2000-05-11 03:54:18 +00:00
  • e10c5597b7 Display -? as -\? under unix for psql. Bruce Momjian 2000-05-11 03:14:19 +00:00
  • 0fbde5d928 Add options and cleanup psql \? and -? help displays Bruce Momjian 2000-05-11 01:37:54 +00:00
  • 5a75ad5573 Update psql \? to show file rather than "fname". Bruce Momjian 2000-05-09 19:08:36 +00:00
  • 6706194e4e Fix psql quotes in docs. Bruce Momjian 2000-05-09 18:55:56 +00:00
  • 3b5338da25 More single-quote fixes. Bruce Momjian 2000-05-09 18:30:43 +00:00
  • 4108ee962a Add single quote. Bruce Momjian 2000-05-09 18:27:25 +00:00
  • f44328b2b8 Change HISTORY to show outer joins in 7.1 or 7.2. REL7_0 Bruce Momjian 2000-05-08 23:56:50 +00:00
  • 11a93191dc Minor fixups for markup and wording. Thomas G. Lockhart 2000-05-08 16:19:56 +00:00
  • b5c430467f Update TODO list. Bruce Momjian 2000-05-06 20:21:08 +00:00
  • 91885836f7 Update TODO list. Bruce Momjian 2000-05-06 16:05:17 +00:00