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

Commit Graph

  • 1fa6be6f69 ynced parser and keyword list. Implemented EXEC SQL UNDEF. Applied first version of the regression test patch by Joachim Wieland <joe@mcknight.de>. Michael Meskes 2006-08-02 13:43:23 +00:00
  • 97eefd6996 Update: Bruce Momjian 2006-08-02 13:36:45 +00:00
  • f05fc17cf4 Add: Bruce Momjian 2006-08-02 13:29:54 +00:00
  • b5a5524342 Done: Bruce Momjian 2006-08-02 03:11:54 +00:00
  • 9caafda579 Add support for multi-row VALUES clauses as part of INSERT statements (e.g. "INSERT ... VALUES (...), (...), ...") and elsewhere as allowed by the spec. (e.g. similar to a FROM clause subselect). initdb required. Joe Conway and Tom Lane. Joe Conway 2006-08-02 01:59:48 +00:00
  • d307c428cb Fix bug I introduced while cleaning up pg_dump -t/-n patch. Bruce Momjian 2006-08-01 21:05:00 +00:00
  • 5f69890e15 Editorialize a bit on the recent patch, reverting to the original versions of the text where appropiate. Alvaro Herrera 2006-08-01 19:17:18 +00:00
  • 2c6d96cef6 Add support for loadable modules to allocated shared memory and lightweight locks. Bruce Momjian 2006-08-01 19:03:11 +00:00
  • c61607bd52 Add pg_dump -X no-data-for-failed-tables option to suppress loading data if table creation failed (the table already exists). Bruce Momjian 2006-08-01 18:21:44 +00:00
  • 6d0f5ea574 Done: Bruce Momjian 2006-08-01 18:07:36 +00:00
  • aa88497a3a Remove TODO.detail/pg_dump. Bruce Momjian 2006-08-01 18:06:27 +00:00
  • 8977b68a42 Allow multiple -n (schema) and -t (table) pg_dump options, and add -T and -N options to exclude objects. Also support regular expressions for option object names. Bruce Momjian 2006-08-01 18:05:04 +00:00
  • 9a4eaa9440 Remove extra argument to printf(). Bruce Momjian 2006-08-01 18:01:36 +00:00
  • a3bae60813 have pg_regress fall back on testing with the canonical results file if an alternative test is specified but none succeeds. Andrew Dunstan 2006-08-01 14:56:29 +00:00
  • 8d5f3c8d89 Improvements to Maintenance and External Projects documentation. Bruce Momjian 2006-08-01 00:09:06 +00:00
  • ffb62be07a Add: Bruce Momjian 2006-07-31 23:04:13 +00:00
  • 09d3670df3 Change the relation_open protocol so that we obtain lock on a relation (table or index) before trying to open its relcache entry. This fixes race conditions in which someone else commits a change to the relation's catalog entries while we are in process of doing relcache load. Problems of that ilk have been reported sporadically for years, but it was not really practical to fix until recently --- for instance, the recent addition of WAL-log support for in-place updates helped. Tom Lane 2006-07-31 20:09:10 +00:00
  • 4cd72b53b9 Added missing ECPGget_sqlca() call Michael Meskes 2006-07-31 13:26:46 +00:00
  • c1c9b7c0c0 First small patches needed for regression tests Michael Meskes 2006-07-31 10:15:31 +00:00
  • 68dfef040b Fix memory allocation bug in pgbench. patches submitted by ITAGAKI Takahiro. Tatsuo Ishii 2006-07-31 05:15:14 +00:00
  • 6e38e34d64 Change the bootstrap sequence so that toast tables for system catalogs are created in the bootstrap phase proper, rather than added after-the-fact by initdb. This is cleaner than before because it allows us to retire the undocumented ALTER TABLE ... CREATE TOAST TABLE command, but the real reason I'm doing it is so that toast tables of shared catalogs will now have predetermined OIDs. This will allow a reasonably clean solution to the problem of locking tables before we load their relcache entries, to appear in a forthcoming patch. Tom Lane 2006-07-31 01:16:38 +00:00
  • 8aa826a965 Fix confusion between COPY FROM and COPY TO, per Gavin Sharry and Arul Shaji. Alvaro Herrera 2006-07-31 01:13:58 +00:00
  • 638860ce35 Fix confusion between COPY FROM and COPY TO, per Gavin Sharry and Arul Shaji. Alvaro Herrera 2006-07-31 01:10:56 +00:00
  • d7295afe5e Fix confusion between COPY FROM and COPY TO, per Gavin Sharry and Arul Shaji. Alvaro Herrera 2006-07-31 01:09:52 +00:00
  • 632db651cb Fix confusion between COPY FROM and COPY TO, per Gavin Sharry and Arul Shaji. Alvaro Herrera 2006-07-31 01:09:48 +00:00
  • 8822263635 Fix a couple of comments. Tom Lane 2006-07-30 20:17:11 +00:00
  • 0bee536ad8 Replaced $Header$ by $§PosgreSQL$ Michael Meskes 2006-07-30 16:28:58 +00:00
  • cdf131abac Added missing $Header$ entries. Michael Meskes 2006-07-30 10:24:10 +00:00
  • 92c2ecc130 Modify snapshot definition so that lazy vacuums are ignored by other vacuums. This allows a OLTP-like system with big tables to continue regular vacuuming on small-but-frequently-updated tables while the big tables are being vacuumed. Alvaro Herrera 2006-07-30 02:07:18 +00:00
  • d6603791ea Add: Bruce Momjian 2006-07-30 01:48:40 +00:00
  • 1a271f0c71 Fix WIN32 wait() return value macros to be accurate, particularly because they are used for testing the return value from system(). (WIN32 doesn't overlay the return code with other failure conditions like Unix does, so they are just simple macros.) Bruce Momjian 2006-07-30 01:45:21 +00:00
  • c33b809765 prevent multiplexing Windows kernel event objects we listen for across various sockets - should fix the occasional stats test regression failures we see. Andrew Dunstan 2006-07-29 20:14:40 +00:00
  • e482136c04 prevent multiplexing Windows kernel event objects we listen for across various sockets - should fix the occasional stats test regression failures we see. Andrew Dunstan 2006-07-29 20:00:00 +00:00
  • 497d39d768 prevent multiplexing Windows kernel event objects we listen for across various sockets - should fix the occasional stats test regression failures we see. Andrew Dunstan 2006-07-29 19:55:18 +00:00
  • 6dd2b7728b Add entry: Bruce Momjian 2006-07-29 18:08:36 +00:00
  • e5ac3d4343 Don't use #include <crtdefs.h> for MSVC <= 1400. Bruce Momjian 2006-07-29 17:35:07 +00:00
  • d06f44a811 Add: Bruce Momjian 2006-07-29 15:56:32 +00:00
  • b554cb75bf Add #include postgres_fe.h in two win32-specific files, because there is pg-specific code in those files, or might be some day. Bruce Momjian 2006-07-29 15:22:27 +00:00
  • 033a477e9e Adjust initialization sequence for timezone_abbreviations so that it's handled just about like timezone; in particular, don't try to read anything during InitializeGUCOptions. Should solve current startup failure on Windows, and avoid wasted cycles if a nondefault setting is specified in postgresql.conf too. Possibly we need to think about a more general solution for handling 'expensive to set' GUC options. Tom Lane 2006-07-29 03:02:56 +00:00
  • 46d9c2ec8f Change the delta val from 0 and 10000 to -5000 and 5000 per recent discussion in hackers list. Also enhance predefined benchmark scenarios to reflect the scaling factor parameter flexibly. Tatsuo Ishii 2006-07-28 22:58:26 +00:00
  • 51175d1d00 Remove update TODO.detail item. Bruce Momjian 2006-07-28 19:28:08 +00:00
  • e1992ebaf2 Updates per Tom: Bruce Momjian 2006-07-28 19:00:45 +00:00
  • 1249cf8f38 SQL2003-standard statistical aggregates, by Sergey Koposov. I've added only the float8 versions of the aggregates, which is all that the standard requires. Sergey's original patch also provided versions using numeric arithmetic, but given the size and slowness of the code, I doubt we ought to include those in core. Tom Lane 2006-07-28 18:33:04 +00:00
  • 271852a021 Fix table title. Tom Lane 2006-07-28 16:22:02 +00:00
  • 0fd087af83 Fix table title. Tom Lane 2006-07-28 16:21:57 +00:00
  • 87953b3d60 Make it clearer that not every Postgres character set can be used as a server-side character set. Tom Lane 2006-07-28 15:33:28 +00:00
  • b8cd6b4f25 Make it clearer that not every Postgres character set can be used as a server-side character set. Tom Lane 2006-07-28 15:33:17 +00:00
  • 4917564f1b Update Tatsuo: Bruce Momjian 2006-07-28 12:24:07 +00:00
  • 76475a7eb5 Variables should be free'ed only once. Michael Meskes 2006-07-28 11:49:36 +00:00
  • a27cb17788 Removed superfluous comment Michael Meskes 2006-07-28 10:12:56 +00:00
  • 9e76b4c7c5 And one more: Connection identifier has to be unique Michael Meskes 2006-07-28 10:10:42 +00:00
  • 72ba3cb50f Added more SoC changes by Joachim Wieland <joe@mcknight.de>: - SHOW statement puts result into a variable - COPY TO STDOUT works Michael Meskes 2006-07-28 09:08:01 +00:00
  • 67cdc61369 Add URL for UPDATE/SET for multiple values. Bruce Momjian 2006-07-27 22:05:49 +00:00
  • 8de82ede51 Add for UPDATE SET for multiple values: Bruce Momjian 2006-07-27 22:01:34 +00:00
  • 5f0473534f Fix incorrect function return code in cube_cmp and cube_dim; update regression expected files to what I think is correct. Tom Lane 2006-07-27 21:55:09 +00:00
  • 9f99edfd7e revert last change - broke non-AIX platforms. Andrew Dunstan 2006-07-27 19:58:39 +00:00
  • 108fe47301 Aggregate functions now support multiple input arguments. I also took the opportunity to treat COUNT(*) as a zero-argument aggregate instead of the old hack that equated it to COUNT(1); this is materially cleaner (no more weird ANYOID cases) and ought to be at least a tiny bit faster. Original patch by Sergey Koposov; review, documentation, simple regression tests, pg_dump and psql support by moi. Tom Lane 2006-07-27 19:52:07 +00:00
  • c2d1138351 another try at keeping AIX/ppc happy on cube test. Andrew Dunstan 2006-07-27 18:38:54 +00:00
  • 596b858fcb fix most regression tests for new cube code. Andrew Dunstan 2006-07-27 16:12:36 +00:00
  • 8aab197840 Original coding of pg_regress.c made the results and log directories with restrictive permissions, which was not the behavior of the shell script and doesn't seem very desirable. Use the umask setting instead. Tom Lane 2006-07-27 15:37:19 +00:00
  • 43c79378c8 Allow LDAP lookups from pg_service.conf. Bruce Momjian 2006-07-27 13:20:24 +00:00
  • b517e65348 Allow units to be specified with configuration settings. Peter Eisentraut 2006-07-27 08:30:41 +00:00
  • a998a69247 Code review for bigint-LIMIT patch. Fix missed planner dependency, eliminate unnecessary code, force initdb because stored rules change (limit nodes are now supposed to be int8 not int4 expressions). Update comments and error messages, which still all said 'integer'. Tom Lane 2006-07-26 19:31:51 +00:00
  • 5ffa0bb47a Reorder items: Bruce Momjian 2006-07-26 17:23:02 +00:00
  • 9a7483714f Work around bug in strxfmt() but in MS VS2005. Bruce Momjian 2006-07-26 17:17:28 +00:00
  • cd2a6b57c0 When a GUC string variable is not set, print the empty string (in SHOW etc.), not "unset". An "unset" state doesn't really exist; all variables behave like an empty string value if the string being pointed to has not been initialized. Peter Eisentraut 2006-07-26 11:39:47 +00:00
  • 79bc99a467 Convert effective_cache_size to an integer, for better integration with upcoming units feature. Peter Eisentraut 2006-07-26 11:35:56 +00:00
  • 0c57c832b9 New features contributed by Tomoaki Sato. Tatsuo Ishii 2006-07-26 07:24:50 +00:00
  • 88b39634cd Done: Bruce Momjian 2006-07-26 00:35:01 +00:00
  • 085e559654 Change LIMIT/OFFSET to use int8 Bruce Momjian 2006-07-26 00:34:48 +00:00
  • 796de9c1ed /contrib/cube improvements: Bruce Momjian 2006-07-25 23:23:45 +00:00
  • e6284649b9 Modify btree to delete known-dead index entries without an actual VACUUM. When we are about to split an index page to do an insertion, first look to see if any entries marked LP_DELETE exist on the page, and if so remove them to try to make enough space for the desired insert. This should reduce index bloat in heavily-updated tables, although of course you still need VACUUM eventually to clean up the heap. Tom Lane 2006-07-25 19:13:00 +00:00
  • edd49fcf69 Add reason for WAL offset reporting: Bruce Momjian 2006-07-25 16:23:42 +00:00
  • 8633a9cdff Add offset mention: Bruce Momjian 2006-07-25 15:27:24 +00:00
  • cb6f5f1552 Update PITR: Bruce Momjian 2006-07-25 15:21:48 +00:00
  • bd112776cd Add missing @OVERRIDE to 'India' config file, per Michael Fuhr. Add $PostgreSQL$ lines for CVS identity, too. Tom Lane 2006-07-25 13:49:21 +00:00
  • a859695b7e Done: Bruce Momjian 2006-07-25 04:11:24 +00:00
  • d8b5c95ca8 Remove hard-wired lists of timezone abbreviations in favor of providing configuration files that can be altered by a DBA. The australian_timezones GUC setting disappears, replaced by a timezone_abbreviations setting (set this to 'Australia' to get the effect of australian_timezones). The list of zone names defined by default has undergone a bit of cleanup, too. Documentation still needs some work --- in particular, should we fix Table B-4, or just get rid of it? Joachim Wieland, with some editorializing by moi. Tom Lane 2006-07-25 03:51:23 +00:00
  • 631ea61883 Use correct ifdef test for cygwin, namely __CYGWIN__ (note underscores). Andrew Dunstan 2006-07-25 01:37:42 +00:00
  • d0e4a076d1 Make the order of operations in PostmasterMain a bit saner ... some recent patches had added stuff in rather random spots. Tom Lane 2006-07-25 01:23:34 +00:00
  • e85b5dae6c Fix spectacular misspellings of procedural language names Peter Eisentraut 2006-07-24 16:55:59 +00:00
  • 6779710f26 Fix spectacular misspellings of procedural language names Peter Eisentraut 2006-07-24 16:55:42 +00:00
  • e9b4969062 DTrace support, with a small initial set of probes Peter Eisentraut 2006-07-24 16:32:45 +00:00
  • 9dc34b5feb Mark postgresql.conf entries that require server restart; some minor editing and reformatting. Peter Eisentraut 2006-07-24 10:44:40 +00:00
  • 20a733d0a0 Remove dubious and redundant (we think) setting of libdir in PATH for non temp-install case. Andrew Dunstan 2006-07-24 01:50:22 +00:00
  • 8dcaea7be0 Add a fudge factor to genericcostestimate() to prevent the planner from thinking that indexes of different sizes are equally attractive. Per gripe from Jim Nasby. (I remain unconvinced that there's such a problem in existing releases, but CVS HEAD definitely has got a problem because of its new count-only-leaf-pages approach to indexscan costing.) Tom Lane 2006-07-24 01:19:48 +00:00
  • a794fb0681 Convert the lock manager to use the new dynahash.c support for partitioned hash tables, instead of the previous kluge involving multiple hash tables. This partially undoes my patch of last December. Tom Lane 2006-07-23 23:08:46 +00:00
  • 69f3a5c9ed Fix oversight in sizing of shared buffer lookup hashtable. Because BufferAlloc tries to insert a new mapping entry before deleting the old one for a buffer, we have a transient need for more than NBuffers entries --- one more in 8.1, and as many as NUM_BUFFER_PARTITIONS more in CVS HEAD. In theory this could lead to an "out of shared memory" failure if shmem had already been completely claimed by the time the extra entries were needed. Tom Lane 2006-07-23 18:34:50 +00:00
  • b25dc481c8 Fix oversight in sizing of shared buffer lookup hashtable. Because BufferAlloc tries to insert a new mapping entry before deleting the old one for a buffer, we have a transient need for more than NBuffers entries --- one more in 8.1, and as many as NUM_BUFFER_PARTITIONS more in CVS HEAD. In theory this could lead to an "out of shared memory" failure if shmem had already been completely claimed by the time the extra entries were needed. Tom Lane 2006-07-23 18:34:45 +00:00
  • 10b9ca3d05 Split the buffer mapping table into multiple separately lockable partitions, as per discussion. Passes functionality checks, but I don't have any performance data yet. Tom Lane 2006-07-23 03:07:58 +00:00
  • 51ee9fa157 Add support to dynahash.c for partitioning shared hashtables according to the low-order bits of the entry hash value. Also make some incidental cleanups in the dynahash API, such as not exporting the hash header structs to the world. Tom Lane 2006-07-22 23:04:39 +00:00
  • eda117dfa0 Hmm, seems --disable-spinlocks has been broken for awhile and nobody noticed. Fix SpinlockSemas() to report the correct count considering that PG 8.1 adds a spinlock to each shared-buffer header. Tom Lane 2006-07-22 21:04:46 +00:00
  • c0e9b3139f Hmm, seems --disable-spinlocks has been broken for awhile and nobody noticed. Fix SpinlockSemas() to report the correct count considering that PG 8.1 adds a spinlock to each shared-buffer header. Tom Lane 2006-07-22 21:04:40 +00:00
  • 98359c3e3f In the recent changes to make the planner account better for cache effects in a nestloop inner indexscan, I had only dealt with plain index scans and the index portion of bitmap scans. But there will be cache benefits for the heap accesses of bitmap scans too, so fix cost_bitmap_heap_scan() to account for that. Tom Lane 2006-07-22 15:41:56 +00:00
  • b0dc1fbbc5 Add libdir to PATH for Cygwin as well as WIN32 - should fix buildfarm eel. Andrew Dunstan 2006-07-22 14:05:20 +00:00
  • 3b2da547e9 For automatic dependency tracking, replace our sed hackery with the GCC- -built-in mechanism through the -MP flag. Adjust the file extensions to look more like Automake practice. This frees up the .d suffix for use by DTrace. Peter Eisentraut 2006-07-21 22:37:37 +00:00
  • 0144eb92bb Add the full set of comparison functions for type TID, including a btree opclass. This is not so much because anyone's likely to create an index on TID, as that sorting TIDs can be useful. Also added max and min aggregates while at it, so that one can investigate the clusteredness of a table with queries like SELECT min(ctid), max(ctid) FROM tab WHERE ... Greg Stark and Tom Lane Tom Lane 2006-07-21 20:51:33 +00:00
  • bc660c4237 Ah, I finally realize why Magnus wanted to add a --bindir option to pg_regress: there's no other way to cope with testing a relocated installation. Seems better to call it --psqldir though, since the only thing we need to find in that case is psql. It'd be better if we could use find_other_exec, but that's not happening unless we are willing to install pg_regress alongside psql, which seems unlikely to happen. Tom Lane 2006-07-21 00:24:04 +00:00
  • 9652b79ae4 Update documentation on GRANT SCEMA USAGE, again. Bruce Momjian 2006-07-20 18:00:03 +00:00
  • 11f6d2fcba As a stopgap to get the Windows buildfarm members running again, hot-wire the check on diff's exit status to check for literally 0 or 1. Someone should look into why WIFEXITED/WEXITSTATUS don't work for this, but I've spent more than enough time on it already. Tom Lane 2006-07-20 16:25:30 +00:00