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

Commit Graph

  • 9a6184dee8 Added a long section about proper use of the optimizer-hint clauses in CREATE OPERATOR. Needs markup work. Tom Lane 1999-05-21 00:38:33 +00:00
  • 5690b1a18f Minor updates to libpq documentation. Tom Lane 1999-05-21 00:36:46 +00:00
  • 3de11d6526 Removed the automatic installation of built procedural languages from initdb again. Jan Wieck 1999-05-20 16:50:08 +00:00
  • 33773af95b Generate distinct error messages for trigger function not found and trigger function found but returns wrong type. Tom Lane 1999-05-20 14:39:49 +00:00
  • 443c08a110 Fixed shift/reduce conflict Jan Wieck 1999-05-20 12:12:55 +00:00
  • 1f82f1de33 overwriting a large object now works Tatsuo Ishii 1999-05-20 09:30:36 +00:00
  • 165b830ea5 Add reference pages on user interface applications. Thomas G. Lockhart 1999-05-20 05:40:27 +00:00
  • 32cfa65e49 Rearrange and consolidate the Admin Guide. Add reference pages for utilities and remove standalone chapters for same. Add material for an appendix on date/time properties, but not yet integrated with the User's Guide. Break up the former chapter on pg_options into Admin and Programmer's Guides. Thomas G. Lockhart 1999-05-20 05:39:29 +00:00
  • c3a4d8ed54 Very minor improvements in CREATE OPERATOR docs. Tom Lane 1999-05-20 03:22:01 +00:00
  • c9f8ab6fba Update CREATE FUNCTION docs: mention use of AS clause with INTERNAL functions, add a warning about trying to overload function names for dynamically loaded C functions (from old man page). Tom Lane 1999-05-20 02:57:15 +00:00
  • e68abfbeff Update SGML docs with some changes I made to test/regress/README many moons ago, but forgot to put here. Tom Lane 1999-05-20 02:46:40 +00:00
  • f9e497db7f Doco updates for change to handling of INTERNAL function entries (prosrc is now name of C-level function). Tom Lane 1999-05-20 02:44:53 +00:00
  • 77d3355900 Minor improvements to postmaster/backend man pages. Tom Lane 1999-05-19 23:30:43 +00:00
  • 41543b0618 Dec ALpha patches Bruce Momjian 1999-05-19 18:06:43 +00:00
  • 8223f70e52 Dec alpha patches. Bruce Momjian 1999-05-19 18:04:51 +00:00
  • 6d08b6a7b8 Remove 4096 string limited key on block size Bruce Momjian 1999-05-19 17:53:12 +00:00
  • 0a8fb5a8f9 Upgrade to PyGreSQL (2.4) Bruce Momjian 1999-05-19 16:46:12 +00:00
  • 9487ad8409 Bring python up to date ... Marc G. Fournier 1999-05-19 14:46:54 +00:00
  • 77ebed09f5 Add Aggref and ArrayRef to the set of node types that transformExpr will pass through rather than spitting up. This is necessary to handle cases where coerce_type causes a subexpression to be retransformed, as in SELECT count(*) + 1.0 FROM table Tom Lane 1999-05-18 23:40:05 +00:00
  • 2d7ec4785f Forgot the CHANGELOG Peter Mount 1999-05-18 23:22:08 +00:00
  • 4c63b257fd Internationalisation of error messages Peter Mount 1999-05-18 23:17:46 +00:00
  • c2f0d565f3 Now that hashjoin is reliable for large joins (knock on wood), remove optimizer's arbitrary limit on how large a join it will use hashing for. (The limit was too large to prevent the problems we'd been seeing, anyway...) Tom Lane 1999-05-18 21:36:10 +00:00
  • 353d36f979 Remove no-longer-used fields in Hash and HashJoin nodes. Tom Lane 1999-05-18 21:34:29 +00:00
  • 26069a58e8 Rewrite hash join to use simple linked lists instead of a fixed-size hashtable. This should prevent 'hashtable out of memory' errors, unless you really do run out of memory. Note: target size for hashtable is now taken from -S postmaster switch, not -B, since it is local memory in the backend rather than shared memory. Tom Lane 1999-05-18 21:33:06 +00:00
  • d261a5ec86 Transactions in ImageViewer Peter Mount 1999-05-18 06:07:25 +00:00
  • 21e03211cf *** empty log message *** Michael Meskes 1999-05-18 05:20:17 +00:00
  • 20f0cfc322 Fixed Internationalization of error messages. Peter Mount 1999-05-17 22:58:19 +00:00
  • 3f59cc0831 Minor bug fixes. Replaced DateStyle support with ISO. Peter Mount 1999-05-17 22:43:30 +00:00
  • c2b75c83f3 All works on linux now by my tests and regression(with patch below). Bruce Momjian 1999-05-17 18:24:48 +00:00
  • 19c4e862d4 Skip junk nodes when comparing UNION target list lengths. Bruce Momjian 1999-05-17 18:22:19 +00:00
  • 585c967720 Change resjunk to a boolean. Bruce Momjian 1999-05-17 17:03:51 +00:00
  • fd1647706d Fixed latest regression diff's by omitting viewowner in SELECT from pg_views. Jan Wieck 1999-05-17 09:03:26 +00:00
  • 184dd28d5c This is actually more of a fundamental problem with mdtruncate. It looks like someone just didn't add support for multiple segments for truncation. Bruce Momjian 1999-05-17 06:38:41 +00:00
  • 1125c5e4c5 Add python Bruce Momjian 1999-05-17 06:27:07 +00:00
  • e55213a5a8 Re-add python. Bruce Momjian 1999-05-17 06:15:31 +00:00
  • 716b8e2dba Updates for 6.5. Bruce Momjian 1999-05-17 06:06:35 +00:00
  • af657ae739 Update pointers to where the register/mailing list pages are found on the wweb site .. Marc G. Fournier 1999-05-17 04:58:19 +00:00
  • fe0b8612d9 Prior patch added 2 more characters to string allocated for SERIAL column's constraint, but forgot to increase space palloc'd... Tom Lane 1999-05-17 04:50:07 +00:00
  • b8b1ba53ea SELECT * error message fix. Bruce Momjian 1999-05-17 04:19:33 +00:00
  • a0b7daa129 Apply freebsd specific patches dealign with ELF system from FreeBSD's ports collection ... Marc G. Fournier 1999-05-17 04:13:29 +00:00
  • 61f618e73e Move IN to proper place. Bruce Momjian 1999-05-17 01:01:06 +00:00
  • a341db91c5 Cleanup Bruce Momjian 1999-05-17 00:31:49 +00:00
  • e83265b32a Fix typo in change. Bruce Momjian 1999-05-17 00:27:45 +00:00
  • 0b8b1fe3aa Tighten coding in new_join_pathkey, which seems to be a hotspot for GEQO ... Tom Lane 1999-05-17 00:26:33 +00:00
  • 1332c1e144 Change GEQO optimizer to release memory after each gene is evaluated. This bounds memory usage to something reasonable even when many tables are being joined. Tom Lane 1999-05-17 00:25:34 +00:00
  • c686be8d56 Require IN in LOCK syntax. Bruce Momjian 1999-05-17 00:22:07 +00:00
  • 054cae8173 Change md* call to smgr*. Bruce Momjian 1999-05-17 00:19:12 +00:00
  • fecb2b0024 Minor code cleanup in optimizer. Tom Lane 1999-05-16 19:45:37 +00:00
  • f2ed835baf Fix some typos in geqo optimizer --- it now generates reasonable plans again. Still eats memory like there's no tomorrow, however :-(. Tom Lane 1999-05-16 19:45:00 +00:00
  • cf11642e92 Undo collateral damage from recent patch: Makefile had lost most of target list and thus 'make clean' didn't clean up very well. Tom Lane 1999-05-16 14:56:17 +00:00
  • bbf3748347 Change iostream to iostream.h, strstream to strstream.h for compatibility with older C++ libraries. Tom Lane 1999-05-16 14:34:59 +00:00
  • 2132e062e1 I made it so it rolled over files at 1MB. My table ended up with 120 segments, and my indexes had 3(Yes, it DOES work!). DROP TABLE removed ALL segments from the table, but only the main index segment. Bruce Momjian 1999-05-15 22:31:07 +00:00
  • de81fbd047 I've got 2 pretty small patches. Bruce Momjian 1999-05-15 22:18:51 +00:00
  • c8bd630af6 *** empty log message *** Michael Meskes 1999-05-14 06:56:18 +00:00
  • 564842a617 Hi, Bruce! Bruce Momjian 1999-05-13 15:55:45 +00:00
  • 9bbc1657a1 Add double quotes around the sequence name generated to support the SERIAL data type DEFAULT clause. This fixes a problem finding the sequence name when mixed case table names are involved. Thomas G. Lockhart 1999-05-13 15:01:32 +00:00
  • 81c83db3bb Surround a variable declaration with ENABLE_OUTER_JOINS to suppress compiler warnings about an unused variable. Thomas G. Lockhart 1999-05-13 14:59:05 +00:00
  • 0c1e2e493d set client_encoding to <nothing> crashes backend. Tatsuo Ishii 1999-05-13 10:28:26 +00:00
  • 507a0a2ab0 Rip out QueryTreeList structure, root and branch. Querytree lists are now plain old garden-variety Lists, allocated with palloc, rather than specialized expansible-array data allocated with malloc. This substantially simplifies their handling and eliminates several sources of memory leakage. Several basic types of erroneous queries (syntax error, attempt to insert a duplicate key into a unique index) now demonstrably leak zero bytes per query. Tom Lane 1999-05-13 07:29:22 +00:00
  • f80642137c Update driver to 6-40-0006 Byron Nikolaidis 1999-05-13 03:33:00 +00:00
  • 519ad246ae Here's a small patch to cause pg_dump to emit the scale and precision for NUMERIC type column defs. Bruce Momjian 1999-05-13 02:35:44 +00:00
  • 0b885e2397 Release allocated memory during AtAbort_Memory. Tom Lane 1999-05-13 00:34:57 +00:00
  • eb4d9f45ef Do not refer to stdin in static variable initializer ... apparently some systems choke on that :-(. Tom Lane 1999-05-12 23:26:03 +00:00
  • c8cc45b2f3 Fixed small bug in ruleutils and added output of pg_views and pg_rules to rules regression test. Jan Wieck 1999-05-12 17:59:32 +00:00
  • b7a86e4046 Fixed wrong hasAggs when aggregate columns of view aren't selected. Jan Wieck 1999-05-12 17:04:47 +00:00
  • 79c2576f77 Replaced targetlist entry in GroupClause by reference number in Resdom and GroupClause so changing of resno's doesn't confuse the grouping any more. Jan Wieck 1999-05-12 15:02:39 +00:00
  • 1a87c14c9c I am sorry, I misinterpreted the still failing trigger regression test. The offending code has been removed, the action is now always dependent :-) Bruce Momjian 1999-05-12 12:47:24 +00:00
  • ca00c902fb Added installation of created procedural languages to initdb Jan Wieck 1999-05-12 10:35:44 +00:00
  • 6a982fc6a7 Minor wording change. Thomas G. Lockhart 1999-05-12 07:34:02 +00:00
  • 95e3cec621 Include mention of CASE, COALESCE, and IFNULL. Add date/time parsing procedure (perhaps should be in appendix). Add time zone information (ditto). Update keyword list. Thomas G. Lockhart 1999-05-12 07:32:47 +00:00
  • 5dd715b592 Adjust elog NOTICE messages to surround table and column names with single quotes. Thomas G. Lockhart 1999-05-12 07:24:01 +00:00
  • bcb5aac81d Add keywords to implement Vadim's transaction isolation and lock syntax as fully parsed tokens. Two keywords for isolation are non-reserved SQL92 (COMMITTED, SERIALIZABLE). All other new keywords are non-reserved Postgres (not SQL92) (ACCESS, EXCLUSIVE, MODE, SHARE). Add syntax to allow CREATE [GLOBAL|LOCAL] TEMPORARY TABLE, throwing an error if GLOBAL is specified. Thomas G. Lockhart 1999-05-12 07:22:52 +00:00
  • 3ce054b57d Fix problem with multiple indices defined if using column- and table- constraints. Reported by Tom Lane. Now, check for duplicate indices and retain the one which is a primary-key. Adjust elog NOTICE messages to surround table and column names with single quotes. Thomas G. Lockhart 1999-05-12 07:17:18 +00:00
  • 575c40a61f Handle conversion of floating point constants to internal strings. Thomas G. Lockhart 1999-05-12 07:14:24 +00:00
  • 8d21a6ef51 Keep long non-quoted numeric strings *as* untyped strings if they fail the obvious conversion. Define a new pattern "decimal" which is non-exponential floating point for use with numeric() and decimal() types. Thomas G. Lockhart 1999-05-12 07:12:51 +00:00
  • a36a7a16eb Fix bogus assumption that MAXALIGN is at least sizeof(pointer). Tom Lane 1999-05-12 04:38:24 +00:00
  • 5085132c6d Fix configure to generate correct expansion of library directory in pl/plpgsql/src/mklang.sql. Tom Lane 1999-05-11 22:57:50 +00:00
  • a9bd936066 Just a couple more files to untar in src/test/regress (int2,int4,geometry). Bruce Momjian 1999-05-11 16:29:45 +00:00
  • 5057010944 Changed debug options: Jan Wieck 1999-05-11 09:06:35 +00:00
  • 1ba362f567 put back mklang.sql.in file. Bruce Momjian 1999-05-11 03:30:41 +00:00
  • 12f9de3fd4 clean up comments Bruce Momjian 1999-05-11 03:28:43 +00:00
  • 0b4fab42c3 Update man page for select Bruce Momjian 1999-05-10 18:22:48 +00:00
  • bb885dd1a1 Check for NUMERIC overflow a second time after rounding Jan Wieck 1999-05-10 18:17:44 +00:00
  • 0d5c832363 Allow perl install as non-root, from Geoff Keating Bruce Momjian 1999-05-10 17:01:25 +00:00
  • 94bd4e3da7 Update to PyGreSQL 2.3. Bruce Momjian 1999-05-10 16:10:51 +00:00
  • 86dacdb74c libpq++ uses fe_setauthsvc which is deprecated and results in an error on connection. This patch changes it to use PQconnectdb rather than {fe_setauthsvc,PQsetdb}. This still isn't the complete solution, as there is no provision for user,password in class PgEnv, but it does get rid of the error message. Tested with gcc version egcs-2.91.60 19981201 (egcs-1.1.1 release) under NetBSD-1.3K/i386. Bruce Momjian 1999-05-10 15:27:19 +00:00
  • d6e33c8b07 Rename MAP_FILE to USERMAP_FILE for Digital Unix. Bruce Momjian 1999-05-10 15:17:17 +00:00
  • d489fdfc7f I send you a attach of my modified refint.c that works with a new policy in cascade mode . Bruce Momjian 1999-05-10 15:12:29 +00:00
  • 9e4e33c996 This patch is to add more comments to postgres.init.sh , clairify the options available, and to add easy support for installation of postgres into the runlevel system. Bruce Momjian 1999-05-10 04:57:07 +00:00
  • 40457dfde9 add mention of large object orphaning Bruce Momjian 1999-05-10 04:19:30 +00:00
  • f4213e6b23 Fix initdb problem introduced by recent patch. Bruce Momjian 1999-05-10 04:02:07 +00:00
  • 4853495e03 Change error messages to oids come out as %u and not %d. Change has no real affect now. Bruce Momjian 1999-05-10 00:46:32 +00:00
  • b7332c9243 Correct type_sanity test so it doesn't spit up on new definition of numeric_in. Tom Lane 1999-05-09 23:43:25 +00:00
  • 0b69d8a27c Rearrange top-level rewrite operations so that EXPLAIN works on queries involving UNION, EXCEPT, INTERSECT. Tom Lane 1999-05-09 23:31:47 +00:00
  • 6458daa180 Running lo_read/lo_write under different memory context cause troubles. See Message-Id: <199905090312.MAA00466@ext16.sra.co.jp> for more details. Tatsuo Ishii 1999-05-09 15:00:18 +00:00
  • 202e523d10 Mistyping by me. Fixed by Hiroshi. Vadim B. Mikheev 1999-05-09 14:00:29 +00:00
  • 3c6491ff96 Repair incorrect pg_proc entry for numeric_in. Tom Lane 1999-05-09 02:22:16 +00:00
  • b5bcef683b Fix some miscellaneous places that were using raw open() or fopen(), instead of going through fd.c ... naughty naughty. Tom Lane 1999-05-09 00:54:30 +00:00
  • 71d5d95376 Update hash and join routines to use fd.c's new temp-file code, instead of not-very-bulletproof stuff they had before. Tom Lane 1999-05-09 00:53:22 +00:00
  • c1167a08ca Add 'temporary file' facility to fd.c, and arrange for temp files to be closed automatically at transaction abort or commit, should they still be open. Also close any still-open stdio files allocated with AllocateFile at abort/commit. This should eliminate problems with leakage of file descriptors after an error. Also, put in some primitive buffered-IO support so that psort.c can use virtual files without severe performance penalties. Tom Lane 1999-05-09 00:52:08 +00:00