hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-24 15:26:59 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • ee7fbb1eaa Add WIN32 pipe implementation that uses sockets. Bruce Momjian 2004-01-09 04:58:09 +00:00
  • 0d2148a71e Remove duplicate include of value.h. I think it got in because Tom and I both added it. Bruce Momjian 2004-01-09 03:07:32 +00:00
  • 59182d9901 Add comment about synchronous signals. Bruce Momjian 2004-01-09 02:17:15 +00:00
  • 0150dbdce5 Allow libpq to do thread-safe SIGPIPE handling. This allows it to ignore SIGPIPE from send() in libpq, but terminate on any other SIGPIPE, unless the user installs their own signal handler. Bruce Momjian 2004-01-09 02:02:43 +00:00
  • acc57543de German FAQ update. Bruce Momjian 2004-01-09 01:51:31 +00:00
  • 05fb316fbb Fix incorrect SQL syntax emitted when -E is given without -P. Report and fix from Martin Pitt. Tom Lane 2004-01-09 00:15:19 +00:00
  • ccdeed7011 Fix incorrect SQL syntax emitted when -E is given without -P. Report and fix from Martin Pitt. Tom Lane 2004-01-09 00:15:11 +00:00
  • 2fb41f900a Remove broken (and unnecessary) definition of operator <> for _int4 datatype; the generic array comparators added in 7.4 supersede this. Per report and patch from Korea PostgreSQL Users' Group. Tom Lane 2004-01-08 23:40:36 +00:00
  • 5390e284db Remove broken (and unnecessary) definition of operator <> for _int4 datatype; the generic array comparators added in 7.4 supersede this. Per report and patch from Korea PostgreSQL Users' Group. Tom Lane 2004-01-08 23:40:27 +00:00
  • bd98d159eb Fix a spelling mistake in a comment. Neil Conway 2004-01-08 20:04:41 +00:00
  • 49c534fccb Throw compile error if our non-thread-safe snprintf is used. Bruce Momjian 2004-01-08 17:15:54 +00:00
  • 8c3f859ecf Update Russian FAQ. Bruce Momjian 2004-01-08 16:01:58 +00:00
  • f389ff33c3 Update OSF thread flags for non-gcc compiles. Bruce Momjian 2004-01-08 15:51:38 +00:00
  • 177ca67095 Update OSF thread flags for non-gcc compiles. Bruce Momjian 2004-01-08 15:51:24 +00:00
  • 002cafe7a4 Translation updates Dennis Bjorklund 2004-01-08 10:47:40 +00:00
  • 611d33a90a Translation updates Dennis Bjorklund 2004-01-08 08:51:31 +00:00
  • b68021c240 Translation updates Dennis Bjorklund 2004-01-08 08:36:50 +00:00
  • 92ff092d40 [Forced commit to add log message that I fat-fingered last time] Tom Lane 2004-01-08 06:01:21 +00:00
  • 77f140008b Fix Solaris thread build settings for non-gcc compilers. Bruce Momjian 2004-01-08 04:24:24 +00:00
  • 88a987fcfd Update Solaris thread setting for non-gcc compilers. Bruce Momjian 2004-01-08 04:21:20 +00:00
  • 4f913efe73 make Tom Lane 2004-01-07 23:03:06 +00:00
  • cad5f4a8c4 Make some improvements in the intelligence of the partial-index predicate tester. It can now deal with commuted clauses (for instance, 4 < x implies x > 3), subclauses more complicated than a simple Var (for example, upper(x) = 't' implies upper(x) > 'a'), and <> operators (for example, x < 3 implies x <> 4). Still only understands operators associated with btree opclasses, though. Inspired by example from Martin Hampl. Tom Lane 2004-01-07 22:02:48 +00:00
  • 504983859d Translation updates Dennis Bjorklund 2004-01-07 21:51:13 +00:00
  • 2bc0c8b2b7 Add missing inclusion of nodes/value.h. Tom Lane 2004-01-07 21:12:56 +00:00
  • 192ad63bd7 More janitorial work: remove the explicit casting of NULL literals to a pointer type when it is not necessary to do so. Neil Conway 2004-01-07 18:56:30 +00:00
  • afca5d50dc Cleanup: move the 'Value' node into a separate file, rather than putting it in the same file as the 'List' node. Neil Conway 2004-01-07 18:43:36 +00:00
  • 7f5e12a84c Not done, per Tom: Bruce Momjian 2004-01-07 17:54:19 +00:00
  • 6a78eecf6f Translation updates Peter Eisentraut 2004-01-07 17:44:07 +00:00
  • 304d6d5b63 Support function parameter names in plpgsql. This is the last of Dennis Bjorklund's original patch for function parameter names, but there's still plenty left to do (documentation for instance...) Tom Lane 2004-01-07 06:20:02 +00:00
  • a95df8f2bf Completed, I am pretty sure: Bruce Momjian 2004-01-07 04:32:56 +00:00
  • 6400d69d87 pg_dump support for function parameter names. Tom Lane 2004-01-07 00:44:21 +00:00
  • a77e32d7c5 Apply the core parts of Dennis Bjorklund's patch to allow function parameters to be declared with names. pg_proc has a column to store names, and CREATE FUNCTION can insert data into it, but that's all as yet. I need to do more work on the pg_dump and plpgsql portions of the patch before committing those, but I thought I'd get the bulky changes in before the tree drifts under me. initdb forced due to pg_proc change. Tom Lane 2004-01-06 23:55:19 +00:00
  • 488f2785d0 Final rearrangement of main postgresql child process (ie. BackendFork/SSDataBase/pgstat) startup, to allow fork/exec calls to closely mimic (the soon to be provided) Win32 CreateProcess equivalent calls. Bruce Momjian 2004-01-06 23:15:22 +00:00
  • 06288d4e22 Suppress compiler warning (xlog_outrec is unused if not WAL_DEBUG). Tom Lane 2004-01-06 22:22:37 +00:00
  • 89aafae009 Favor Freenode rather than EFnet in IRC listing. Freenode is more popular. Bruce Momjian 2004-01-06 21:44:07 +00:00
  • bf2a591ffc Done: Bruce Momjian 2004-01-06 20:01:13 +00:00
  • dfc7e7b71d Code cleanup, mostly in the smgr: Neil Conway 2004-01-06 18:07:32 +00:00
  • 030f8e7313 Remove unused 'noversion' command-line option processing from the backend. Neil Conway 2004-01-06 17:36:31 +00:00
  • bc028beb16 Make the 'wal_debug' GUC variable a boolean (rather than an integer), and hide it behind #ifdef WAL_DEBUG blocks. Neil Conway 2004-01-06 17:26:23 +00:00
  • b0c4a50bbb Instead of rechecking lossy index operators by putting them into the regular qpqual ('filter condition'), add special-purpose code to nodeIndexscan.c to recheck them. This ends being almost no net addition of code, because the removal of planner code balances out the extra executor code, but it is significantly more efficient when a lossy operator is involved in an OR indexscan. The old implementation had to recheck the entire indexqual in such cases. Tom Lane 2004-01-06 04:31:01 +00:00
  • fa559a86ee Adjust indexscan planning logic to keep RestrictInfo nodes associated with index qual clauses in the Path representation. This saves a little work during createplan and (probably more importantly) allows reuse of cached selectivity estimates during indexscan planning. Also fix latent bug: wrong plan would have been generated for a 'special operator' used in a nestloop-inner-indexscan join qual, because the special operator would not have gotten into the list of quals to recheck. This bug is only latent because at present the special-operator code could never trigger on a join qual, but sooner or later someone will want to do it. Tom Lane 2004-01-05 23:39:54 +00:00
  • 5d472f6464 Trivial refactoring: move analysis of ViewStmt into its own function for readability and for the sake of consistency with the rest of analyze.c Neil Conway 2004-01-05 20:58:58 +00:00
  • 71998c1e51 Remove an old and out-of-date SGML comment from this file: we already have WAL, outer joins, and TOAST. Neil Conway 2004-01-05 20:39:23 +00:00
  • af7a21cb99 Fix (yet another) instance of incorrect markup for a GUC variable. Neil Conway 2004-01-05 20:37:51 +00:00
  • 548523533f Fix three trivial typos in comments. Neil Conway 2004-01-05 20:36:04 +00:00
  • 0658e7905d Translation updates Peter Eisentraut 2004-01-05 19:15:55 +00:00
  • 35b1fe122c Translation updates Peter Eisentraut 2004-01-05 19:15:48 +00:00
  • 5c74ce23db Improve UniquePath logic to detect the case where the input is already known unique (eg, it is a SELECT DISTINCT ... subquery), and not do a redundant unique-ification step. Tom Lane 2004-01-05 18:04:39 +00:00
  • cce442da6d Dept. of second thoughts: clause_selectivity shouldn't try to cache its result for jointypes associated with IN processing. Tom Lane 2004-01-05 16:44:40 +00:00
  • 9091e8d1b2 Add the ability to extract OR indexscan conditions from OR-of-AND join conditions in which each OR subclause includes a constraint on the same relation. This implements the other useful side-effect of conversion to CNF format, without its unpleasant side-effects. As per pghackers discussion of a few weeks ago. Tom Lane 2004-01-05 05:07:36 +00:00
  • bf488a6842 Update for 7.4.1 as newest version. Bruce Momjian 2004-01-05 00:54:24 +00:00
  • 0b7bc6288f Correct gettext URL. Peter Eisentraut 2004-01-04 16:44:22 +00:00
  • a7b30b9c48 Correct gettext URL. Peter Eisentraut 2004-01-04 16:43:52 +00:00
  • 630f23962b Fixed bug in GRANT OPTION FOR parsing. Michael Meskes 2004-01-04 14:50:13 +00:00
  • 40417169ba Fixed bug in GRANT OPTION FOR parsing. Michael Meskes 2004-01-04 14:49:06 +00:00
  • 187b190adb There's no longer any good reason for genbki.sh and Gen_fmgrtab.sh to run the data through cpp, and we know of at least one platform where unusual cpp behavior breaks the process. So remove the cpp step, and make consequent simplifications. Tom Lane 2004-01-04 05:57:21 +00:00
  • cd632c983e Fix portability bugs: char values passed to <ctype.h> functions must be cast to unsigned char. We have learned this the hard way before. Tom Lane 2004-01-04 04:17:14 +00:00
  • 4351f8823d Fix portability bugs: char values passed to <ctype.h> functions must be cast to unsigned char. We have learned this the hard way before. Tom Lane 2004-01-04 04:17:01 +00:00
  • 71caa53674 Fix discrepancy in prototypes for HPUX pg_dlerror. Tom Lane 2004-01-04 04:06:45 +00:00
  • 558ed5aee1 Fix discrepancy in prototypes for HPUX pg_dlerror. Tom Lane 2004-01-04 04:06:37 +00:00
  • 1af7b00169 Fix ReadOffset() to work correctly when off_t is wider than int. Tom Lane 2004-01-04 04:02:22 +00:00
  • 9a4ef0c562 Fix ReadOffset() to work correctly when off_t is wider than int. Tom Lane 2004-01-04 04:02:15 +00:00
  • 82b4dd394f Merge restrictlist_selectivity into clauselist_selectivity by teaching the latter to accept either RestrictInfo nodes or bare clause expressions; and cache the selectivity result in the RestrictInfo node when possible. This extends the caching behavior of approx_selectivity to many more contexts, and should reduce duplicate selectivity calculations. Tom Lane 2004-01-04 03:51:52 +00:00
  • 21a1202281 Remove trailing newline from file. Bruce Momjian 2004-01-04 00:50:11 +00:00
  • 3d5c2692e7 Remove trailing semicolons from macro initializations in plpython. Bruce Momjian 2004-01-04 00:14:55 +00:00
  • f04af68e54 Remove trailing semicolons from macro initializations in plpython. Bruce Momjian 2004-01-04 00:14:17 +00:00
  • e3107b2844 Mention grabbing typedefs from pgsql/lib too. Bruce Momjian 2004-01-04 00:11:29 +00:00
  • 6cb1c0238b Rewrite OR indexscan processing to be more flexible. We can now for the first time generate an OR indexscan for a two-column index when the WHERE condition is like 'col1 = foo AND (col2 = bar OR col2 = baz)' --- before, the OR had to be on the first column of the index or we'd not notice the possibility of using it. Some progress towards extracting OR indexscans from subclauses of an OR that references multiple relations, too, although this code is #ifdef'd out because it needs more work. Tom Lane 2004-01-04 00:07:32 +00:00
  • 037e2fcf8f Must test for __hppa__ as well as __hppa to make linux-hppa happy. Tom Lane 2004-01-03 05:47:44 +00:00
  • 8265a1d816 Do an explicit fflush after writing a progress message with puts. This ensures stdout is kept in sync with messages on stderr. Per report from Olaf Ferger. Tom Lane 2004-01-01 19:27:28 +00:00
  • b3c3b5464d Do an explicit fflush after writing a progress message with puts. This ensures stdout is kept in sync with messages on stderr. Per report from Olaf Ferger. Tom Lane 2004-01-01 19:27:15 +00:00
  • f40aa225bd Backpatch Solaris non-gcc thread compile fix to 7.4.X. Bruce Momjian 2004-01-01 17:35:32 +00:00
  • 8042c79fd1 Make Solaris non-gcc thread flag "-mt" a compile flag, not a link flag. Bruce Momjian 2003-12-31 16:14:44 +00:00
  • be6c38b903 Adjust the definition of RestrictInfo's left_relids and right_relids fields: now they are valid whenever the clause is a binary opclause, not only when it is a potential join clause (there is a new boolean field canjoin to signal the latter condition). This lets us avoid recomputing the relid sets over and over while examining indexes. Still more work to do to make this as useful as it could be, because there are places that could use the info but don't have access to the RestrictInfo node. Tom Lane 2003-12-30 23:53:15 +00:00
  • 5e54515167 Recommend SHOW, instead of pg_controldata, for checking LC_COLLATE and LC_CTYPE settings of a database. Tom Lane 2003-12-30 23:36:19 +00:00
  • cf4d324d02 Add "-mt" link flag for Solaris non-gcc compiles when using threads --- required. Bruce Momjian 2003-12-30 23:13:51 +00:00
  • 9888192fb7 Instead of trying to force WHERE clauses into CNF or DNF normal form, just look for common clauses that can be pulled out of ORs. Per recent discussion, extracting common clauses seems to be the only really useful effect of normalization, and if we do it explicitly then we can avoid cluttering the qual with partially-redundant duplicated expressions, which was an unpleasant side-effect of the old approach. Tom Lane 2003-12-30 21:49:19 +00:00
  • 7302130179 Avoid running out of memory during hash_create, by not passing a number-of-buckets that exceeds the size we actually plan to allow the hash table to grow to. Per trouble report from Sean Shanny. Tom Lane 2003-12-30 20:05:15 +00:00
  • 7af16b2a25 Avoid running out of memory during hash_create, by not passing a number-of-buckets that exceeds the size we actually plan to allow the hash table to grow to. Per trouble report from Sean Shanny. Tom Lane 2003-12-30 20:05:05 +00:00
  • e8aa10ee47 ShmemInitHash forgot to specify HASH_ALLOC flag bit in its hash_create call. You'd think this would cause some problems, but because of the way hash_create is coded, the only side-effect was creation of a useless memory context for the hashtable. Tom Lane 2003-12-30 00:03:03 +00:00
  • ea43da5138 Use hash table name, not one-size-fits-all 'DynaHashTable', to identify memory contexts belonging to hash tables. Makes the memory stats printout a little more useful. Tom Lane 2003-12-29 23:54:22 +00:00
  • 5c5b911fcc Using canonicalize_qual() to get rid of duplicate index predicate conditions is overkill; set_union() does the job about as well, and much more efficiently. Furthermore this avoids assuming that canonicalize_qual() will check for duplicate clauses at all, which it may not always do. Tom Lane 2003-12-29 22:22:45 +00:00
  • b53ca9bbcb Improve comment. Tom Lane 2003-12-29 21:44:49 +00:00
  • 07f9f4d413 Tweak OpernameGetCandidates() to reduce palloc overhead --- profiling showed that for common operator names such as '=', the pallocs done by this routine occupied a surprisingly large fraction of the total time for the parser to process an operator. Tom Lane 2003-12-29 21:33:09 +00:00
  • 386258d3e5 Added missing whitespaces to array argument parsing. Michael Meskes 2003-12-29 13:53:17 +00:00
  • 21b3c0e0ec Added missing whitespaces to array argument parsing. Michael Meskes 2003-12-29 13:53:04 +00:00
  • c607bd693f Clean up the usage of canonicalize_qual(): in particular, be consistent about whether it is applied before or after eval_const_expressions(). I believe there were some corner cases where the system would fail to recognize that a partial index is applicable because of the previous inconsistency. Store normal rather than 'implicit AND' representations of constraints and index predicates in the catalogs. initdb forced due to representation change of constraints/predicates. Tom Lane 2003-12-28 21:57:37 +00:00
  • 9c08d8fe56 Fix sanity-check code that mistakenly assumed error and notice messages could never exceed 30K. Per report from Andreas Pflug. Tom Lane 2003-12-28 17:44:05 +00:00
  • d167fb1015 Fix sanity-check code that mistakenly assumed error and notice messages could never exceed 30K. Per report from Andreas Pflug. Tom Lane 2003-12-28 17:43:57 +00:00
  • 2315548ed7 Avoid infinite loop if connection is lost during PQexecStart() or PQexecFinish(). Per report from Andreas Pflug. Tom Lane 2003-12-28 17:29:51 +00:00
  • 36c9a01acf Avoid infinite loop if connection is lost during PQexecStart() or PQexecFinish(). Per report from Andreas Pflug. Tom Lane 2003-12-28 17:29:41 +00:00
  • f8eed65dfb Improve spinlock code for recent x86 processors: insert a PAUSE instruction in the s_lock() wait loop, and use test before test-and-set in TAS() macro to avoid unnecessary bus traffic. Patch from Manfred Spraul, reworked a bit by Tom. Tom Lane 2003-12-27 20:58:58 +00:00
  • 2cdace962b Remove incorrect remark about having to restart backend to load a new version of a shared library. Tom Lane 2003-12-27 18:20:18 +00:00
  • debeb47c92 Be a little more consistent about which terms are uppercased in index entries. Tom Lane 2003-12-26 21:30:48 +00:00
  • 99827af7e0 Fixed docs to clearly note that ecpg is originally a C precompiler and C++ stuff is not 100%. Michael Meskes 2003-12-26 20:00:00 +00:00
  • aeddc2a60d Continued rearrangement to permit pgstat + BootstrapMain processes to be fork/exec'd, in the same mode as the previous patch for backends. Bruce Momjian 2003-12-25 03:52:51 +00:00
  • 3e32e9476f Patch that makes quoting "sameuser", "samegroup", and "all" remove special meaning of these terms in pg_hba.conf. Bruce Momjian 2003-12-25 03:44:05 +00:00
  • 1c757c49fa > > I have no idea if this in Oracle or not. But it's something I > > needed, and other people in the past asked about it too. > > It is in Oracle, but you aren't exactly on the spot. It should be > > IYYY - 4 digits ('2003') > IYY - 3 digits ('003') > IY - 2 digits ('03') > I - 1 digit ('3') Bruce Momjian 2003-12-25 03:36:24 +00:00
  • a8c003ea9d Fixed segfault in parsing of EXEC SQL SELECT * FROM foo() AS TBL( c int, i int); Michael Meskes 2003-12-24 22:05:06 +00:00
  • 03caf7649b Fixed segfault in parsing of EXEC SQL SELECT * FROM foo() AS TBL( c int, i int); Michael Meskes 2003-12-24 22:04:09 +00:00