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

Commit Graph

  • 7c7139cf29 Knock down a couple more lappend() hotspots for large WHERE clauses. Tom Lane 2003-05-28 23:06:16 +00:00
  • 8a6ac83dab Fix some planner performance problems with large WHERE clauses, by introducing new 'FastList' list-construction subroutines to use in hot spots. This avoids the O(N^2) behavior of repeated lappend's by keeping a tail pointer, while not changing behavior by reversing list order as the lcons() method would do. Tom Lane 2003-05-28 22:32:50 +00:00
  • 0f3c68aa43 Fix breakage of LINUX_PROFILE code due to recent Windows changes. Tom Lane 2003-05-28 19:36:28 +00:00
  • 4df52b28f0 Fix things so that an error occuring during standalone-backend processing in initdb will result in exit(1), allowing the initdb script to realize that there's something wrong. Tom Lane 2003-05-28 18:19:09 +00:00
  • aae078198d In bootstrap and standalone-backend modes, do not sort LOG elevel out of order; the 'server log' output is actually client output in these scenarios and we ought to treat elevels the same way as in the client case. This allows initdb to not send backend stderr to /dev/null anymore, which makes it much more likely that people will notice problems during initdb. Tom Lane 2003-05-28 17:25:02 +00:00
  • fc8d970cbc Replace functional-index facility with expressional indexes. Any column of an index can now be a computed expression instead of a simple variable. Restrictions on expressions are the same as for predicates (only immutable functions, no sub-selects). This fixes problems recently introduced with inlining SQL functions, because the inlining transformation is applied to both expression trees so the planner can still match them up. Along the way, improve efficiency of handling index predicates (both predicates and index expressions are now cached by the relcache) and fix 7.3 oversight that didn't record dependencies of predicate expressions. Tom Lane 2003-05-28 16:04:02 +00:00
  • e5f19598e0 Add to thread discussion. Bruce Momjian 2003-05-28 05:02:38 +00:00
  • a2b498c291 Add info about selecting a random row. Bruce Momjian 2003-05-28 04:35:28 +00:00
  • a6f01d1aa6 Internationalize interactive yes/no responses. Peter Eisentraut 2003-05-27 19:36:55 +00:00
  • aea0270c23 Make log_ GUC settings controllable only by super-users, so non-super users can't turn it off. Bruce Momjian 2003-05-27 17:55:50 +00:00
  • 98b6f37e47 Make debug_ GUC varables output DEBUG1 rather than LOG, and mention in docs that CLIENT/LOG_MIN_MESSAGES now controls debug_* output location. Doc changes included. Bruce Momjian 2003-05-27 17:49:47 +00:00
  • 24daeb8e73 Add configure thread tests. Bruce Momjian 2003-05-27 16:36:50 +00:00
  • e185583a37 Allow input from stdin and output to stdout. Michael Meskes 2003-05-27 14:36:00 +00:00
  • 677844560f Fixed incorrect output for some structs. Michael Meskes 2003-05-27 11:31:52 +00:00
  • 5493ecc3a5 Adjust error-handling logic in libpq. For the first time, libpq copes sanely with running out of memory for a query result. Tom Lane 2003-05-26 20:05:20 +00:00
  • 90903069e9 Add item for changing a column's data type. Bruce Momjian 2003-05-26 19:25:20 +00:00
  • 5218f77c52 Fix misstatement in release-notes item. Tom Lane 2003-05-26 18:58:36 +00:00
  • 6923ea2b86 Fix misstatement in release-notes item. Tom Lane 2003-05-26 18:58:26 +00:00
  • 4b864e7cb0 Update: Bruce Momjian 2003-05-26 18:36:51 +00:00
  • 8c43300ccc Make sure printtup() always sends the number of columns previously advertised in RowDescription message. Depending on the physical tuple's column count is not really correct, since according to heap_getattr() conventions the tuple may be short some columns, which will automatically get read as nulls. Problem has been latent since forever, but was only exposed by recent change to skip a projection step in SELECT * FROM... Tom Lane 2003-05-26 17:51:38 +00:00
  • b71a48990a Add documentation to 'createuser' that ALTER USER must be used to add or modify passwords, per user confusion report. Bruce Momjian 2003-05-26 17:50:09 +00:00
  • ab64881f97 Add: Bruce Momjian 2003-05-26 02:56:40 +00:00
  • bb9f84aad7 Remove comment that cbrt() isn't being used. Bruce Momjian 2003-05-26 00:55:25 +00:00
  • f45df8c014 Cause CHAR(n) to TEXT or VARCHAR conversion to automatically strip trailing blanks, in hopes of reducing the surprise factor for newbies. Remove redundant operators for VARCHAR (it depends wholly on TEXT operations now). Clean up resolution of ambiguous operators/functions to avoid surprising choices for domains: domains are treated as equivalent to their base types and binary-coercibility is no longer considered a preference item when choosing among multiple operators/functions. IsBinaryCoercible now correctly reflects the notion that you need *only* relabel the type to get from type A to type B: that is, a domain is binary-coercible to its base type, but not vice versa. Various marginal cleanup, including merging the essentially duplicate resolution code in parse_func.c and parse_oper.c. Improve opr_sanity regression test to understand about binary compatibility (using pg_cast), and fix a couple of small errors in the catalogs revealed thereby. Restructure "special operator" handling to fetch operators via index opclasses rather than hardwiring assumptions about names (cleans up the pattern_ops stuff a little). Tom Lane 2003-05-26 00:11:29 +00:00
  • 297c1658ed Information schema improvements Peter Eisentraut 2003-05-25 09:36:09 +00:00
  • 310049a19b Clean up our static cbrt() implementation in float.c. Bruce Momjian 2003-05-25 05:30:57 +00:00
  • 8facf2df0b Move item: Bruce Momjian 2003-05-25 04:44:41 +00:00
  • 66f6bbb4eb Update: Bruce Momjian 2003-05-25 03:20:13 +00:00
  • ca98317f4b Add: Bruce Momjian 2003-05-24 19:03:21 +00:00
  • 12094d0946 Update XML items: > * Allow backend to output result sets in XML > * Add XML capability to pg_dump and COPY, when backend XML capability Bruce Momjian 2003-05-24 18:25:35 +00:00
  • 27f729c8fa Added: Bruce Momjian 2003-05-24 15:33:46 +00:00
  • 76e386d5e4 Add cost estimate discussion to TODO.detail. Bruce Momjian 2003-05-24 03:59:06 +00:00
  • 07d89f6f81 Add to TODO: Bruce Momjian 2003-05-24 01:28:22 +00:00
  • c49b6f4510 With disabled triggers, allow pg_dump to use ALTER TABLE ADD FOREIGN KEY Bruce Momjian 2003-05-24 01:27:41 +00:00
  • 11d5c82002 Improve implementation of btrim/ltrim/rtrim: provide a special case for single-byte encodings, and a direct C implementation of the single-argument forms (where spaces are always what gets trimmed). This is in preparation for using rtrim1() as the bpchar-to-text cast operator, but is a useful performance improvement even if we decide not to do that. Tom Lane 2003-05-23 22:33:23 +00:00
  • 78d2156066 One more ecpg todo fixed and removed. Michael Meskes 2003-05-23 17:20:46 +00:00
  • 27330595d3 Place statement_timeout in proper order in docs, from Bruno Wolff III. Bruce Momjian 2003-05-23 16:34:36 +00:00
  • 813d9960d2 Forgot these. Michael Meskes 2003-05-23 15:22:38 +00:00
  • d258fb91cf ecpg now accepts array elements as arguments. Michael Meskes 2003-05-23 15:19:36 +00:00
  • 450d7e276e Seems pl_funcs didn't have support for plpgsql PERFORM statement. Tom Lane 2003-05-23 04:08:34 +00:00
  • abb2963a4c Update for 7.3.3. REL7_3_3 Tom Lane 2003-05-22 20:38:56 +00:00
  • e2bfe2dd00 Update for 7.3.3. Tom Lane 2003-05-22 20:38:50 +00:00
  • 9bc3438b03 Brand 7.3.3. Tom Lane 2003-05-22 20:17:24 +00:00
  • 77645b99f4 Add define for missing EAI_ADDRFAMILY in BSD/OS 4.3. Bruce Momjian 2003-05-22 19:14:25 +00:00
  • 2ff6e92f46 Update release history for impending 7.3.3 release. Tom Lane 2003-05-22 18:32:01 +00:00
  • d23f6f8bb7 Update release history for impending 7.3.3 release. Tom Lane 2003-05-22 18:31:45 +00:00
  • 6fabec242d Fix compilation on Cygwin. Peter Eisentraut 2003-05-22 17:20:44 +00:00
  • cef0652a3d Add defense against possibility that tzname[] doesn't exist. Tom Lane 2003-05-22 17:13:08 +00:00
  • dbd55d3a5b Fixed segfault when detecting undefined cursor. Michael Meskes 2003-05-22 17:09:00 +00:00
  • c120f4ba0a Adjust configure so that extern tzname[] will be checked for independently of whether the struct tm tm_zone member exists. Also run autoheader, which seems not to have been done lately; it added about three more things to pg_config.h.in than I was expecting... Tom Lane 2003-05-22 16:39:30 +00:00
  • bab030b288 Repair sometimes-incorrect computation of StartUpID after a crash, per example from Rao Kumar. This is a very corner corner-case, requiring a minimum of three closely-spaced database crashes and an unlucky positioning of the second recovery's checkpoint record before you'd notice any problem. But the consequences are dire enough that it's a must-fix. Tom Lane 2003-05-22 14:39:49 +00:00
  • 39e98d9563 Repair sometimes-incorrect computation of StartUpID after a crash, per example from Rao Kumar. This is a very corner corner-case, requiring a minimum of three closely-spaced database crashes and an unlucky positioning of the second recovery's checkpoint record before you'd notice any problem. But the consequences are dire enough that it's a must-fix. Tom Lane 2003-05-22 14:39:28 +00:00
  • baba07173c Removed one TODO item for ecpg as this is done. Michael Meskes 2003-05-22 08:15:42 +00:00
  • d03a067ba0 ecpg now recognizes named structs/unions. So you don't have to list the whole definition everytime you declare a variable anymore. Michael Meskes 2003-05-22 07:58:45 +00:00
  • 3284e342a2 Back-patch Jan's fix to avoid primary key lookup (and lock) if foreign key does not change on UPDATE. Tom Lane 2003-05-21 18:14:46 +00:00
  • 0b5b3e9e65 Fix coredump in pg_get_triggerdef, ensure function name is schema- qualified when necessary, simplify argument-printing code. Tom Lane 2003-05-20 20:35:10 +00:00
  • dc554458ad Reversed my incorrect fix. Michael Meskes 2003-05-20 11:05:27 +00:00
  • edcf9c237c Add error message style guidelines to the SGML documentation. Tom Lane 2003-05-19 21:38:24 +00:00
  • af1850fc1a Use -fPIC on Sparc, per Tom Callaway. Tom Lane 2003-05-19 17:51:08 +00:00
  • 9ecba0c2f8 Use -fPIC on Sparc, per Tom Callaway. Tom Lane 2003-05-19 17:51:01 +00:00
  • 36adb2e095 Rename Win32 include directory from win32_include to win32. Bruce Momjian 2003-05-19 17:31:59 +00:00
  • 529ec66d53 Back-patch change to avoid O(N^2) behavior with lots of deferred triggers, by making deferredTriggerInvokeEvents only scan events added since it last ran. Tom Lane 2003-05-19 17:23:54 +00:00
  • 08d7e1c20e Fixed exec sql ifdef command. Michael Meskes 2003-05-19 07:19:57 +00:00
  • f3ed902421 Upped JDBC build number to 110 for the 7.3.3 release Barry Lind 2003-05-19 04:12:52 +00:00
  • 8236cd7e74 Repair quoting sloppiness, lack of schema awareness in reindexdb. Tom Lane 2003-05-19 01:00:18 +00:00
  • bf45bff004 Repair quoting sloppiness, lack of schema awareness in reindexdb. Tom Lane 2003-05-19 01:00:12 +00:00
  • 977adedda8 Small translation updates for 7.3.3 release. Peter Eisentraut 2003-05-18 23:51:41 +00:00
  • f89c972ac8 Add documentation for information schema, and some corrections on some views. Peter Eisentraut 2003-05-18 20:55:57 +00:00
  • 6d7ff848e5 Add code to test for unknown timezone names (following some ideas from Ross Reedstrom, a couple months back) and to detect timezones that are using leap-second timekeeping. The unknown-zone-name test is pretty heuristic and ugly, but it seems better than the old behavior of just switching to GMT given a bad name. Also make DecodePosixTimezone() a tad more robust. Tom Lane 2003-05-18 01:06:26 +00:00
  • 6d8c774f55 Fix breakage induced by recent patch (careless use of fmtId()). Tom Lane 2003-05-17 15:53:12 +00:00
  • 1e3fbccd6c Fix failure when uniq-ifying an array of zero elements. Tom Lane 2003-05-16 18:50:00 +00:00
  • 86f5fcfeb7 Fix failure when uniq-ifying an array of zero elements. Tom Lane 2003-05-16 18:49:51 +00:00
  • bdec4179b7 Back-patch fix to allow createuser to exit on control-C (Oliver Elphick) Tom Lane 2003-05-16 15:17:02 +00:00
  • 583736fad4 Back-patch fix from Oliver Elphick to force ISO datestyle in dumps. Tom Lane 2003-05-16 13:57:03 +00:00
  • 3055ca0f6d Small changes to use the absolute path to system catalogs. Tom Lane 2003-05-16 13:37:11 +00:00
  • f9b232f019 Small changes to use the absolute path to system catalogs. Tom Lane 2003-05-16 13:37:00 +00:00
  • 3d41da50f7 Made variable type double work again. Michael Meskes 2003-05-16 11:30:09 +00:00
  • 7e684fad02 Fixed incorrect include and another typo. Sorry, the include did not create a warning/error/problem on my machine, so I didn't notice it. Michael Meskes 2003-05-16 09:42:56 +00:00
  • ab90b49f6b Check calling context for connectby_text(), per Joe Conway. Tom Lane 2003-05-16 06:07:58 +00:00
  • bcfeca5856 Check calling context for connectby_text(), per Joe Conway. Tom Lane 2003-05-16 06:07:51 +00:00
  • c42581eba3 Allow interfaces to compile under MingGW/Win32 by adding _P to symbols in ecpg. Bruce Momjian 2003-05-16 04:59:24 +00:00
  • 32be7207aa Revert kerberos code breakage. Tom Lane 2003-05-16 04:58:03 +00:00
  • 9ea764a0dc Remove use of geteuid under Win32. Bruce Momjian 2003-05-16 02:40:19 +00:00
  • ec5e0ef791 Reorganize Win32 includes to only include <port.h> after system includes under Win32. Also fix other compile issues. Bruce Momjian 2003-05-16 01:57:52 +00:00
  • 5e04f3857c Revert change of inclusion order for pg_config_os.h; this broke plperl on Linux and would have who knows what unpleasant effects on other platforms. If you need another include file for Windows, then add it; don't go messing with the semantics of every other port's include files. Tom Lane 2003-05-15 23:39:27 +00:00
  • 9e43184b9d Add missing #include. Tom Lane 2003-05-15 19:34:46 +00:00
  • 09aad5a3a6 Add copydir() function because xcopy doesn't work in XP without a window. Bruce Momjian 2003-05-15 17:59:17 +00:00
  • bee0ac67ee Add missing win32 file --- seems best way to find these is to just commmit then do a cvs update again. Bruce Momjian 2003-05-15 16:40:29 +00:00
  • 12c9423832 Allow Win32 to compile under MinGW. Major changes are: Bruce Momjian 2003-05-15 16:35:30 +00:00
  • 2c0556068f Indexing support for pattern matching operations via separate operator class when lc_collate is not C. Peter Eisentraut 2003-05-15 15:50:21 +00:00
  • 2a2f6cfa39 Fix oversight: ignore-till-SYNC state should not ignore EOF ... Tom Lane 2003-05-14 18:40:37 +00:00
  • 22c4caef12 Add text(cidr) cast, per recent discussion. I'm not bothering to force an initdb for this. Tom Lane 2003-05-14 18:08:15 +00:00
  • 4e1ed3da9b - Added more compatibility functions. - Accept CPP defines for type definitions. - Do not parse system include files automatically for Informix mode Michael Meskes 2003-05-14 14:37:36 +00:00
  • 78b08584b4 Fix various recent build and regression-test problems in contrib/. Includes fixes from Joe Conway. Tom Lane 2003-05-14 03:27:22 +00:00
  • f85f43dfb5 Backend support for autocommit removed, per recent discussions. The only remnant of this failed experiment is that the server will take SET AUTOCOMMIT TO ON. Still TODO: provide some client-side autocommit logic in libpq. Tom Lane 2003-05-14 03:26:03 +00:00
  • d9b679c13a In RowDescription messages, report columns of domain datatypes as having the type OID and typmod of the underlying base type. Per discussions a few weeks ago with Andreas Pflug and others. Note that this behavioral change affects both old- and new-protocol clients. Tom Lane 2003-05-13 18:39:50 +00:00
  • 0249c24235 More binary I/O routines. Tom Lane 2003-05-13 18:03:08 +00:00
  • 72f311b86a Fixed order of include file search path. Michael Meskes 2003-05-13 11:29:14 +00:00
  • 1c9ac7dfd0 Change pg_amop's index on (amopclaid,amopopr) to index (amopopr,amopclaid). This makes no difference for existing uses, but allows SelectSortFunction() and pred_test_simple_clause() to use indexscans instead of seqscans to locate entries for a particular operator in pg_amop. Better yet, they can use the SearchSysCacheList() API to cache the search results. Tom Lane 2003-05-13 04:38:58 +00:00
  • 30f609484d Add binary I/O routines for a bunch more datatypes. Still a few to go, but that was enough tedium for one day. Along the way, move the few support routines for types xid and cid into a more logical place. Tom Lane 2003-05-12 23:08:52 +00:00