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

Commit Graph

  • b0f1880a8e Add new netbsd file. Bruce Momjian 1999-05-08 19:28:20 +00:00
  • e18c912acf *** empty log message *** Michael Meskes 1999-05-07 18:03:37 +00:00
  • ef26ad2ebd Remove unused Netbsd files. Bruce Momjian 1999-05-07 02:46:24 +00:00
  • c22d35be4e Please apply the following patch for regress.sh to do something useful with "SYSTEM", and unpack the files in the uuencoded .tar.gz file at the end in src/test/regress so that the int2, int4 and geometry tests pass on NetBSD/i386. They just fail on different wording of error messages and eg printing "0" rather than "-0". At a guess the same will be true for the other NetBSD ports, but I can't test them. Bruce Momjian 1999-05-07 02:37:08 +00:00
  • 5a0b77aa44 Please apply the following patch for regress.sh to do something useful with "SYSTEM", Patrick Welche Bruce Momjian 1999-05-07 02:31:43 +00:00
  • 122abf3af3 Fix LMGR for MVCC. Get rid of Extend lock mode. Vadim B. Mikheev 1999-05-07 01:23:11 +00:00
  • 86bc1da262 Update regress test for CASE to enable tests involving joins. Tom Lane 1999-05-06 23:09:30 +00:00
  • ec1f5f78b9 Fix oversights in flatten_tlistentry and replace_clause_joinvar_refs that led to CASE expressions not working very well in joined queries. Tom Lane 1999-05-06 23:07:33 +00:00
  • 5729c3503d fix_indxqual_references didn't cope with ArrayRef nodes, meaning that this failed: select proname,typname,prosrc from pg_proc,pg_type where proname = 'float8' and pg_proc.proargtypes[0] = pg_type.oid; Tom Lane 1999-05-06 01:30:58 +00:00
  • 9f82f9e459 Fix some nasty coredump bugs in hashjoin. This code was just about certain to fail anytime it decided the relation to be hashed was too big to fit in memory --- the code for 'batching' a series of hashjoins had multiple errors. I've fixed the easier problems. A remaining big problem is that you can get 'hashtable out of memory' if the code's guesstimate about how much overflow space it will need turns out wrong. That will require much more extensive revisions to fix, so I'm committing these fixes now before I start on that problem. Tom Lane 1999-05-06 00:30:47 +00:00
  • 5d5cf912bc I have two patches for 6.5.0: Bruce Momjian 1999-05-05 21:38:40 +00:00
  • 81ff51615d small error message improvement from Dmitry Samersoff Bruce Momjian 1999-05-05 13:51:38 +00:00
  • 1afe0b3146 Repair incorrectly-figured snprintf length restriction. Tom Lane 1999-05-04 23:39:20 +00:00
  • 84e832a802 Use sprintf() to convert float8 to a string during conversion to numeric. Original code used float8out(), but the resulting exponential notation was not handled (e.g. '3E9' was decoded as '3'). Thomas G. Lockhart 1999-05-04 15:50:24 +00:00
  • 54067db642 Allow -t tablename to preserve case if specified as "tablename". Thomas G. Lockhart 1999-05-04 15:47:35 +00:00
  • 6b5497757f Fix up examples of sh/ksh PATH environment variable definition. Thomas G. Lockhart 1999-05-04 02:57:13 +00:00
  • 2289009722 Clean up markup for first useful version. Thomas G. Lockhart 1999-05-04 02:43:55 +00:00
  • 807ad858e2 Include new introductory chapter on SQL from Stefan S. Should this be in the tutorial instead? Thomas G. Lockhart 1999-05-04 02:26:06 +00:00
  • f8aa366ddd Indent markup using emacs. Thomas G. Lockhart 1999-05-04 02:24:26 +00:00
  • 1def28ff20 Include specific info on available timezones. Document date/time input parsing procedure. Thomas G. Lockhart 1999-05-04 02:22:13 +00:00
  • 2289b403aa Include chapters on security and an intro to SQL. Thomas G. Lockhart 1999-05-04 02:19:20 +00:00
  • e1900b2b0c First version of markup which can run through jade for html. Probably not acceptable yet. Need to check some math symbols and markup. Thomas G. Lockhart 1999-05-04 02:18:34 +00:00
  • d8a3a8c0dd Include chapter on security. Thomas G. Lockhart 1999-05-04 02:16:57 +00:00
  • 5da466c597 Make sure targetlist generated for subplan does not share nodes with HAVING qualifier of upper plan. Have not seen any failures, just being a little bit paranoid... Tom Lane 1999-05-04 00:00:20 +00:00
  • b6c732e63c Correct declaration of array_map() so that it doesn't make gcc quite so unhappy. Tom Lane 1999-05-03 23:48:26 +00:00
  • 210055ad61 here are some patches for 6.5.0 which I already submitted but have never been applied. The patches are in the .tar.gz attachment at the end: Bruce Momjian 1999-05-03 19:10:48 +00:00
  • da5f1dd722 Revise union_planner and associated routines to clean up breakage from EXCEPT/HAVING patch. Cases involving nontrivial GROUP BY expressions now work again. Also, the code is at least somewhat better documented... Tom Lane 1999-05-03 00:38:44 +00:00
  • 605d84941d Clean up cost_sort some more: most callers were double-counting the cost of reading the source data. Tom Lane 1999-05-01 19:47:42 +00:00
  • 87d95ca04d Arrange for VACUUM to delete the init file that relcache.c uses to save a little bit of backend startup time. This way, the first backend started after a VACUUM will rebuild the init file with up-to-date statistics for the critical system indexes. Tom Lane 1999-05-01 19:09:46 +00:00
  • f7d25d2ab6 -T was omitted from getopt() call. Tom Lane 1999-05-01 17:16:25 +00:00
  • c422e1a93d Fix compile failures in dt.c --- line broken in middle of an identifier :-(. Sloppy transmission of a patch, likely. Tom Lane 1999-05-01 17:14:56 +00:00
  • b4c7a5655d Patch from "Hiroshi Inoue" <Inoue@tpf.co.jp> for FATAL 1:btree: BTP_CHAIN flag was expected Vadim B. Mikheev 1999-05-01 16:09:45 +00:00
  • 34a84addc7 Use page-level ExtendLock lock instead of table-level - should be faster. Vadim B. Mikheev 1999-05-01 15:04:46 +00:00
  • 099164039d cleanup Bruce Momjian 1999-04-30 17:03:04 +00:00
  • f4dcafc825 Clean up typo causing compile failure. Bruce Momjian 1999-04-30 16:22:46 +00:00
  • 17dbeebb5f Fill in reasonable-looking cost estimates in inserted nodes. This makes no difference to the optimizer, which has already decided what it's gonna do, but it makes the output of EXPLAIN much more plausible. Tom Lane 1999-04-30 04:04:27 +00:00
  • 7a7ba33536 Clean up some bogosities in path cost estimation, like sometimes estimating an index scan of a table to be cheaper than a sequential scan of the same tuples... Tom Lane 1999-04-30 04:01:44 +00:00
  • 11a0027e28 Fix nasty little typo that prevented get_cheapest_path_for_joinkeys from ever returning a path. This put a bit of a crimp in the system's ability to generate intelligent merge-join plans... Tom Lane 1999-04-30 03:59:06 +00:00
  • 52f1b2f3b6 Prevent priority inversion in locking by checking for existing locks before going into queue behind person with higher piority. Bruce Momjian 1999-04-30 02:04:51 +00:00
  • 7d62e9c719 Bugfix (bug by me in 1.4) in backparsing INSERT ... SELECT Jan Wieck 1999-04-29 15:52:01 +00:00
  • 99f61dac7e Defend against 'update oid'. Someday we might want to support that, but it'd be a New Feature, wouldn't it ... in the meantime, avoiding a backend crash seems worthwhile. Tom Lane 1999-04-29 03:01:50 +00:00
  • fd31563777 Aggregate functions didn't work on subscripted array references. Things are better now. Tom Lane 1999-04-29 01:13:13 +00:00
  • 970583ab4f Several routines in setrefs.c would crash on array refs due to lack of check for recursing into a null subexpression. Tom Lane 1999-04-29 00:20:27 +00:00
  • 89cf9303fd Fix stupid typo that broke empty-query response... odd that this is not revealed by any of our regression tests... Tom Lane 1999-04-28 22:17:58 +00:00
  • 26909a0797 Fixed DECIMAL data type to handle specified precision in atttypmod Jan Wieck 1999-04-27 13:33:43 +00:00
  • 6e702210c2 Fix for _copyUnique() suggested by Hiroshi Inoue Tatsuo Ishii 1999-04-27 09:49:36 +00:00
  • 1c1cafe72f These are no longer used ... Marc G. Fournier 1999-04-26 13:37:14 +00:00
  • a4041bce99 provides string to be used for expected/* files for system specific output... Marc G. Fournier 1999-04-26 13:33:19 +00:00
  • dd6b1aaa25 *** empty log message *** Michael Meskes 1999-04-26 05:28:48 +00:00
  • 89c7369d0e Fix from Yutaka Tanida <yutaka@marin.or.jp> for Cygwin32 support. Tatsuo Ishii 1999-04-26 04:42:49 +00:00
  • c84ea433d7 Fix from Yutaka Tanida <yutaka@marin.or.jp> Tatsuo Ishii 1999-04-26 04:40:17 +00:00
  • eb00bdf237 Insert a test for missing targetlist entry in replace_agg_clause. Tom Lane 1999-04-26 00:37:46 +00:00
  • 26db818710 It looks like the multibyte regress tests only work if both the database encoding and the client encoding match the encoding expected by the test. So, force both of them to be set from the MULTIBYTE environment var. This allows regress tests to be run successfully in multibyte environments other than the compiled-in default. Tom Lane 1999-04-25 23:30:31 +00:00
  • d69344c520 More multibyte tests with obsolete spelling of error message... Tom Lane 1999-04-25 23:16:23 +00:00
  • 22fe451c9d psql's recognition of comments didn't work right in MULTIBYTE environments; it was being careless about character lengths. Tom Lane 1999-04-25 23:10:36 +00:00
  • 109cbc7217 Explicitly set PGCLIENTENCODING during regression tests, since multibyte tests fail if it's different from database... Tom Lane 1999-04-25 21:56:19 +00:00
  • 122923c97f Still had a few MULTIBYTE problems when client encoding was different from database's ... Tom Lane 1999-04-25 21:50:58 +00:00
  • 0d99c95388 Correct potential infinite loop in pg_utf2wchar_with_len; it failed to cover the case where high bits of char are 100 or 101. Not sure if fix is right, but it agrees with pg_utf_mblen ... and it doesn't lock up ... Tom Lane 1999-04-25 20:35:51 +00:00
  • 2acfc4f6b4 Multibyte tests were all 'failing' because of change of wording of 'relation does not exist' error message. Update expected files accordingly. Tom Lane 1999-04-25 19:34:44 +00:00
  • 40cad8b66f My first cut at libpq revision didn't handle MULTIBYTE correctly, but I think it's OK now... Tom Lane 1999-04-25 19:27:47 +00:00
  • fad6f2925c Clean up gcc warning in MULTIBYTE code. Tom Lane 1999-04-25 18:16:47 +00:00
  • 6f668ee108 ifdef out some unused routines to suppress gcc warnings. Tom Lane 1999-04-25 18:09:54 +00:00
  • 187c58f275 Ooops, missed committing this one... Tom Lane 1999-04-25 03:27:15 +00:00
  • 95cc41b81d Revise backend libpq interfaces so that messages to the frontend can be generated in a buffer and then sent to the frontend in a single libpq call. This solves problems with NOTICE and ERROR messages generated in the middle of a data message or COPY OUT operation. Tom Lane 1999-04-25 03:19:27 +00:00
  • fc08814e00 Rename explain's "size" to "rows". Bruce Momjian 1999-04-23 21:23:49 +00:00
  • 35b168656b Add disk space message to "can not extend" message. Bruce Momjian 1999-04-23 19:37:42 +00:00
  • c3a32d7595 Remove "Non-functional update" notices since that message has been disabled (commented-out) in the code. Thomas G. Lockhart 1999-04-23 15:55:32 +00:00
  • c42926f10b Repair missing heap_endscan() in OperatorUpd(). Tom Lane 1999-04-23 00:50:57 +00:00
  • 3888b53a58 Fix duplicating ROOT page in concurrent updates. Vadim B. Mikheev 1999-04-22 08:19:59 +00:00
  • 00fbb64bed Un-break CREATE TYPE. Fix some other inconsistencies in the pg_proc entries for array I/O routines besides the one detected by the original patcher. Tighten type_sanity regress test accordingly. Tom Lane 1999-04-20 03:51:19 +00:00
  • 09c5e84072 Change elog(ERROR) to get back to main loop via a plain sigsetjmp, instead of doing a kill(self, SIGQUIT) and expecting the signal handler to do it. Also, clean up inconsistent definitions of the sigjmp buffer in the several files that already referenced it. Tom Lane 1999-04-20 02:19:59 +00:00
  • d30e2ac306 Portability patches for HPUX 11 and Unixware in configure and related files. Also remove float.c's gratuitous redeclaration of isinf() ... looks like there are more decls in there that ought to be in config.h, but I'll leave well enough alone for now ... Tom Lane 1999-04-20 00:26:32 +00:00
  • 6eccfbc727 Add temporary for temp. Bruce Momjian 1999-04-19 16:00:18 +00:00
  • f3a7addb03 Fix typo in multi-byte encodings (EHC_CN --> EUC_CN) Tatsuo Ishii 1999-04-19 08:46:34 +00:00
  • a58843b49a Fix problems seen when result of a subselect was used in an expression context (ie, not at the top level of a WHERE clause). Examples like this one work now: SELECT name, value FROM t1 as touter WHERE (value/(SELECT AVG(value) FROM t1 WHERE name = touter.name)) > 0.75; Tom Lane 1999-04-19 04:17:11 +00:00
  • 4438b70b94 Repair some problems in planner's handling of HAVING clauses. This fixes a few of the problems Hiroshi Inoue complained of, but I have not touched the rewrite-related issues. Tom Lane 1999-04-19 01:43:12 +00:00
  • 2deef968f4 After transforming a CASE expr with a default argument, delete the default argument from the node. This prevents the executor from spitting up on the untransformed argument expression. Typical failure was: select (case f1 when 'val' then 'subst' else f1 end) from t1; ERROR: copyObject: don't know how to copy 704 Tom Lane 1999-04-18 17:35:51 +00:00
  • 38405e1894 Update CREATE FUNCTION's on-line help in psql. Tom Lane 1999-04-18 03:01:49 +00:00
  • 4b82c6d940 Allow CREATE FUNCTION xyz AS '' LANGUAGE 'internal' to work the way it used to (ie, assume xyz is the name of the builtin function to call). Complain if an unknown builtin function name is referenced. Tom Lane 1999-04-18 02:57:22 +00:00
  • 00a4196139 Add res checking to libpq examples, from Dan Merillat. Bruce Momjian 1999-04-17 17:18:41 +00:00
  • 1b9f24c878 Add missing function prototypes to stifle gcc warnings. Tom Lane 1999-04-16 21:27:23 +00:00
  • ad5a54d170 *** empty log message *** Michael Meskes 1999-04-16 12:26:49 +00:00
  • 075dc252c7 Fix kill() call in elog() so that it gets its own pid by calling getpid(). MyProcPid global variable is set to 0 when postgres starts as a command (not as a backend daemon). This leads issuing SIGQUIT to the process group, not the process itself. As a result, parent sh gets core dumped in the Wisconsin benchmark test. Tatsuo Ishii 1999-04-16 06:38:17 +00:00
  • e062a176a8 Overhaul Wisconsin Benchmark test suit - change temp -> temp_bench ("temp" is now a reserved word) - fix bugs in queries - add -B 256 option to run the postgres command (without this, postgres seems to fail with hashjoin) Tatsuo Ishii 1999-04-16 06:31:13 +00:00
  • 26139bb4a0 Improve error messages when a connection is rejected. Tom Lane 1999-04-16 04:59:03 +00:00
  • 1d1cf38c0d Fix max(int8) result by making sure int8larger() copies its result rather than reusing the input storage. Also made the same fix to int8smaller(), though there wasn't a symptom, and went through and verified that other pass-by-reference data types do the same thing. Not an issue for the by-value types. Thomas G. Lockhart 1999-04-15 13:34:45 +00:00
  • 84746009c2 Hello! Tatsuo Ishii 1999-04-15 07:25:05 +00:00
  • 35d70e9ccf Replaced <literal></literal> with "" in ProgramListing sections Peter Mount 1999-04-15 06:00:16 +00:00
  • 0c0151a3ec Initialize reltuples = 1000, relpages = 10 in a newly created relation, rather than zeroes. This prevents the optimizer from making foolish choices (ie, using nested-loop plans) on never-yet-vacuumed tables. This is a hack, of course. Keeping accurate track of these statistics would be a cleaner solution, but it's far from clear that it'd be worth the cost of doing so. In any case we're not going to do that for 6.5. In the meantime, this quick hack provides a useful performance improvement in the regression tests and in many real-world scenarios. Tom Lane 1999-04-15 04:08:07 +00:00
  • dbce02f133 Add ORDER BY clauses to some select-from-view operations in rules regression test, in order to eliminate bogus test 'failures' that occur due to platform-dependent and join-implementation-dependent ordering of tuples. I'm not sure that I got all of the SELECTs that need ordering clauses --- we may need some more. But this takes care of the diffs between my platform and Jan's. Tom Lane 1999-04-15 03:40:50 +00:00
  • 1ae6739ee1 psql did the wrong thing with COPY FROM STDIN inside a file sourced with \i (tried to read data from the terminal, rather than from the source file; this breaks pg_dump scripts read with \i). Also, \o file followed by COPY TO STDOUT wrote to terminal not designated file. All better now. Tom Lane 1999-04-15 02:24:41 +00:00
  • 99e57ee86f Move some useful date/time test macros to here to allow sharing across files. Thomas G. Lockhart 1999-04-15 02:24:23 +00:00
  • 879d1be2fe Declare hashint8(). Thomas G. Lockhart 1999-04-15 02:23:37 +00:00
  • b2b3d5d184 Fix code to check legal dates *before* calling localtime() to get the time zone. Previously, localtime() rotated a date with a day of month field which exceeded the actual range into the next months, masking the fact that a bad date had been specified. Regression tests pass. Thomas G. Lockhart 1999-04-15 02:22:39 +00:00
  • 64e74e30b5 Fix boolean assignment of return values to use "FALSE" rather than the mis-copied "NULL", which happens to have the same binary value. Previously, gcc gave non-fatal warnings. Thomas G. Lockhart 1999-04-15 02:20:50 +00:00
  • e1a4ddeda8 Code modified to reject out of range day of month. Previously, dates falling within Unix system time range were run through a call to localtime() to get the time zone, if it was not specified. This had the effect that dates with DOMs which were larger than would be valid for that month were "rotated" into the following months. Thomas G. Lockhart 1999-04-15 02:19:02 +00:00
  • 9f9823950a Fix error message to match that returned by new regression test reference machine (linux-2.0.36 RH5.2 with RH5.2 patches). Thomas G. Lockhart 1999-04-15 02:15:36 +00:00
  • 630ed05063 Correct documentation of CREATE OPERATOR. Tom Lane 1999-04-15 00:09:00 +00:00
  • eaffc61675 Correct psql's online help for CREATE OPERATOR, which did not match what the backend actually accepts. Tom Lane 1999-04-14 23:48:07 +00:00
  • faba9fa747 pg_dump was trying to use an incorrect (or, perhaps, only obsolete?) syntax for CREATE OPERATOR with SORT parameters. Fixed. It is now actually possible to dump and reload a database containing fully specified user-definable operators ... Tom Lane 1999-04-14 23:47:19 +00:00