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

Commit Graph

  • 0370951347 Tiny assorted fixes: correct a typo in a comment in vacuumlazy.c, remove some unused #include directives from bufmgr.c, and clarify comments in bufmgr.h and buf.h Neil Conway 2004-04-25 23:50:58 +00:00
  • 1cb7f2ebf3 More thread cleanups. Bruce Momjian 2004-04-25 21:09:08 +00:00
  • bc6ecbfeb3 Add mention to check config.log if thread test failure. Bruce Momjian 2004-04-25 21:04:59 +00:00
  • 6a27640230 Fix typo on thread lib name. Bruce Momjian 2004-04-25 21:03:27 +00:00
  • 45fbab2933 Make thread flags CFLAGS, not CPPFLAGS. Bruce Momjian 2004-04-25 20:57:32 +00:00
  • ae5bc8a601 No need to use our standard libs for the thread test --- they might not be compiled yet. Bruce Momjian 2004-04-25 20:47:56 +00:00
  • 1812d3b233 Remove the last traces of Joe Hellerstein's "xfunc" optimization. Patch from Alvaro Herrera. Also, removed lispsort.c, since it is no longer used. Neil Conway 2004-04-25 18:23:57 +00:00
  • a3015829ee Fix typo in libpq docs. Neil Conway 2004-04-24 22:58:40 +00:00
  • f0c3a09ab3 Document that PQoidValue(), PQcmdTuples(), and PQoidStatus() now work when the command that generated the PGresult was an EXECUTE of an appropriate prepared statement. Neil Conway 2004-04-24 22:53:44 +00:00
  • 14684ca28f Ensure getaddrinfo_all returns null result on failure. Tom Lane 2004-04-24 20:10:47 +00:00
  • 2ce964b958 Ensure getaddrinfo_all returns null result on failure. Tom Lane 2004-04-24 20:10:34 +00:00
  • e295c55fae Check for gmake, then make, when doing thread test. Bruce Momjian 2004-04-24 03:09:35 +00:00
  • 1a60128573 Allow updateable ResultSets to support types that aren't directly mappable to Java types, for example cidr. Kris Jurka 2004-04-24 01:54:45 +00:00
  • f5dd5bf297 Add mention to run thread test program if user is experiencing problems with threaded applications. Bruce Momjian 2004-04-24 00:14:28 +00:00
  • f6646efa4c Hook thread_test program run at the end of configure run. Bruce Momjian 2004-04-23 23:58:12 +00:00
  • 95178c8d24 Report error if thread-test is run without having threading enabled in configure. Bruce Momjian 2004-04-23 22:21:49 +00:00
  • 66b42d3028 Improve thread test program. Test only functions that need testing. Bruce Momjian 2004-04-23 20:35:50 +00:00
  • fc7fd50182 Add ceiling() as an alias for ceil(), and power() as an alias for pow(). Regression tests and documentation have both been updated. Neil Conway 2004-04-23 20:32:20 +00:00
  • 7a66015e98 Add new auto-detection of thread flags. Bruce Momjian 2004-04-23 18:15:55 +00:00
  • d8e53bd6c0 Fixed memory misusage in variable handling. Michael Meskes 2004-04-23 06:17:27 +00:00
  • 77528c9bd7 Fixed memory misusage in variable handling. Michael Meskes 2004-04-23 06:17:14 +00:00
  • 1b4e82559c Simplify thread test program. Bruce Momjian 2004-04-22 23:58:03 +00:00
  • 0fa2afa93a Make psql's \d+ command indicate whether the table in question contains OIDs. Also, minor documentation improvements to the psql reference page. Neil Conway 2004-04-22 17:38:16 +00:00
  • b3bc93a4b7 Rename global psql startup file to psqlrc.sample. Bruce Momjian 2004-04-22 14:34:38 +00:00
  • 65b020bd61 Fix filename mention in psqlrc.sample file. Bruce Momjian 2004-04-22 14:33:49 +00:00
  • 19f1649bed Put information about tag in Outputs section, where it belongs. Tom Lane 2004-04-22 11:46:22 +00:00
  • c16fa67c87 Fix typo Peter Eisentraut 2004-04-22 08:36:48 +00:00
  • aee7612fa8 Fix typo Peter Eisentraut 2004-04-22 08:34:13 +00:00
  • 9b6319fdd0 New link for Solaris IPC article Peter Eisentraut 2004-04-22 08:31:36 +00:00
  • 139abc2896 Make LocalRefCount and PrivateRefCount arrays of int32, rather than long. This saves a small amount of per-backend memory for LP64 machines. Neil Conway 2004-04-22 07:21:55 +00:00
  • 2ff4e44043 Improvements to the backup & restore documentation. Neil Conway 2004-04-22 07:02:36 +00:00
  • e3391133ae Update EXECUTE docs to mention tag matches prepared statement. Bruce Momjian 2004-04-22 04:18:41 +00:00
  • b00d50d365 Per discussion earlier today, here is a fix that lets ereport() on win32 report socket errors. Bruce Momjian 2004-04-22 03:51:24 +00:00
  • a4d9d3e028 Attached is are a few small fixes for dbmirror. Bruce Momjian 2004-04-22 03:48:38 +00:00
  • 914042fe5f This patch makes the EXECUTE command's completion tag return the completion tag of the actual statement executed. This allows the correct update count to be returned for UPDATE/INSERT/DELETE statements. Bruce Momjian 2004-04-22 02:58:21 +00:00
  • ec7c4c1b66 Please find attached a small patch so that "pg_restore" ignores some sql errors. This is the second submission, which integrates Tom comments about localisation and exit code. I also added some comments about one sql command which is not ignored. Bruce Momjian 2004-04-22 02:39:10 +00:00
  • be6bbcef56 Add global psql config file, psql.rc.sample. Bruce Momjian 2004-04-22 01:53:37 +00:00
  • 4906841901 Minor improvement to CREATE AGGREGATE docs: add an xref to the docs for builtin aggregate functions. Neil Conway 2004-04-21 21:52:41 +00:00
  • f9a2d0b2fb More thread test program improvements. Bruce Momjian 2004-04-21 20:58:56 +00:00
  • 53b5455387 Improve thread test program to show if non-*_r functions are even called. Bruce Momjian 2004-04-21 20:51:54 +00:00
  • 37fa3b6c89 Tweak indexscan and seqscan code to arrange that steps from one page to the next are handled by ReleaseAndReadBuffer rather than separate ReleaseBuffer and ReadBuffer calls. This cuts the number of acquisitions of the BufMgrLock by a factor of 2 (possibly more, if an indexscan happens to pull successive rows from the same heap page). Unfortunately this doesn't seem enough to get us out of the recently discussed context-switch storm problem, but it's surely worth doing anyway. Tom Lane 2004-04-21 18:24:26 +00:00
  • 95a03e9cdf Another round of code cleanup on bufmgr. Use BM_VALID flag to keep track of whether we have successfully read data into a buffer; this makes the error behavior a bit more transparent (IMHO anyway), and also makes it work correctly for local buffers which don't use Start/TerminateBufferIO. Collapse three separate functions for writing a shared buffer into one. This overlaps a bit with cleanups that Neil proposed awhile back, but seems not to have committed yet. Tom Lane 2004-04-21 18:06:30 +00:00
  • aeee856564 New link for Solaris IPC article Peter Eisentraut 2004-04-21 13:18:28 +00:00
  • 49d3d9cf40 Change COPY CSV keyword to be: Bruce Momjian 2004-04-21 00:34:18 +00:00
  • 2d1221bf89 Done: Bruce Momjian 2004-04-20 20:16:30 +00:00
  • 6022a7d72f Add doc mention that: Bruce Momjian 2004-04-20 16:56:19 +00:00
  • 9b04ddc185 Add NetBSD thread compile flags. Bruce Momjian 2004-04-20 14:36:49 +00:00
  • cfb8d57ba1 Add: Bruce Momjian 2004-04-20 14:03:30 +00:00
  • 8149029162 Improve IS NULL partial index wording. Bruce Momjian 2004-04-20 12:53:28 +00:00
  • 8b10da1056 Done: Bruce Momjian 2004-04-20 04:26:27 +00:00
  • bb18b47390 Document partial indexes for IS NULL lookups. Bruce Momjian 2004-04-20 04:25:47 +00:00
  • 2f2a3439a5 Remove additional tcl doc mention. Bruce Momjian 2004-04-20 01:14:55 +00:00
  • c310d28766 Remove TCL docs. Bruce Momjian 2004-04-20 01:11:49 +00:00
  • 6ef77149f7 > >> My question is whether postgres can index null values, and if not, do I > >> have to accept a full table scan when locating records. > > > > It indexes them, but "is null" is not an indexable operator, so you > > can't directly solve the above with a 3-column index. What you can do > > instead is use a partial index, for instance > > > > create index i on CUSTOMER.WCCustOrderStatusLog (WCOrderStatusID) > > where Acknowledged is null and Processing is null; > > That's a very nifty trick and exactly the sort of answer I was after! Bruce Momjian 2004-04-20 01:00:26 +00:00
  • 6949fc0269 Remove pg_encoding. Not needed anymore since we have an initdb in C. Bruce Momjian 2004-04-20 00:40:06 +00:00
  • 41fa9e9bae Remove all of the libpgtcl and pgtclsh files, including all references to them within the various makefiles PostgreSQL Daemon 2004-04-20 00:33:53 +00:00
  • d1b3915ce1 In reading the 7.4.2 docs, the sql reference page for PREPARE doesn't reference DEALLOCATE in any way. It points to EXECUTE, but not to DEALLOCATE. Suggested fix: Bruce Momjian 2004-04-19 23:36:48 +00:00
  • 011c3e62e7 Code review for ARC patch. Eliminate static variables, improve handling of VACUUM cases so that VACUUM requests don't affect the ARC state at all, avoid corner case where BufferSync would uselessly rewrite a buffer that no longer contains the page that was to be flushed. Make some minor other cleanups in and around the bufmgr as well, such as moving PinBuffer and UnpinBuffer into bufmgr.c where they really belong. Tom Lane 2004-04-19 23:27:17 +00:00
  • 8f73bbae85 Update mention of diff. Bruce Momjian 2004-04-19 23:19:02 +00:00
  • 13b63d3764 Update to my2pg version 1.28, add docs, update URL for newest version. Bruce Momjian 2004-04-19 23:18:12 +00:00
  • 085fa8ac48 Update to my2pg 1.28, from: Bruce Momjian 2004-04-19 23:11:49 +00:00
  • 52e4f27af9 Prevent doubling of escapes when not in quote mode for CSV. Bruce Momjian 2004-04-19 21:58:02 +00:00
  • 1ad590541d The attached patch for contrib/pg_autovacuum/README.pg_autovacuum fixes one apparent error and makes a minor stylistic change that makes it more consistent and makes clear something that confused me :-) Bruce Momjian 2004-04-19 21:30:18 +00:00
  • e60da4bcf6 Remove debug code that acidentally got into CVS from previous commit. Bruce Momjian 2004-04-19 21:22:14 +00:00
  • 09f317539a Fix for BEGIN with ISOLATION/READONLY clauses. Bruce Momjian 2004-04-19 21:21:34 +00:00
  • 31338352bd * Most changes are to fix warnings issued when compiling win32 * removed a few redundant defines * get_user_name safe under win32 * rationalized pipe read EOF for win32 (UPDATED PATCH USED) * changed all backend instances of sleep() to pg_usleep Bruce Momjian 2004-04-19 17:42:59 +00:00
  • 862b20b382 Complete TODO item: Bruce Momjian 2004-04-19 17:22:31 +00:00
  • 83ab1c0475 Done: Bruce Momjian 2004-04-19 17:03:13 +00:00
  • 7931a8fdd1 Fix typo: Bruce Momjian 2004-04-19 15:37:56 +00:00
  • 9086c46f22 Tweak findTargetlistEntry so that bare names occurring in GROUP BY clauses are sought first as local FROM columns, then as local SELECT-list aliases, and finally as outer FROM columns; the former behavior made outer FROM columns take precedence over aliases. This does not change spec conformance because SQL99 allows only the first case anyway, and it seems more useful and self-consistent. Per gripe from Dennis Bjorklund 2004-04-05. Tom Lane 2004-04-18 18:13:31 +00:00
  • b5e52b080c Tweak findTargetlistEntry so that bare names occurring in GROUP BY clauses are sought first as local FROM columns, then as local SELECT-list aliases, and finally as outer FROM columns; the former behavior made outer FROM columns take precedence over aliases. This does not change spec conformance because SQL99 allows only the first case anyway, and it seems more useful and self-consistent. Per gripe from Dennis Bjorklund 2004-04-05. Tom Lane 2004-04-18 18:12:58 +00:00
  • 3e2aef58a2 Handle Warn_restart_ready properly in SIGTERM safety patch. Bruce Momjian 2004-04-16 12:59:05 +00:00
  • 3a14336746 Modify COPY for() loop to use attnum as a variable name, not 'i'. Bruce Momjian 2004-04-15 22:36:03 +00:00
  • 6c72f44c62 Improve syntax error messages for invalid-argument cases in RETURN and RETURN NEXT. Tom Lane 2004-04-15 13:01:45 +00:00
  • 0117ed7d4c Translation updates Peter Eisentraut 2004-04-15 08:15:09 +00:00
  • 2510c867d6 Translation updates Peter Eisentraut 2004-04-15 08:13:00 +00:00
  • a45f9e4e52 Translation updates Peter Eisentraut 2004-04-15 08:04:05 +00:00
  • 77c7e8bcb8 Clarify meaning of second DateStyle value. Bruce Momjian 2004-04-15 04:46:18 +00:00
  • 18229e080c Update name: Bruce Momjian 2004-04-14 19:15:27 +00:00
  • 76e953bd70 Update owners of items: Bruce Momjian 2004-04-14 18:33:03 +00:00
  • a4c40f140d Here's an attempt at new socket and signal code for win32. Bruce Momjian 2004-04-12 16:19:18 +00:00
  • abdabeb995 Change psql \copy stdin/stdout to read from command input/output. Bruce Momjian 2004-04-12 15:58:52 +00:00
  • 7b3189c185 > > This update fixes a few small typos in names, > > pronouns and formatting in the Russian FAQ. Bruce Momjian 2004-04-12 03:22:20 +00:00
  • 3c4ab3f51d Exit backend from SIGTERM or FATAL by simulating client EOF, rather than calling proc_exit() directly. This should make SIGTERM more reliable. Bruce Momjian 2004-04-11 00:54:45 +00:00
  • 1934055cbe Please find a small patch to fix the brain damage "century" and "millennium" date part implementation in postgresql, both in the code and the documentation, so that it conforms to the official definition. If you do not agree with the official definition, please send your complaint to "pope@vatican.org". I'm not responsible for them;-) Bruce Momjian 2004-04-10 18:02:59 +00:00
  • 296f485492 Remove libpgeasy and odbc doc reference in filelist.sgml --- removed to gborg. Bruce Momjian 2004-04-09 18:03:13 +00:00
  • 4bd3f0744d Translation updates Dennis Bjorklund 2004-04-09 06:49:35 +00:00
  • 0469e9e086 Translation updates Dennis Bjorklund 2004-04-09 05:54:01 +00:00
  • 60282569f4 Magnus says new Win32 timezone library will not need special horology: Bruce Momjian 2004-04-08 23:00:55 +00:00
  • 14bd7a0181 Add SQL 2003 standards. Bruce Momjian 2004-04-07 23:32:30 +00:00
  • 9fa14b1ea0 Remove bad URL. Bruce Momjian 2004-04-07 22:02:03 +00:00
  • d17c92b24f Update: Bruce Momjian 2004-04-07 19:14:21 +00:00
  • 1f12abbc7d Push superuser check farther down in the if() statements to fix startup crash with debug in log_statement patch. Bruce Momjian 2004-04-07 18:52:26 +00:00
  • d9bbf47aaa Still another place to make the world safe for zero-column tables. Per example from Jiang Wei. Tom Lane 2004-04-07 18:46:20 +00:00
  • 0bb21d391c Still another place to make the world safe for zero-column tables. Per example from Jiang Wei. Tom Lane 2004-04-07 18:46:12 +00:00
  • 75688a27d2 Add: Bruce Momjian 2004-04-07 18:34:44 +00:00
  • e675a23688 Update Darwin thread compile flags, and OS version info. Bruce Momjian 2004-04-07 18:31:59 +00:00
  • 9b3bc35f82 Update darwin OS version. Bruce Momjian 2004-04-07 18:30:59 +00:00
  • 989067bd22 Extend set-operation planning to keep track of the sort ordering induced by the set operation, so that redundant sorts at higher levels can be avoided. This was foreseen a good while back, but not done. Per request from Karel Zak. Tom Lane 2004-04-07 18:17:25 +00:00
  • 5d1af6aee3 build_subquery_pathkeys() was examining wrong copy of subquery target list, causing it to fail to recognize the output ordering of subqueries that contain set operations (UNION/INTERSECT/EXPECT). Per example from Karel Zak. Tom Lane 2004-04-07 17:42:28 +00:00