summaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAgeFilesLines
* Arrange for hash join to skip scanning the outer relation if it detectsTom Lane2004-09-223-14/+27
| | | | | that the inner one is completely empty. Per recent discussion. Also some cosmetic cleanups in nearby code.
* Issue a CHECKPOINT just after creating the regression database. WithoutTom Lane2004-09-221-1/+5
| | | | | | | this, it's hard to debug core-dump test failures, because WAL replay will enthusiastically remove the core file (along with the rest of the regression database directory). Per recent discussion, not to mention bitter experience.
* Adjust ExecMakeTableFunctionResult to produce a single all-nulls rowTom Lane2004-09-222-50/+78
| | | | | | | | when a function that returns a single tuple (not a setof tuple) returns NULL. This seems to be the most consistent behavior. It would have taken a bit less code to make it return an empty table (zero rows) but ISTM a non-SETOF function ought always return exactly one row. Per bug report from Ivan-Sun1.
* Minor cleanup of libpq/LO examples: fix some memory leaks, update a commentNeil Conway2004-09-223-9/+11
| | | | or two.
* Some improvements for the tab-completion of psql. This shouldNeil Conway2004-09-221-15/+125
| | | | | | | | | | | | | | | | | | | | address all of the items in the todo list and adds some new things as well. Specifically: * Add support for ALTER SEQUENCE ... * Add "RENAME TO" for ALTER TRIGGER xx ON yy * Pick proper table for ALTER TRIGGER xx ON ... * Support for ALTER USER xxx ... * Fix ALTER GROUP xxx DROP ... * Fix ALTER DOMAIN xxx DROP ... * Remove "OWNER TO" from ALTER DOMAIN xx DROP ... * Fix ALTER DOMAIN xx SET DEFAULT .. * Prevent ALTER INDEX xxx SET TABLESPACE from using "TO" * Support for ALTER LANGUAGE xxx (RENAME TO) * More support for ALTER TABLE xxx ALTER COLUMN xxx ... * More support for COPY Greg Sabino Mullane
* This patch from Alvaro Herrera adds transaction ID to the list ofNeil Conway2004-09-223-6/+20
| | | | | | log_line_prefix escapes. The escape sequence used for this is %x. %x previously meant "postmaster et al. stop here" -- this has been renamed to %q.
* Clarify TODO item: we ought to implement updatable views per SQL99, notNeil Conway2004-09-211-1/+1
| | | | | SQL92 (the former defines a much more ambitious subset of views that need to be updatable).
* Rotate on time boundaries that are sensible per local time rather than GMT.Tom Lane2004-09-211-5/+27
| | | | | Also, avoid truncating the file we just wrote into, which might otherwise easily happen at DST boundaries. Ed L. and Tom Lane.
* Change some of the existing plpgsql regression test cases so that theyTom Lane2004-09-202-46/+38
| | | | | exercise dollar quoting and named function parameters. AFAICS we had no tests of either feature before.
* Some editorializing on the docs for the dollar-quoting feature: fixTom Lane2004-09-206-142/+194
| | | | | grammar, don't drop discussions into the middle of unrelated discussions, etc.
* Fix some shortcomings in psql's autocommit-off mode concerning detectionTom Lane2004-09-202-27/+110
| | | | | | | of commands for which a transaction block should not be forced. Recognize VACUUM and other PreventTransactionChain commands; handle nested /* .. */ comments correctly; handle multibyte encodings correctly. Michael Paesold with some kibitzing from Tom Lane.
* Documentation improvements, per Josh Berkus.Tom Lane2004-09-201-1/+5
|
* Translation updatePeter Eisentraut2004-09-2010-1129/+1878
|
* Translation updatesPeter Eisentraut2004-09-205-3538/+3979
|
* Translation updatesPeter Eisentraut2004-09-206-4180/+5703
|
* Translation updatesPeter Eisentraut2004-09-204-660/+804
|
* Now that I look, table 8-1 has some other marginal misstatements in it.Tom Lane2004-09-201-11/+11
| | | | | If we're going to put brackets around optional precision specs in some entries, we'd better do it in all.
* Minor documentation cleanup and improvement.Neil Conway2004-09-2010-26/+56
|
* Add defenses against plpython functions being declared to take or returnTom Lane2004-09-191-7/+27
| | | | | pseudotypes. Not sure why I neglected to add these checks at the same time I added them to the other PLs, but it seems I did.
* Fix estimate_num_groups to be able to use expression-index statisticsTom Lane2004-09-181-72/+112
| | | | when there is an expressional index matching a GROUP BY item.
* Put the brackets in the right places in timestamp entries in table 8-1.Tom Lane2004-09-181-3/+3
| | | | Spotted by Josh Purinton.
* Move comment at end of line to a separate line so trailing tabs don'tPeter Eisentraut2004-09-181-2/+3
| | | | become part of the make variable value.
* Fix memory leak in tokenize_file, per report from Vadim Passynkov.Tom Lane2004-09-181-3/+8
|
* Improve documentation of log rotation options, per Ed L.Tom Lane2004-09-171-11/+30
|
* Add support for GNU/Hurd and GNU/*BSD. For our purposes, they behave justPeter Eisentraut2004-09-172-3/+5
| | | | like Linux; we just need to recognize the system types.
* New config.guess and config.subPeter Eisentraut2004-09-172-64/+109
|
* Allow WIN1250 as server encoding.Peter Eisentraut2004-09-174-30/+40
|
* Here is a patch bringing oid2name into the 21st century.Tom Lane2004-09-172-393/+531
| | | | Alvaro Herrera
* Hashed LEFT JOIN would miss outer tuples with no inner match if the joinTom Lane2004-09-171-5/+7
| | | | | | was large enough to be batched and the tuples fell into a batch where there were no inner tuples at all. Thanks to Xiaoyu Wang for finding a test case that exposed this long-standing bug.
* Now that xmax and cmin are distinct fields again, we should zero xmax whenTom Lane2004-09-171-3/+5
| | | | | | creating a new tuple. This is just for debugging sanity, though, since nothing should be paying any attention to xmax when the HEAP_XMAX_INVALID bit is set.
* Hyperlink a reference to DROP CAST in the CREATE CAST reference page.Neil Conway2004-09-171-2/+3
|
* Make discovery of python_configdir architecture independent. SolutionJoe Conway2004-09-162-3/+24
| | | | from James William Pye.
* Fix oversight: there's no reason for PG_TRY to use sigsetjmp(buf,1)Tom Lane2004-09-161-2/+2
| | | | | since we don't change the signal mask during normal backend operations. Use sigsetjmp(buf,0) to avoid many unnecessary kernel calls.
* Remove contrib/pg_logger, per recent discussion.Tom Lane2004-09-165-129/+1
|
* Remove erroneous Assert, per example from Kris Jurka.Tom Lane2004-09-161-5/+1
|
* Add some marginal tweaks to eliminate memory leakages associated withTom Lane2004-09-166-16/+118
| | | | | subtransactions. Trivial subxacts (such as a plpgsql exception block containing no database access) now demonstrably leak zero bytes.
* RecentXmin is too recent to use as the cutoff point for accessingTom Lane2004-09-165-27/+41
| | | | | | | pg_subtrans --- what we need is the oldest xmin of any snapshot in use in the current top transaction. Introduce a new variable TransactionXmin to play this role. Fixes intermittent regression failure reported by Neil Conway.
* Restructure subtransaction handling to reduce resource consumption,Tom Lane2004-09-1634-917/+1192
| | | | | | | | | | | | | | | | | as per recent discussions. Invent SubTransactionIds that are managed like CommandIds (ie, counter is reset at start of each top transaction), and use these instead of TransactionIds to keep track of subtransaction status in those modules that need it. This means that a subtransaction does not need an XID unless it actually inserts/modifies rows in the database. Accordingly, don't assign it an XID nor take a lock on the XID until it tries to do that. This saves a lot of overhead for subtransactions that are only used for error recovery (eg plpgsql exceptions). Also, arrange to release a subtransaction's XID lock as soon as the subtransaction exits, in both the commit and abort cases. This avoids holding many unique locks after a long series of subtransactions. The price is some additional overhead in XactLockTableWait, but that seems acceptable. Finally, restructure the state machine in xact.c to have a more orthogonal set of states for subtransactions.
* Minor doc tweak: mention that function names can be optionally schema-Neil Conway2004-09-161-2/+2
| | | | qualified.
* Fix a read of uninitialized memory in array_out(). Perform some minorNeil Conway2004-09-163-25/+34
| | | | cosmetic code cleanup at the same time.
* Cosmetic PL/PgSQL fix: declare the second parameter plpgsql_dstring_appendNeil Conway2004-09-143-6/+6
| | | | as a const char *, so that we don't need to cast away a const in gram.y
* Mark as done:Bruce Momjian2004-09-141-4/+4
| | | | | | | | | | < * Point-in-time data recovery using backup and write-ahead log, < * Create native Win32 port, http://momjian.postgresql.org/main/writings/pgsql/project/win32.html > * -Point-in-time data recovery using backup and write-ahead log > * -Create native Win32 port 470c470 < o Fix PL/pgSQL RENAME to work on variables other than OLD/NEW > o Fix PL/pgSQL RENAME to work on variables other than OLD/NEW
* New translationPeter Eisentraut2004-09-142-2/+2821
|
* Translation updatePeter Eisentraut2004-09-141-3764/+5805
|
* Fix contrib/cube and contrib/seg to compile on Windows.Tom Lane2004-09-146-63/+59
| | | | Andreas Pflug
* Fix some minor issues with the new Win32 service code for autovacuum,Tom Lane2004-09-142-21/+32
| | | | and add documentation. Dave Page
* Adjust tsearch2.sql to avoid use of COPY FROM STDIN, so as toTom Lane2004-09-142-65/+63
| | | | simplify life for the Win32 installer. Per Dave Page.
* Win32 compile fix for misc_utils.Tom Lane2004-09-142-1/+9
| | | | Claudio Natoli
* Win32 compile fixes for pgbench, pgcrypto, and tsearch.Tom Lane2004-09-145-19/+34
| | | | Claudio Natoli
* Fix contrib/dbase to compile under Win32. Laurent BallesterTom Lane2004-09-142-3/+6
|
View Lorry Controller Status