1. 05 Sep, 2004 1 commit
  2. 29 Aug, 2004 2 commits
  3. 01 Aug, 2004 1 commit
    • Tom Lane's avatar
      Some mop-up work for savepoints (nested transactions). Store a small · efcaf1e8
      Tom Lane authored
      number of active subtransaction XIDs in each backend's PGPROC entry,
      and use this to avoid expensive probes into pg_subtrans during
      TransactionIdIsInProgress.  Extend EOXactCallback API to allow add-on
      modules to get control at subxact start/end.  (This is deliberately
      not compatible with the former API, since any uses of that API probably
      need manual review anyway.)  Add basic reference documentation for
      SAVEPOINT and related commands.  Minor other cleanups to check off some
      of the open issues for subtransactions.
      Alvaro Herrera and Tom Lane.
      efcaf1e8
  4. 31 Jul, 2004 1 commit
    • Tom Lane's avatar
      plpgsql does exceptions. · beda4814
      Tom Lane authored
      There are still some things that need refinement; in particular I fear
      that the recognized set of error condition names probably has little in
      common with what Oracle recognizes.  But it's a start.
      beda4814
  5. 27 Jul, 2004 1 commit
  6. 21 Jul, 2004 1 commit
    • Tom Lane's avatar
      Invent WAL timelines, as per recent discussion, to make point-in-time · 2042b342
      Tom Lane authored
      recovery more manageable.  Also, undo recent change to add FILE_HEADER
      and WASTED_SPACE records to XLOG; instead make the XLOG page header
      variable-size with extra fields in the first page of an XLOG file.
      This should fix the boundary-case bugs observed by Mark Kirkwood.
      initdb forced due to change of XLOG representation.
      2042b342
  7. 17 Jul, 2004 1 commit
    • Tom Lane's avatar
      Invent ResourceOwner mechanism as per my recent proposal, and use it to · fe548629
      Tom Lane authored
      keep track of portal-related resources separately from transaction-related
      resources.  This allows cursors to work in a somewhat sane fashion with
      nested transactions.  For now, cursor behavior is non-subtransactional,
      that is a cursor's state does not roll back if you abort a subtransaction
      that fetched from the cursor.  We might want to change that later.
      fe548629
  8. 01 Jul, 2004 1 commit
  9. 22 May, 2004 1 commit
  10. 05 Apr, 2004 1 commit
  11. 11 Feb, 2004 1 commit
    • Tom Lane's avatar
      Commit the reasonably uncontroversial parts of J.R. Nield's PITR patch, to · c3c09be3
      Tom Lane authored
      wit: Add a header record to each WAL segment file so that it can be reliably
      identified.  Avoid splitting WAL records across segment files (this is not
      strictly necessary, but makes it simpler to incorporate the header records).
      Make WAL entries for file creation, deletion, and truncation (as foreseen but
      never implemented by Vadim).  Also, add support for making XLOG_SEG_SIZE
      configurable at compile time, similarly to BLCKSZ.  Fix a couple bugs I
      introduced in WAL replay during recent smgr API changes.  initdb is forced
      due to changes in pg_control contents.
      c3c09be3
  12. 26 Jan, 2004 1 commit
  13. 29 Nov, 2003 1 commit
    • PostgreSQL Daemon's avatar
      · 55b11325
      PostgreSQL Daemon authored
      make sure the $Id tags are converted to $PostgreSQL as well ...
      55b11325
  14. 06 Nov, 2003 1 commit
  15. 16 Oct, 2003 1 commit
    • Tom Lane's avatar
      Fix bad interaction between NOTIFY processing and V3 extended query · 90b22029
      Tom Lane authored
      protocol, per report from Igor Shevchenko.  NOTIFY thought it could
      do its thing if transaction blockState is TBLOCK_DEFAULT, but in
      reality it had better check the low-level transaction state is
      TRANS_DEFAULT as well.  Formerly it was not possible to wait for the
      client in a state where the first is true and the second is not ...
      but now we can have such a state.  Minor cleanup in StartTransaction()
      as well.
      90b22029
  16. 28 Sep, 2003 1 commit
  17. 08 Aug, 2003 1 commit
  18. 04 Aug, 2003 2 commits
  19. 14 May, 2003 1 commit
  20. 12 May, 2003 1 commit
  21. 26 Apr, 2003 1 commit
  22. 10 Jan, 2003 1 commit
  23. 18 Nov, 2002 1 commit
  24. 13 Nov, 2002 1 commit
  25. 21 Oct, 2002 1 commit
  26. 30 Aug, 2002 1 commit
    • Tom Lane's avatar
      AUTOCOMMIT mode is now an available backend GUC variable; setting it · 26993b29
      Tom Lane authored
      to false provides more SQL-spec-compliant behavior than we had before.
      I am not sure that setting it false is actually a good idea yet; there
      is a lot of client-side code that will probably be broken by turning
      autocommit off.  But it's a start.
      
      Loosely based on a patch by David Van Wie.
      26993b29
  27. 20 Jun, 2002 1 commit
  28. 21 May, 2002 1 commit
    • Tom Lane's avatar
      Remove global variable scanCommandId in favor of storing a command ID · 959e61e9
      Tom Lane authored
      in snapshots, per my proposal of a few days ago.  Also, tweak heapam.c
      routines (heap_insert, heap_update, heap_delete, heap_mark4update) to
      be passed the command ID to use, instead of doing GetCurrentCommandID.
      For catalog updates they'll still get passed current command ID, but
      for updates generated from the main executor they'll get passed the
      command ID saved in the snapshot the query is using.  This should fix
      some corner cases associated with functions and triggers that advance
      current command ID while an outer query is still in progress.
      959e61e9
  29. 01 Apr, 2002 1 commit
    • Tom Lane's avatar
      Create a new GUC variable search_path to control the namespace search · 838fe25a
      Tom Lane authored
      path.  The default behavior if no per-user schemas are created is that
      all users share a 'public' namespace, thus providing behavior backwards
      compatible with 7.2 and earlier releases.  Probably the semantics and
      default setting will need to be fine-tuned, but this is a start.
      838fe25a
  30. 05 Nov, 2001 1 commit
  31. 28 Oct, 2001 1 commit
  32. 25 Oct, 2001 1 commit
  33. 18 Oct, 2001 1 commit
    • Thomas G. Lockhart's avatar
      Accept an INTERVAL argument for SET TIME ZONE per SQL99. · 9310075a
      Thomas G. Lockhart authored
       Modified the parser and the SET handlers to use full Node structures
       rather than simply a character string argument.
      Implement INTERVAL() YEAR TO MONTH (etc) syntax per SQL99.
       Does not yet accept the goofy string format that goes along with, but
       this should be fairly straight forward to fix now as a bug or later
       as a feature.
      Implement precision for the INTERVAL() type.
       Use the typmod mechanism for both of INTERVAL features.
      Fix the INTERVAL syntax in the parser:
       opt_interval was in the wrong place.
      INTERVAL is now a reserved word, otherwise we get reduce/reduce errors.
      Implement an explicit date_part() function for TIMETZ.
       Should fix coersion problem with INTERVAL reported by Peter E.
      Fix up some error messages for date/time types.
       Use all caps for type names within message.
      Fix recently introduced side-effect bug disabling 'epoch' as a recognized
       field for date_part() etc. Reported by Peter E. (??)
      Bump catalog version number.
      Rename "microseconds" current transaction time field
       from ...Msec to ...Usec. Duh!
      date/time regression tests updated for reference platform, but a few
       changes will be necessary for others.
      9310075a
  34. 28 Sep, 2001 1 commit
    • Thomas G. Lockhart's avatar
      Measure the current transaction time to milliseconds. · 6f58115d
      Thomas G. Lockhart authored
      Define a new function, GetCurrentTransactionStartTimeUsec() to get the time
       to this precision.
      Allow now() and timestamp 'now' to use this higher precision result so
       we now have fractional seconds in this "constant".
      Add timestamp without time zone type.
      Move previous timestamp type to timestamp with time zone.
      Accept another ISO variant for date/time values: yyyy-mm-ddThh:mm:ss
       (note the "T" separating the day from hours information).
      Remove 'current' from date/time types; convert to 'now' in input.
      Separate time and timetz regression tests.
      Separate timestamp and timestamptz regression test.
      6f58115d
  35. 26 Aug, 2001 1 commit
  36. 25 Aug, 2001 1 commit
    • Tom Lane's avatar
      Replace implementation of pg_log as a relation accessed through the · 2589735d
      Tom Lane authored
      buffer manager with 'pg_clog', a specialized access method modeled
      on pg_xlog.  This simplifies startup (don't need to play games to
      open pg_log; among other things, OverrideTransactionSystem goes away),
      should improve performance a little, and opens the door to recycling
      commit log space by removing no-longer-needed segments of the commit
      log.  Actual recycling is not there yet, but I felt I should commit
      this part separately since it'd still be useful if we chose not to
      do transaction ID wraparound.
      2589735d
  37. 12 Jul, 2001 1 commit
  38. 22 Mar, 2001 1 commit