hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-04-10 19:57:02 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • c9a6490991 Clean up some leftover problems in pgstattuple: remove unwanted and unportable elog(NOTICE) report, fix install/uninstall sequence. Itagaki Takahiro Tom Lane 2006-09-04 02:03:04 +00:00
  • 57bfb27e60 Fix interval input parser so that fractional weeks and months are cascaded first to days and only what is leftover into seconds. This seems to satisfy the principle of least surprise given the general conversion to three-part interval values --- it was an oversight that these cases weren't dealt with in 8.1. Michael Glaesemann Tom Lane 2006-09-04 01:26:28 +00:00
  • 091fe03775 Code review for UPDATE SET (columnlist) patch. Make it handle as much of the syntax as this fundamentally dead-end approach can, in particular combinations of single and multi column assignments. Improve rather inadequate documentation and provide some regression tests. Tom Lane 2006-09-03 22:37:06 +00:00
  • 676d1b4e67 Remove duplicated index entry. Tom Lane 2006-09-03 22:23:58 +00:00
  • 4ae15f29f7 Fix broken markup. Tom Lane 2006-09-03 22:15:32 +00:00
  • 6ca09ad703 Suppress 'unused variable' warnings created by latest commit. Tom Lane 2006-09-03 19:30:43 +00:00
  • 7781916ab5 Fix non-improvement of description of archive_timeout. archive_command is only invoked on completed WAL segments, period --- there's no 'by default' about it. Tom Lane 2006-09-03 19:06:15 +00:00
  • 8fad2e3ff4 Arrange for GetSnapshotData to copy live-subtransaction XIDs from the PGPROC array into snapshots, and use this information to avoid visits to pg_subtrans in HeapTupleSatisfiesSnapshot. This appears to solve the pg_subtrans-related context swap storm problem that's been reported by several people for 8.1. While at it, modify GetSnapshotData to not take an exclusive lock on ProcArrayLock, as closer analysis shows that shared lock is always sufficient. Itagaki Takahiro and Tom Lane Tom Lane 2006-09-03 15:59:39 +00:00
  • f79f57a0af Remove: Bruce Momjian 2006-09-03 13:37:38 +00:00
  • 246bd83811 Synced parser. Added another regression test and fixed tcp test. Michael Meskes 2006-09-03 12:24:08 +00:00
  • fc51c9186a Properly round months into days and into seconds for interval multiplication/division queries like select '41 mon 10:00:00'::interval / 10 as "pos". Bruce Momjian 2006-09-03 03:34:04 +00:00
  • 5120f88c88 Reverted: Bruce Momjian 2006-09-03 03:26:42 +00:00
  • 0e20c48561 Revert FETCH/MOVE int64 patch. Was using incorrect checks for fetch/move in scan.l. Bruce Momjian 2006-09-03 03:19:45 +00:00
  • d387a07050 Update predicate locking text. Bruce Momjian 2006-09-03 01:59:09 +00:00
  • 1d4abf2175 Fix case where "PM" to_timestamp() mask was eating too many characters. Report from Josh Tolley. Bruce Momjian 2006-09-03 01:22:56 +00:00
  • 754c7d53a4 Fix LLONG_MAX define used by new int64 FETCH/MOVE patch. Bruce Momjian 2006-09-03 01:15:40 +00:00
  • b0e5468448 Remove unnecessary copyObject() call in update (values) code. Bruce Momjian 2006-09-03 00:46:41 +00:00
  • 18f2e0351a Add: Bruce Momjian 2006-09-02 23:47:39 +00:00
  • e0938c3f5b Make autovacuum behavior more agressive, per discussion on hackers list --- was part of autovacuum default 'on' patch that was reverted, but we want this part. Bruce Momjian 2006-09-02 23:12:16 +00:00
  • 946abc7c68 Update postgresql.conf line for default superuser_reserved_connections. Bruce Momjian 2006-09-02 23:08:36 +00:00
  • 1a84952670 Change "superuser_reserved_connections" default to 3, because of possible autovacuum use. Bruce Momjian 2006-09-02 23:04:20 +00:00
  • 1f57aac024 Add URL for autovacuum default: Bruce Momjian 2006-09-02 22:59:00 +00:00
  • 0c4f2894f9 Use '' rather than \' for literal single quotes in strings in /contrib/tsearch2. Bruce Momjian 2006-09-02 22:03:30 +00:00
  • 4b636e35a5 Wording improvements for archive_timeout. Bruce Momjian 2006-09-02 21:11:26 +00:00
  • 52a3ed9fac Added async query capability. Original patch by Kai Londenberg, modified by Joe Conway Joe Conway 2006-09-02 21:11:15 +00:00
  • 1cc9299a7a Small code cleanup for recent UPDATE SET (values) patch. Bruce Momjian 2006-09-02 20:52:01 +00:00
  • 6e8596a146 Add UPDATE tab SET ROW (col, ...) = (val, ...) for updating multiple columns Bruce Momjian 2006-09-02 20:34:47 +00:00
  • 9e522d0816 Update: Bruce Momjian 2006-09-02 20:31:50 +00:00
  • 6c785d599d Change FETCH/MOVE to use int8. Bruce Momjian 2006-09-02 18:17:18 +00:00
  • 87eb130ad8 Revert as not needed/inconsistent with SQL REINDEX: Bruce Momjian 2006-09-02 17:10:17 +00:00
  • e35ea516a4 Remove GUC_REPORT for new "server_version_num" GUC variable. Added overhead for every connection, per Tom. Bruce Momjian 2006-09-02 17:08:10 +00:00
  • 917bbebf7f Apply a simple solution to the problem of making INSERT/UPDATE/DELETE RETURNING play nice with views/rules. To wit, have the rule rewriter rewrite any RETURNING clause found in a rule to produce what the rule's triggering query asked for in its RETURNING clause, in particular drop the RETURNING clause if no RETURNING in the triggering query. This leaves the responsibility for knowing how to produce the view's output columns on the rule author, without requiring any fundamental changes in rule semantics such as adding new rule event types would do. The initial implementation constrains things to ensure that there is exactly one, unconditionally invoked RETURNING clause among the rules for an event --- later we might be able to relax that, but for a post feature freeze fix it seems better to minimize how much invention we do. Per gripe from Jaime Casanova. Tom Lane 2006-09-02 17:06:52 +00:00
  • 74924d29fa Add functions to /contrib/pgstattuple that show index statistics and index page contents. Bruce Momjian 2006-09-02 17:05:29 +00:00
  • 04912899e7 Add new variable "server_version_num", which is almost the same as "server_version" but uses the handy PG_VERSION_NUM which allows apps to do things like if ($version >= 80200) without having to parse apart the value of server_version themselves. Bruce Momjian 2006-09-02 13:12:50 +00:00
  • bb7be1ee10 Update wording: Bruce Momjian 2006-09-02 12:31:10 +00:00
  • 819f22a302 Allow PL/python to return composite types and result sets Bruce Momjian 2006-09-02 12:30:01 +00:00
  • b1620c538d Done: Bruce Momjian 2006-09-02 12:29:18 +00:00
  • 5e33d6df36 Suppress some NOTICE messages from REINDEX command. Bruce Momjian 2006-09-02 02:43:07 +00:00
  • 152dbad1eb Clean up rather sloppy fix in HEAD for the ancient bug that CREATE CONVERSION didn't create a dependency from the new conversion to its schema. Back-patch to all supported releases. Tom Lane 2006-08-31 17:32:01 +00:00
  • 67b74fa7c7 Clean up rather sloppy fix in HEAD for the ancient bug that CREATE CONVERSION didn't create a dependency from the new conversion to its schema. Back-patch to all supported releases. Tom Lane 2006-08-31 17:31:55 +00:00
  • 220db233f8 Clean up rather sloppy fix in HEAD for the ancient bug that CREATE CONVERSION didn't create a dependency from the new conversion to its schema. Back-patch to all supported releases. Tom Lane 2006-08-31 17:31:48 +00:00
  • 1e64862ab3 Clean up rather sloppy fix in HEAD for the ancient bug that CREATE CONVERSION didn't create a dependency from the new conversion to its schema. Back-patch to all supported releases. Tom Lane 2006-08-31 17:31:40 +00:00
  • a83c71eb24 Clean up rather sloppy fix in HEAD for the ancient bug that CREATE CONVERSION didn't create a dependency from the new conversion to its schema. Back-patch to all supported releases. Tom Lane 2006-08-31 17:31:33 +00:00
  • 4c0bd228fa Repair interpretation of GB as MB. Peter Eisentraut 2006-08-31 15:10:51 +00:00
  • c23be34a25 Attibution addition: Add Karel Zak also for COPY SELECT. Bruce Momjian 2006-08-31 03:17:50 +00:00
  • d22164d4c4 Correct attibution: Bruce Momjian 2006-08-31 00:35:32 +00:00
  • 5bb9c25904 Done: Bruce Momjian 2006-08-31 00:34:34 +00:00
  • 85188ab883 Extend COPY to support COPY (SELECT ...) TO ... Tom Lane 2006-08-30 23:34:22 +00:00
  • 0d5065781d Update logging of prepare/execute syntax, per comments from Guillaume Smet. Bruce Momjian 2006-08-30 18:22:02 +00:00
  • 3a6e2ff08a Fix things so that fopen's, not only open's, pass FILE_SHARE_DELETE and other special flags on Windows. May fix intermittent 'Permission denied' errors. Magnus Hagander Tom Lane 2006-08-30 18:06:27 +00:00
  • f6d7ef08a7 Dept. of second thoughts: if query fails part way through, shut down the pager before reporting the error. Tom Lane 2006-08-29 22:48:55 +00:00
  • c2f60711d2 Create a FETCH_COUNT parameter that causes psql to execute SELECT-like queries via a cursor, fetching a limited number of rows at a time and therefore not risking exhausting memory. A disadvantage of the scheme is that 'aligned' output mode will align each group of rows independently leading to odd-looking output, but all the other output formats work reasonably well. Chris Mair, with some additional hacking by moi. Tom Lane 2006-08-29 22:25:08 +00:00
  • 7c5ac5ce22 Separate prepared statement and bind parameters with comma. Bruce Momjian 2006-08-29 20:10:42 +00:00
  • 5f6f70a04f Add autovacuum item: Bruce Momjian 2006-08-29 16:22:03 +00:00
  • ef34386c88 Fix mistyping Teodor Sigaev 2006-08-29 15:50:11 +00:00
  • b0e56b9c0d Fix mistyping Teodor Sigaev 2006-08-29 15:49:00 +00:00
  • 780451b43d Fix mistyping Teodor Sigaev 2006-08-29 15:48:30 +00:00
  • f7efd4ea66 Fix mistyping Teodor Sigaev 2006-08-29 15:47:48 +00:00
  • 0434c46db0 Invent an assign-hook mechanism for psql variables similar to the one existing for backend GUC variables, and use this to eliminate repeated fetching/parsing of psql variables in psql's inner loops. In a trivial test with lots of 'select 1;' commands, psql's CPU time went down almost 10%, although of course the effect on total elapsed time was much less. Per discussion about how to ensure the upcoming FETCH_COUNT patch doesn't cost any performance when not being used. Tom Lane 2006-08-29 15:19:51 +00:00
  • b681bfdd59 Fix BUG #2594: Gin Indexes cause server to crash when it builds on empty table Teodor Sigaev 2006-08-29 14:05:44 +00:00
  • 72a3582522 Add description of tsvector type layout Teodor Sigaev 2006-08-29 13:57:34 +00:00
  • 60a25e6f6f Add description of tsvector type layout Teodor Sigaev 2006-08-29 13:57:11 +00:00
  • 3538b740f3 Remove pos comparison in silly_cmp_tsvector(): it is not a semantically significant Teodor Sigaev 2006-08-29 13:40:11 +00:00
  • 3a214ab0f1 Remove pos comparison in silly_cmp_tsvector(): it is not a semantically significant Teodor Sigaev 2006-08-29 13:39:20 +00:00
  • a3cb2221f3 Fix incorrect length of lexemes in silly_cmp_tsvector() Teodor Sigaev 2006-08-29 13:32:21 +00:00
  • 9711782628 Fix incorrect length of lexemes in silly_cmp_tsvector() Teodor Sigaev 2006-08-29 13:31:54 +00:00
  • cda6d0a8d3 Second try committing the path changes. Michael Meskes 2006-08-29 13:23:27 +00:00
  • 67135eb1ef Removed debug option from pg_regress call. Changed file paths in expected files too. Michael Meskes 2006-08-29 12:33:45 +00:00
  • b1710339ba Fixed parser and library to allow empty database names. Streamlined connection name parsing. Added Joachim's patch to shorten paths before diffing. Michael Meskes 2006-08-29 12:24:52 +00:00
  • ba9f9bf1b1 Revert change to turn autovacuum on by default. Peter Eisentraut 2006-08-29 11:37:47 +00:00
  • f443258d4f Only call log_after_parse() if necessary. Bruce Momjian 2006-08-29 02:32:41 +00:00
  • bc24d5b976 Now bind displays prepare as detail, and execute displays prepare and optionally bind. I re-added the "statement:" label so people will understand why the line is being printed (it is log_*statement behavior). Bruce Momjian 2006-08-29 02:11:30 +00:00
  • 216bb6662a Add URL: Bruce Momjian 2006-08-28 23:22:57 +00:00
  • 22bb6929cd Move to referential integrity section: Bruce Momjian 2006-08-28 23:21:46 +00:00
  • 79222272bb Update: Bruce Momjian 2006-08-28 23:20:35 +00:00
  • 1832cefda1 Fix pgstat_report_waiting() to not dump core if called before pgstat_bestart() has been called; else any lock-block occurring during InitPostgres() is disastrous. I believe this explains recent wasp regression failure; at least it explains the crash I got while trying to duplicate the problem. I also made pgstat_report_activity() safe against the same scenario, just in case. The report_waiting hazard was created by my patch of 19-Aug to include waiting status in pg_stat_activity. Tom Lane 2006-08-28 19:38:09 +00:00
  • ae28cfe673 Partial fix for ecpg's VPATH problems. It compiles and successfully builds all the files needed for its regression tests, but the tests themselves fail because of diffs in the #line directives output by ecpg itself. Not sure what to do about that. Tom Lane 2006-08-28 16:13:11 +00:00
  • fcba3b82e2 Tweak trivial_subqueryscan() to consider a SubqueryScan's targetlist trivial if it contains either Vars referencing the corresponding subplan columns, or Consts equaling the corresponding subplan columns. This lets the planner eliminate the SubqueryScan in some cases generated by generate_setop_tlist(). Tom Lane 2006-08-28 14:32:41 +00:00
  • 88b8110443 Turn autovacuum on by default. (stats_row_level is also on by default.) Threshold and scale factor are cut in half for more aggressive behavior. Peter Eisentraut 2006-08-28 13:37:18 +00:00
  • ea2e263539 Add new return codes SPI_OK_INSERT_RETURNING etc to the SPI API. Fix all the standard PLs to be able to return tuples from FOO_RETURNING statements as well as utility statements that return tuples. Also, fix oversight that SPI_processed wasn't set for a utility statement returning tuples. Per recent discussion. Tom Lane 2006-08-27 23:47:58 +00:00
  • 7a2fe85b03 Add some notes about why it's not a bug that RI_FKey_check calls HeapTupleSatisfiesItself without doing LockBuffer first. This code is a bit fragile, but AFAICS it's not actually broken. Tom Lane 2006-08-27 21:41:21 +00:00
  • e06fda0a8b Add a function GetLockConflicts() to lock.c to report xacts holding locks that would conflict with a specified lock request, without actually trying to get that lock. Use this instead of the former ad hoc method of doing the first wait step in CREATE INDEX CONCURRENTLY. Fixes problem with undetected deadlock and in many cases will allow the index creation to proceed sooner than it otherwise could've. Per discussion with Greg Stark. Tom Lane 2006-08-27 19:14:34 +00:00
  • ca1fd0ea5b Move xact.c's partial support for Lists of TransactionIds into pg_list.h. Needed because lock.c is now going to use the same type of list. Tom Lane 2006-08-27 19:11:46 +00:00
  • 99a5619e7b - Enabled single-quoted connection targets. - Fixed a memory leak/segfault in unsuccessful connection. - Some changes to test files. Michael Meskes 2006-08-27 16:15:42 +00:00
  • 162e8f1fd5 Make saveHistory work properly on OS X when HISTFILE is set to /dev/null. Per discussion with Martin Atukunda. Tom Lane 2006-08-27 15:05:20 +00:00
  • 445a61297e Changed double output. Michael Meskes 2006-08-26 11:50:00 +00:00
  • 32883a5d3c Add blank line. Bruce Momjian 2006-08-25 23:45:02 +00:00
  • 29a517eac9 Add blank line.> Bruce Momjian 2006-08-25 23:44:04 +00:00
  • 9579acbe8b Add: Bruce Momjian 2006-08-25 23:43:46 +00:00
  • ad9674043a Add 'feedback' section heading to xml2. Bruce Momjian 2006-08-25 23:43:11 +00:00
  • 747b82aa6a Fix regression tests: after changing comparing function order is changed. Teodor Sigaev 2006-08-25 07:39:22 +00:00
  • 74dbba701f Fix regression tests: after changing comparing function order is changed. Teodor Sigaev 2006-08-25 07:39:08 +00:00
  • e093dcdd28 Add the ability to create indexes 'concurrently', that is, without blocking concurrent writes to the table. Greg Stark, with a little help from Tom Lane. Tom Lane 2006-08-25 04:06:58 +00:00
  • 2ec2b2caf0 Fix compare bug for tsvector: problem was in aligment. Per Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> and Phil Frost <indigo@bitglue.com> Teodor Sigaev 2006-08-24 17:38:00 +00:00
  • 8f91e2b607 Fix compare bug for tsvector: problem was in aligment. Per Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> and Phil Frost <indigo@bitglue.com> Teodor Sigaev 2006-08-24 17:37:34 +00:00
  • 726ede7370 Add: Bruce Momjian 2006-08-24 16:38:13 +00:00
  • e96df81b17 Synced parser Michael Meskes 2006-08-24 12:31:33 +00:00
  • 8d9cf79437 Needed more stuff from c.h. Michael Meskes 2006-08-24 10:48:21 +00:00
  • e8d1dcbfde Fixed of by one variable size. Michael Meskes 2006-08-24 10:35:58 +00:00
  • b7d5a88dbb Need more defines in ecpg_config.h, patch sent by Rocco Altier <RoccoA@Routescape.com> Michael Meskes 2006-08-24 09:37:07 +00:00