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

Commit Graph

  • 95d3d468ce This is a patch for cygipc library provided by Yutaka Tanida. This is necessary to prevent freezing in cygwin port. Hiroshi Inoue 1999-09-24 05:58:48 +00:00
  • e812458b27 Several changes here, not very related but touching some of the same files. * Buffer refcount cleanup (per my "progress report" to pghackers, 9/22). * Add links to backend PROC structs to sinval's array of per-backend info, and use these links for routines that need to check the state of all backends (rather than the slow, complicated search of the ShmemIndex hashtable that was used before). Add databaseOID to PROC structs. * Use this to implement an interlock that prevents DESTROY DATABASE of a database containing running backends. (It's a little tricky to prevent a concurrently-starting backend from getting in there, since the new backend is not able to lock anything at the time it tries to look up its database in pg_database. My solution is to recheck that the DB is OK at the end of InitPostgres. It may not be a 100% solution, but it's a lot better than no interlock at all...) * In ALTER TABLE RENAME, flush buffers for the relation before doing the rename of the physical files, to ensure we don't get failures later from mdblindwrt(). * Update TRUNCATE patch so that it actually compiles against current sources :-(. You should do "make clean all" after pulling these changes. Tom Lane 1999-09-24 00:25:33 +00:00
  • ad791c1d14 Update TODO list. Bruce Momjian 1999-09-23 22:14:01 +00:00
  • 36453816db Update TODO list. Bruce Momjian 1999-09-23 22:05:22 +00:00
  • ebd2391546 Update TODO list. Bruce Momjian 1999-09-23 22:04:00 +00:00
  • b8e2e3fb18 Backpatch into 6.5.*. Bruce Momjian 1999-09-23 19:13:55 +00:00
  • f66393514f One last missing quoting bug in pg_dump: now that sequence names are properly quoted for field defaults, mixed case sequence names are generated. These are properly quoted in the CREATE SEQUENCE lines, but not in the SELECT nextval lines, as per below: Bruce Momjian 1999-09-23 19:11:09 +00:00
  • be38f75edf Update TODO list. Bruce Momjian 1999-09-23 19:05:59 +00:00
  • 8f50694f86 Update TODO list. Bruce Momjian 1999-09-23 18:58:49 +00:00
  • 3f1b2de9e6 Update TODO list. Bruce Momjian 1999-09-23 18:54:57 +00:00
  • eea26a3f0f Update TODO list. Bruce Momjian 1999-09-23 17:59:10 +00:00
  • 8a454fc2a2 Update TODO list. Bruce Momjian 1999-09-23 17:50:57 +00:00
  • dabc3f31b5 Fix for netmask('x.x.x.x/0') is 255.255.255.255 instead of 0.0.0.0 This is because (-1) << 32 is -1 (Only intel arc. has been checked) Bruce Momjian 1999-09-23 17:42:23 +00:00
  • 337ab803a2 TRUNCATE command from Mike Mascari<mascarim@yahoo.com> Bruce Momjian 1999-09-23 17:11:16 +00:00
  • e7cad7b0cb Add TRUNCATE command, with psql help and sgml additions. Bruce Momjian 1999-09-23 17:03:39 +00:00
  • abd4bf1341 Update TODO list. Bruce Momjian 1999-09-23 15:47:48 +00:00
  • 4db51b155d Update TODO list. Bruce Momjian 1999-09-23 15:43:40 +00:00
  • 7947c6ded1 Update TODO list. Bruce Momjian 1999-09-21 21:37:06 +00:00
  • 4b06f6f9c8 I found the following useful - just a way of using PQgetisnull from libpq++. Bruce Momjian 1999-09-21 21:19:31 +00:00
  • 79434a3d54 Update TODO list. Bruce Momjian 1999-09-21 21:17:42 +00:00
  • 392f304cae gram.y cleanup Bruce Momjian 1999-09-21 21:10:37 +00:00
  • ad604ac372 values.h patch from Alex Howansky Bruce Momjian 1999-09-21 20:58:25 +00:00
  • 24a5300650 Update TODO list. Bruce Momjian 1999-09-21 20:00:14 +00:00
  • 99f289de49 Update TODO list. Bruce Momjian 1999-09-21 19:58:01 +00:00
  • 196cbe4e1d last batch, I think... Marc G. Fournier 1999-09-20 22:33:47 +00:00
  • 3848b4648a fixing it more.. Marc G. Fournier 1999-09-20 22:32:50 +00:00
  • a00a1a5641 bring it all into -current again Marc G. Fournier 1999-09-20 22:30:47 +00:00
  • 25acbc510b try and fix things... Marc G. Fournier 1999-09-20 22:29:12 +00:00
  • 7737dfd35a bring in missing files ... this isn't very clean, but :( Marc G. Fournier 1999-09-20 22:28:11 +00:00
  • 80751a72ee Make proper plpgsql non-externs. Bruce Momjian 1999-09-20 22:28:05 +00:00
  • 471881788f Add new files. Bruce Momjian 1999-09-20 22:03:21 +00:00
  • 20a97d8079 Update pgaccess 0.98. Bruce Momjian 1999-09-20 21:47:21 +00:00
  • 77bbd7147b Update pgaccess 0.98. Bruce Momjian 1999-09-20 21:43:06 +00:00
  • 35dc71980e Update TODO. Bruce Momjian 1999-09-20 16:28:12 +00:00
  • b8e7ebb7aa Update TODO list. Bruce Momjian 1999-09-20 16:25:33 +00:00
  • 957e6a6921 Add TODO detail directory. Bruce Momjian 1999-09-20 15:40:12 +00:00
  • 7559677551 Define plpgsql_yylineno as non-extern somewhere for bsdi. Bruce Momjian 1999-09-20 02:12:31 +00:00
  • fe2ab18ed9 Remove incorrect 'Assert(targetList != NULL)'. An INSERT ... DEFAULT VALUES statement does indeed have a null targetlist, at least during parse and rewrite stages. Tom Lane 1999-09-19 17:20:58 +00:00
  • 7fe22f5c8b Back-patch fix for NULL condition in CASE. Tom Lane 1999-09-18 23:30:05 +00:00
  • e1a8b0f2ce Fix CASE bug identified by Keith Parks: CASE didn't reliably treat a NULL condition result as FALSE. Clean up some bogus comments here and there, too. Tom Lane 1999-09-18 23:26:37 +00:00
  • f9f5dfbf10 Update regress test expected outputs for small changes in error message wording, due to most cases of no-such-relation now being detected in central heap_open code rather than on an ad-hoc basis. Tom Lane 1999-09-18 19:10:19 +00:00
  • bd272cace6 Mega-commit to make heap_open/heap_openr/heap_close take an additional argument specifying the kind of lock to acquire/release (or 'NoLock' to do no lock processing). Ensure that all relations are locked with some appropriate lock level before being examined --- this ensures that relevant shared-inval messages have been processed and should prevent problems caused by concurrent VACUUM. Fix several bugs having to do with mismatched increment/decrement of relation ref count and mismatched heap_open/close (which amounts to the same thing). A bogus ref count on a relation doesn't matter much *unless* a SI Inval message happens to arrive at the wrong time, which is probably why we got away with this sloppiness for so long. Repair missing grab of AccessExclusiveLock in DROP TABLE, ALTER/RENAME TABLE, etc, as noted by Hiroshi. Recommend 'make clean all' after pulling this update; I modified the Relation struct layout slightly. Will post further discussion to pghackers list shortly. Tom Lane 1999-09-18 19:08:25 +00:00
  • 6c86fd5ba4 Update TODO list. Bruce Momjian 1999-09-18 01:34:06 +00:00
  • 231c5935a4 *** empty log message *** Michael Meskes 1999-09-17 18:28:15 +00:00
  • 9995ba364c Update TODO list. Bruce Momjian 1999-09-17 15:49:24 +00:00
  • 68ee58ed43 *** empty log message *** Michael Meskes 1999-09-17 09:48:25 +00:00
  • bed8cf4d83 re-add Makefile for pgaccess Bruce Momjian 1999-09-17 04:02:20 +00:00
  • c77ec76e7c Update TODO list. Bruce Momjian 1999-09-17 01:57:36 +00:00
  • 2d0eee32c4 Changes made by Hiroshi Inoue and approved by Vadim. See attached mail for more details. Tatsuo Ishii 1999-09-16 09:08:56 +00:00
  • f2fa38ded5 jdbc2real rule was in there twice. One of them should have been jdbc1real Peter Mount 1999-09-15 21:56:16 +00:00
  • 8363e137aa Jens Glaser found that getPrimaryKeys() had a table called test hardwired into it. Peter Mount 1999-09-15 21:12:34 +00:00
  • cd68ecfef6 Some late patches from Jens Glaser (jens@jens.de). These upgrade the protocol to version 2, and fixes ResultSetMetaData.getColumnDisplaySize(). Peter Mount 1999-09-15 20:40:02 +00:00
  • 4d4378b70f *** empty log message *** Michael Meskes 1999-09-15 14:14:10 +00:00
  • 864e1e9d0e *** empty log message *** Michael Meskes 1999-09-15 08:29:25 +00:00
  • 3f68139373 An abstract declaration for the close() method was missed out of the previous commit to CVS. Peter Mount 1999-09-14 22:43:38 +00:00
  • d5d33e2ee4 Another little 'must fix' for 6.5.2: someone removed HAVE_KILL from the configuration symbols, but neglected to remove #ifdef HAVE_KILL from async.c in the REL6_5 branch. Result: cross-backend NOTIFY dead in the water. REL6_5_2 Tom Lane 1999-09-14 22:33:35 +00:00
  • 05a275926b Last-minute fix for 6.5.2: repair optimizer coredump on CASE clauses in WHERE. Surprised no one noticed this before. Tom Lane 1999-09-14 20:26:02 +00:00
  • 408e6e02ef Update from Andreas Zeugswetter <andreas.zeugswetter@telecom.at> for v6.5.2 info. Thomas G. Lockhart 1999-09-14 15:34:49 +00:00
  • 453e30e523 Update from Andreas Zeugswetter <andreas.zeugswetter@telecom.at> for v6.5.2 info. Thomas G. Lockhart 1999-09-14 15:33:50 +00:00
  • 4edb7770f6 Allow ISOLATION and LEVEL as column names. These are SQL92 reserved words which do not need to be so for our parser. Apparently omitted earlier. Thomas G. Lockhart 1999-09-14 06:07:35 +00:00
  • 2ee735ca21 Allow ISOLATION and LEVEL as column names. These are SQL92 reserved words which do not need to be so for our parser. Apparently omitted earlier. Thomas G. Lockhart 1999-09-14 06:06:31 +00:00
  • 24c82830cf Patches for 6.5.2 Peter Mount 1999-09-14 05:50:44 +00:00
  • 4197aaa8ae Update TODO list. Bruce Momjian 1999-09-14 02:19:38 +00:00
  • 9408abd6b7 Update for 6.5.2 history file. Bruce Momjian 1999-09-13 22:38:51 +00:00
  • e8a71f0dd3 Update pgaccess 0.98 Bruce Momjian 1999-09-13 18:47:42 +00:00
  • 45b5e0f84b Update vadim for index reuse. Bruce Momjian 1999-09-13 17:10:33 +00:00
  • 68bd59aab1 Merge in v6.5.2 notes taken from release.sgml. Thomas G. Lockhart 1999-09-13 04:35:14 +00:00
  • 400676afc9 Allow CASE statement to contain *only* untyped result clauses or nulls. Almost worked before, but forgot one place to check. Reported by Tatsuo Ishii. Still does not do the right thing if inserting into a non-string target column. Should look for a type coersion later, but doesn't. Thomas G. Lockhart 1999-09-13 04:21:21 +00:00
  • f0f73b316d Allow CASE statement to contain *only* untyped result clauses or nulls. Almost worked before, but forgot one place to check. Reported by Tatsuo Ishii. Still does not do the right thing if inserting into a non-string target column. Should look for a type coersion later, but doesn't. Thomas G. Lockhart 1999-09-13 04:14:56 +00:00
  • 3ec5232363 Patch to cure O(N^2) behavior in libpq when reading a long message under a kernel that only returns one packet per recv() call. This didn't use to matter much, but it starts to get annoying with multi-megabyte EXPLAIN VERBOSE responses... Tom Lane 1999-09-13 03:00:19 +00:00
  • e86054e2c3 Update release notes for 6.5.2. Bruce Momjian 1999-09-13 02:47:25 +00:00
  • ad4a574b00 Add solaris faq. Bruce Momjian 1999-09-13 00:21:18 +00:00
  • 8b20b8baee Update for 6.5.2. Bruce Momjian 1999-09-13 00:20:48 +00:00
  • 43d32d3683 First cut at doing something reasonable with OR-of-ANDs WHERE conditions. There are some pretty bogus heuristics in prepqual.c that try to decide whether to output CNF or DNF format; they need to be replaced, likely. Right now the code is probably too willing to choose DNF form, which might hurt performance in some cases that used to work OK. But at least we have a foundation to build on. Tom Lane 1999-09-13 00:17:25 +00:00
  • 8401a89868 Update to 6.5.2. Bruce Momjian 1999-09-13 00:13:24 +00:00
  • 2bb6c94fd9 Didn't commit right last time...SRCH_LIBS fix... Marc G. Fournier 1999-09-12 22:58:37 +00:00
  • b705fa3909 Make sure both SRCH_INC and SRCH_LIB are checked for existances and added to the CPPFLAGS/LDFLAGS variables... Marc G. Fournier 1999-09-12 22:49:47 +00:00
  • d87a36a5b5 when checking include directories, make sure you check for existence of SRCH_INC also...makes template file kinda useless without :) Marc G. Fournier 1999-09-12 22:47:14 +00:00
  • 2b7777bfa2 cygwin doesn't have an endian.h, but defines BYTE_ORDER in sys/param.h Marc G. Fournier 1999-09-12 22:27:47 +00:00
  • 6592a8aaa4 cygwin defines BYTE_ORDER in sys/param.h, and has no endian.h ... Marc G. Fournier 1999-09-12 22:25:32 +00:00
  • 2119cc0670 Further improvements in cnfify: reduce amount of self-recursion in or_normalize, remove detection of duplicate subexpressions (since it's highly unlikely to be worth the amount of time it takes), and introduce a dnfify() entry point so that unintelligible backwards logic in UNION processing can be eliminated. This is just an intermediate step --- next thing is to look at not forcing the qual into CNF form when it would be better off in DNF form. Tom Lane 1999-09-12 18:08:17 +00:00
  • 4644fc8071 Eliminate query length limitation imposed by pg_client_to_server and pg_server_to_client. Eliminate copy.c's restriction on the length of a single attribute. Tom Lane 1999-09-11 22:28:11 +00:00
  • b65ab31910 Eliminate token length assumption in scanstr(). Tom Lane 1999-09-11 22:26:47 +00:00
  • a7fd74edb3 Update protocol doc to emphasize that backend can return arbitrarily long strings, and frontends should cope gracefully. Goes along with long query and long error message changes... Tom Lane 1999-09-11 22:02:51 +00:00
  • b399805e22 Eliminate elog()'s hardwired limit on length of an error message. This change seems necessary in conjunction with long queries, and it cleans up some bogosity in connection with long EXPLAIN texts anyway. Note that current libpq will accept any length error message (at least until it runs out of memory); prior versions have a limit of 8K, but will cleanly discard excess error text, so there shouldn't be any big compatibility problems with old clients. Tom Lane 1999-09-11 19:06:42 +00:00
  • 1e4f0197bb Add information on ssh tunnelling from Gene Selkov. Thomas G. Lockhart 1999-09-10 14:20:24 +00:00
  • c1d5e88b41 Make pgindent gnu test better. Bruce Momjian 1999-09-09 19:39:06 +00:00
  • 805ee87b7d Repair incorrect cleanup of heap memory allocation during transaction abort --- before it only worked if there was exactly one level of allocation context stacked in the blank portal. Now it does the right thing for any depth, including zero... Tom Lane 1999-09-09 16:29:22 +00:00
  • 5bc0d31ae8 Repair incorrect cleanup of heap memory allocation during transaction abort --- before it only worked if there was exactly one level of allocation context stacked in the blank portal. Now it does the right thing for any depth, including zero... Tom Lane 1999-09-09 16:25:35 +00:00
  • 8b8db01517 Minor improvement in SI overflow logic: try to delete expired messages before concluding that we really have buffer overflow. Tom Lane 1999-09-09 14:56:06 +00:00
  • 9e713ddb99 Get rid of elog(DEBUG) in snprintf emulation ... it's just cluttering the log file... Tom Lane 1999-09-09 03:13:22 +00:00
  • 51db6455ea Repair error noticed by Roberto Cornacchia: selectivity code was rejecting negative attnums as bogus, which of course they are not. Add code to get_attdisbursion to produce a useful value for OID attribute, since VACUUM does not store stats for system attributes. Also, repair bug that's been in eqjoinsel for a long time: it was taking the max of the two columns' disbursions, whereas it should use the min. Tom Lane 1999-09-09 02:36:04 +00:00
  • 3279f0d546 StreamConnection() mustn't call elog(). Tom Lane 1999-09-08 23:00:51 +00:00
  • 45500964f6 StreamConnection() mustn't call elog(). Tom Lane 1999-09-08 22:57:12 +00:00
  • b1134e369f Cope with versions of vsnprintf() written by people who don't read man pages... Tom Lane 1999-09-08 16:31:38 +00:00
  • c7e3adf703 Repair logic error in LIKE: should not return LIKE_ABORT when reach end of pattern before end of text. Improve code comments. Tom Lane 1999-09-07 19:12:16 +00:00
  • bee7cd2a36 Repair logic error in LIKE: should not return LIKE_ABORT when reach end of pattern before end of text. Improve code comments. Tom Lane 1999-09-07 19:09:46 +00:00
  • 63858aaf26 Irix linking fix from Yu Cao <yucao@falcon.kla-tencor.com> Tom Lane 1999-09-07 18:11:35 +00:00
  • ea582ad7e7 Irix linking fix from Yu Cao <yucao@falcon.kla-tencor.com> Tom Lane 1999-09-07 18:10:49 +00:00
  • a2b57e3fe9 Update TODO list. Bruce Momjian 1999-09-07 03:58:13 +00:00