aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Fix oversight: there's no reason for PG_TRY to use sigsetjmp(buf,1)Tom Lane2004-09-16
| | | | | 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-16
|
* Remove erroneous Assert, per example from Kris Jurka.Tom Lane2004-09-16
|
* Add some marginal tweaks to eliminate memory leakages associated withTom Lane2004-09-16
| | | | | 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-16
| | | | | | | 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-16
| | | | | | | | | | | | | | | | | 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-16
| | | | qualified.
* Fix a read of uninitialized memory in array_out(). Perform some minorNeil Conway2004-09-16
| | | | cosmetic code cleanup at the same time.
* Cosmetic PL/PgSQL fix: declare the second parameter plpgsql_dstring_appendNeil Conway2004-09-14
| | | | as a const char *, so that we don't need to cast away a const in gram.y
* Mark as done:Bruce Momjian2004-09-14
| | | | | | | | | | < * 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-14
|
* Translation updatePeter Eisentraut2004-09-14
|
* Fix contrib/cube and contrib/seg to compile on Windows.Tom Lane2004-09-14
| | | | Andreas Pflug
* Fix some minor issues with the new Win32 service code for autovacuum,Tom Lane2004-09-14
| | | | and add documentation. Dave Page
* Adjust tsearch2.sql to avoid use of COPY FROM STDIN, so as toTom Lane2004-09-14
| | | | simplify life for the Win32 installer. Per Dave Page.
* Win32 compile fix for misc_utils.Tom Lane2004-09-14
| | | | Claudio Natoli
* Win32 compile fixes for pgbench, pgcrypto, and tsearch.Tom Lane2004-09-14
| | | | Claudio Natoli
* Fix contrib/dbase to compile under Win32. Laurent BallesterTom Lane2004-09-14
|
* Make pltcl work on Win32. Magnus HaganderTom Lane2004-09-14
|
* Fix small memory leak in psql.Neil Conway2004-09-13
|
* Translation updatePeter Eisentraut2004-09-13
|
* Redesign query-snapshot timing so that volatile functions in READ COMMITTEDTom Lane2004-09-13
| | | | | | | | | | | | | mode see a fresh snapshot for each command in the function, rather than using the latest interactive command's snapshot. Also, suppress fresh snapshots as well as CommandCounterIncrement inside STABLE and IMMUTABLE functions, instead using the snapshot taken for the most closely nested regular query. (This behavior is only sane for read-only functions, so the patch also enforces that such functions contain only SELECT commands.) As per my proposal of 6-Sep-2004; I note that I floated essentially the same proposal on 19-Jun-2002, but that discussion tailed off without any action. Since 8.0 seems like the right place to be taking possibly nontrivial backwards compatibility hits, let's get it done now.
* Translation updatesPeter Eisentraut2004-09-13
|
* Translation updatesPeter Eisentraut2004-09-13
|
* New translationsPeter Eisentraut2004-09-13
|
* New translationPeter Eisentraut2004-09-13
|
* Translation updatesPeter Eisentraut2004-09-13
|
* Fix two typos in comments.Neil Conway2004-09-13
|
* Re-add brace removal code but comment it out so we know why we removedBruce Momjian2004-09-12
| | | | it and have it in case we need it for some special case.
* Remove code that delete braces around single statements.Bruce Momjian2004-09-12
|
* When LockAcquire fails at the stage of creating a proclock object, beTom Lane2004-09-12
| | | | | sure to clean up the already-created lock object, if it has no other references. Avoids possibly-permanent leak of shared memory.
* Renumber SnapshotNow and the other special snapshot codes so thatTom Lane2004-09-11
| | | | | | | | ((Snapshot) NULL) can no longer be confused with a valid snapshot, as per my recent suggestion. Define a macro InvalidSnapshot for 0. Use InvalidSnapshot instead of SnapshotAny as the do-nothing special case for heap_update and heap_delete crosschecks; this seems a little cleaner even though the behavior is really the same.
* Ensure that pg_largeobject references opened by lo_import() or lo_export()Tom Lane2004-09-11
| | | | | will be cleaned up at end of transaction, even when there is no other LO operation in the transaction. Per bug report from Daniel Schuchardt.
* Send thread test output to file descriptor 5 like configure does ratherBruce Momjian2004-09-11
| | | | than /dev/null, which Win32 doesn't have.
* Check for ignored thread compiler options to reduce compiler noise.Bruce Momjian2004-09-11
|
* Done:Bruce Momjian2004-09-10
| | | | | < * Have AFTER triggers execute after the appropriate SQL statement in a > * -Have AFTER triggers execute after the appropriate SQL statement in a
* Fix some problems with restoring databases owned by non-superusers,Tom Lane2004-09-10
| | | | | as per bug #1249; and remove the last vestiges of using \connect to change authorization.
* Fire non-deferred AFTER triggers immediately upon query completion,Tom Lane2004-09-10
| | | | | | | | | | | | | rather than when returning to the idle loop. This makes no particular difference for interactively-issued queries, but it makes a big difference for queries issued within functions: trigger execution now occurs before the calling function is allowed to proceed. This responds to numerous complaints about nonintuitive behavior of foreign key checking, such as http://archives.postgresql.org/pgsql-bugs/2004-09/msg00020.php, and appears to be required by the SQL99 spec. Also take the opportunity to simplify the data structures used for the pending-trigger list, rename them for more clarity, and squeeze out a bit of space.
* Add:Bruce Momjian2004-09-10
| | | | | > * Make row-wise comparisons work per SQL spec >
* Fix #if defineBruce Momjian2004-09-10
|
* Fix palloc call from /port for Cygwin.Bruce Momjian2004-09-10
|
* Properly include port file for Cygwin.Bruce Momjian2004-09-10
|
* Minor cleanup.Bruce Momjian2004-09-10
|
* More cleanup.Bruce Momjian2004-09-10
|
* Use $PORTNAME consistently instead of $host_os, where appropriate.Bruce Momjian2004-09-10
|
* Add:Bruce Momjian2004-09-10
| | | | > * Remove Win32 rename/unlink looping if unnecessary
* Add mention loops over unlink/rename might not be needed.Bruce Momjian2004-09-10
|
* Move undef of rename/unlink so system declarations are unmodified.Bruce Momjian2004-09-10
|
* Adjust quotes for win32 build of psql.Bruce Momjian2004-09-10
|
* Fix two typos in comments.Neil Conway2004-09-10
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 09:49:32 +0000