1. 15 Aug, 2009 3 commits
  2. 14 Aug, 2009 7 commits
  3. 13 Aug, 2009 4 commits
  4. 12 Aug, 2009 6 commits
    • Tom Lane's avatar
      Improve error message for the case where a requested foreign key constraint · b6bde524
      Tom Lane authored
      does match some unique index on the referenced table, but that index is
      only deferrably unique.  We were doing this nicely for the
      default-to-primary-key case, but were being lazy for the other case.
      
      Dean Rasheed
      b6bde524
    • Tom Lane's avatar
    • Tom Lane's avatar
      Allow backends to start up without use of the flat-file copy of pg_database. · 04011cc9
      Tom Lane authored
      To make this work in the base case, pg_database now has a nailed-in-cache
      relation descriptor that is initialized using hardwired knowledge in
      relcache.c.  This means pg_database is added to the set of relations that
      need to have a Schema_pg_xxx macro maintained in pg_attribute.h.  When this
      path is taken, we'll have to do a seqscan of pg_database to find the row
      we need.
      
      In the normal case, we are able to do an indexscan to find the database's row
      by name.  This is made possible by storing a global relcache init file that
      describes only the shared catalogs and their indexes (and therefore is usable
      by all backends in any database).  A new backend loads this cache file,
      finds its database OID after an indexscan on pg_database, and then loads
      the local relcache init file for that database.
      
      This change should effectively eliminate number of databases as a factor
      in backend startup time, even with large numbers of databases.  However,
      the real reason for doing it is as a first step towards getting rid of
      the flat files altogether.  There are still several other sub-projects
      to be tackled before that can happen.
      04011cc9
    • Tom Lane's avatar
      Fix old bug in log_autovacuum_min_duration code: it was relying on being able · a1f0c9ba
      Tom Lane authored
      to access a Relation entry it had just closed.  I happened to be testing with
      CLOBBER_CACHE_ALWAYS, which made this a guaranteed core dump (at least on
      machines where sprintf %s isn't forgiving of a NULL pointer).  It's probably
      quite unlikely that it would fail in the field, but a bug is a bug.  Fix by
      moving the relation_close call down past the logging action.
      a1f0c9ba
    • Peter Eisentraut's avatar
      Split the plpython regression test into test cases arranged by topic, instead · 9d984866
      Peter Eisentraut authored
      of the previous monolithic setup-create-run sequence, that was apparently
      inherited from a previous test infrastructure, but makes working with the
      tests and adding new ones weird.
      9d984866
    • Peter Eisentraut's avatar
      Document the minimum required Python version. · ef7574eb
      Peter Eisentraut authored
      It turns out that Python 2.2 is the oldest version that PL/Python compiles
      with, apparently related to the introduction of iterators.  Might as well
      document this.
      ef7574eb
  5. 11 Aug, 2009 5 commits
  6. 10 Aug, 2009 8 commits
  7. 09 Aug, 2009 1 commit
    • Peter Eisentraut's avatar
      Ship documentation without intermediate tarballs · ed920882
      Peter Eisentraut authored
      Documentation files in HTML and man formats are now prepared for
      distribution using the distprep make target, like everything else.  They
      are placed in doc/src/sgml/html and manX and installed from there by
      make install, if present.  The business with the tarballs in the tarball
      is gone.
      ed920882
  8. 08 Aug, 2009 1 commit
  9. 07 Aug, 2009 5 commits
    • Tom Lane's avatar
      Modify parallel pg_restore to track pending and ready items by means of · f033f6d2
      Tom Lane authored
      two new lists, rather than repeatedly rescanning the main TOC list.
      This avoids a potential O(N^2) slowdown, although you'd need a *lot*
      of tables to make that really significant; and it might simplify future
      improvements in the scheduling algorithm by making the set of ready
      items more easily inspectable.  The original thought that it would
      in itself result in a more efficient job dispatch order doesn't seem
      to have been borne out in testing, but it seems worth doing anyway.
      f033f6d2
    • Alvaro Herrera's avatar
      Document that autovacuum may run ANALYZE · 05f43650
      Alvaro Herrera authored
      05f43650
    • Peter Eisentraut's avatar
      Expand test coverage support to entire tree · 7798147a
      Peter Eisentraut authored
      Test coverage support now covers the entire source tree, including
      contrib, instead of just src/backend.  In a related but independent
      development, the commands make coverage and make coverage-html can be run
      in any directory.
      
      This turned out to be much easier than feared.  Besides a few ad hoc fixes
      to pass the make target down the tree, change all affected makefiles to
      list their directories in the SUBDIRS variable, changed from variants like
      DIRS and WANTED_DIRS.  MSVC build fix was attempted as well.
      7798147a
    • Tom Lane's avatar
      Try to defend against the possibility that libpq is still in COPY_IN state · e605fbcc
      Tom Lane authored
      when we reach the post-COPY "pump it dry" error recovery code that was added
      2006-11-24.  Per a report from Neil Best, there is at least one code path
      in which this occurs, leading to an infinite loop in code that's supposed
      to be making it more robust not less so.  A reasonable response seems to be
      to call PQputCopyEnd() again, so let's try that.
      
      Back-patch to all versions that contain the cleanup loop.
      e605fbcc
    • Tom Lane's avatar
      rm_cleanup functions need to be allowed to write WAL entries. This oversight · 87740caa
      Tom Lane authored
      appears to explain the recent reports of "PANIC: cannot make new WAL entries
      during recovery".
      87740caa