1. 08 1月, 2006 4 次提交
    • N
      Add a new system view, pg_prepared_statements, that can be used to · 44b928e8
      Neil Conway 提交于
      access information about the prepared statements that are available
      in the current session. Original patch from Joachim Wieland, various
      improvements by Neil Conway.
      
      The "statement" column of the view contains the literal query string
      sent by the client, without any rewriting or pretty printing. This
      means that prepared statements created via SQL will be prefixed with
      "PREPARE ... AS ", whereas those prepared via the FE/BE protocol will
      not. That is unfortunate, but discussion on -patches did not yield an
      efficient way to improve this, and there is some merit in returning
      exactly what the client sent to the backend.
      
      Catalog version bumped, regression tests updated.
      44b928e8
    • T
      Add RelationOpenSmgr() calls to ensure rd_smgr is valid when we try to · afa8f197
      Tom Lane 提交于
      use it.  While it normally has been opened earlier during btree index
      build, testing shows that it's possible for the link to be closed again
      if an sinval reset occurs while the index is being built.
      afa8f197
    • T
      e58a9447
    • T
      During CatCacheRemoveCList, we must now remove any members that are · 7eb54281
      Tom Lane 提交于
      dead and have become unreferenced.  Before 8.1, such members were left
      for AtEOXact_CatCache() to clean up, but now AtEOXact_CatCache isn't
      supposed to have anything to do.  In an assert-enabled build this bug
      leads to an assertion failure at transaction end, but in a non-assert
      build the dead member is effectively just a small memory leak.
      Per report from Jeremy Drake.
      7eb54281
  2. 07 1月, 2006 2 次提交
  3. 06 1月, 2006 11 次提交
    • T
      Release-note updates and copy editing. · 615d99fe
      Tom Lane 提交于
      615d99fe
    • T
      Fix Windows-only postmaster code to reject a connection request and continue, · a7812eb4
      Tom Lane 提交于
      rather than elog(FATAL), when there is no more room in ShmemBackendArray.
      This is a security issue since too many connection requests arriving close
      together could cause the postmaster to shut down, resulting in denial of
      service.  Reported by Yoshiyuki Asaba, fixed by Magnus Hagander.
      a7812eb4
    • T
      Fix broken markup. · bf7faa7c
      Tom Lane 提交于
      bf7faa7c
    • T
      Convert Assert checking for empty page into a regular test and elog. · 2d0475e4
      Tom Lane 提交于
      The consequences of overwriting a non-empty page are bad enough that
      we should not omit this test in production builds.
      2d0475e4
    • T
      Fix ReadBuffer() to correctly handle the case where it's trying to extend · 304160c3
      Tom Lane 提交于
      the relation but it finds a pre-existing valid buffer.  The buffer does not
      correspond to any page known to the kernel, so we *must* do smgrextend to
      ensure that the space becomes allocated.  The 7.x branches all do this
      correctly, but the corner case got lost somewhere during 8.0 bufmgr rewrites.
      (My fault no doubt :-( ... I think I assumed that such a buffer must be
      not-BM_VALID, which is not so.)
      304160c3
    • B
      Add: · 6d41b144
      Bruce Momjian 提交于
      >
      > 	* Allow SERIAL sequences to inherit permissions from the base table?
      6d41b144
    • B
      Add logging control TODO.detail. · 9a47ad1d
      Bruce Momjian 提交于
      9a47ad1d
    • B
      Update: · db6cb1a9
      Bruce Momjian 提交于
      <   stable logging probably can not have indexes.  [wallog]
      >   stable logging probably can not have indexes.  [walcontrol]
      db6cb1a9
    • B
      Update wording: · ac9e14d0
      Bruce Momjian 提交于
      <   STABLE | DEFAULT ].  [wallog]
      >   STABLE | DEFAULT ].  Tables using non-default logging should not use
      >   referential integrity with default-logging tables, and tables using
      >   stable logging probably can not have indexes.  [wallog]
      ac9e14d0
    • B
      Update wording: · e7893db5
      Bruce Momjian 提交于
      <   the table. Another option is to avoid transaction logging entirely
      <   and truncate or drop the table on crash recovery.  These should be
      <   implemented using ALTER TABLE, e.g. ALTER TABLE PERSISTENCE [ DROP |
      <   TRUNCATE | STABLE | DEFAULT ].  [wallog]
      >   the table.  This would affect COPY, and perhaps INSERT/UPDATE too.
      >   Another option is to avoid transaction logging entirely and truncate
      >   or drop the table on crash recovery.  These should be implemented
      >   using ALTER TABLE, e.g. ALTER TABLE PERSISTENCE [ DROP | TRUNCATE |
      >   STABLE | DEFAULT ].  [wallog]
      e7893db5
    • B
      Add: · 1b736817
      Bruce Momjian 提交于
      >
      > * Allow control over which tables are WAL-logged
      >
      >   Allow tables to bypass WAL writes and just fsync() dirty pages on
      >   commit.  To do this, only a single writer can modify the table, and
      >   writes must happen only on new pages.  Readers can continue accessing
      >   the table. Another option is to avoid transaction logging entirely
      >   and truncate or drop the table on crash recovery.  These should be
      >   implemented using ALTER TABLE, e.g. ALTER TABLE PERSISTENCE [ DROP |
      >   TRUNCATE | STABLE | DEFAULT ].  [wallog]
      1b736817
  4. 05 1月, 2006 15 次提交
  5. 04 1月, 2006 6 次提交
  6. 03 1月, 2006 2 次提交