1. 07 1月, 2007 8 次提交
    • B
      Add: · 147f2e91
      Bruce Momjian 提交于
      > 	o Consider parsing the -c string into individual queries so each
      > 	  is run in its own transaction
      >
      > 	o Consider disallowing multiple queries in PQexec() as an
      > 	  additional barrier to SQL injection attacks
      147f2e91
    • B
    • B
      Already done in 8.2: · 282f7f2e
      Bruce Momjian 提交于
      < * Allow CREATE INDEX to take an additional parameter for use with
      <   special index types
      282f7f2e
    • B
      Move INDEX inheritance out into a separate section: · bd87cd5f
      Bruce Momjian 提交于
      < * Allow inherited tables to inherit index, UNIQUE constraint, and primary
      <   key, foreign key
      < * UNIQUE INDEX on base column not honored on INSERTs/UPDATEs from
      <   inherited table:  INSERT INTO inherit_table (unique_index_col) VALUES
      <   (dup) should fail
      <
      <   The main difficulty with this item is the problem of creating an index
      <   that can span more than one table.
      <
      < * Allow SELECT ... FOR UPDATE on inherited tables
      > * Inheritance
      >
      > 	o Allow inherited tables to inherit indexes, UNIQUE constraints,
      > 	  and primary/foreign keys
      > 	o Honor UNIQUE INDEX on base column in INSERTs/UPDATEs
      > 	  on inherited table, e.g.  INSERT INTO inherit_table
      > 	  (unique_index_col) VALUES (dup) should fail
      >
      > 	  The main difficulty with this item is the problem of
      > 	  creating an index that can span multiple tables.
      >
      > 	o Allow SELECT ... FOR UPDATE on inherited tables
      >
      >
      >
      bd87cd5f
    • B
      Done: · 9cfcfd7c
      Bruce Momjian 提交于
      > * -Allow the pg_xlog directory location to be specified during initdb
      9cfcfd7c
    • B
      Allow initdb to specify the pg_xlog directory. · c3578a68
      Bruce Momjian 提交于
      Euler Taveira de Oliveira
      c3578a68
    • P
      Replace xmlroot with a properly functioning version that parses the value, · 19749fb0
      Peter Eisentraut 提交于
      sets the items, and serializes the value back (rather than adding an
      arbitrary number of XML preambles as before).
      
      The libxml memory management via palloc had to be disabled because it
      crashes when libxml tries to access memory that was helpfully freed
      earlier by PostgreSQL.  This needs further thought.
      19749fb0
    • T
      Fix filtered_base_yylex() to save and restore base_yylval and base_yylloc · 063560bb
      Tom Lane 提交于
      properly when doing a lookahead.  The lack of this was causing various
      interesting misbehaviors when one tries to use "with" as a plain identifier.
      063560bb
  2. 06 1月, 2007 15 次提交
  3. 05 1月, 2007 6 次提交
  4. 04 1月, 2007 7 次提交
    • B
    • T
      Fix erroneous implementation of -s in postmaster.c (the switch doesn't take · eeb21891
      Tom Lane 提交于
      an optarg).  Add some comments noting that code in three different files has
      to be kept in sync.  Fix erroneous description of -S switch (it sets work_mem
      not silent_mode), and do some light copy-editing elsewhere in postgres-ref.
      eeb21891
    • T
      Fix regex_fixed_prefix() to cope reasonably well with regex patterns of the · d6061d2f
      Tom Lane 提交于
      form '^(foo)$'.  Before, these could never be optimized into indexscans.
      The recent changes to make psql and pg_dump generate such patterns (for \d
      commands and -t and related switches, respectively) therefore represented
      a big performance hit for people with large pg_class catalogs, as seen in
      recent gripe from Erik Jones.  While at it, be more paranoid about
      case-sensitivity checking in multibyte encodings, and fix some other
      corner cases in which a regex might be interpreted too liberally.
      d6061d2f
    • B
      Update pow() tests to check for both errno==EDOM _and_ result==Nan, and · 9c88830e
      Bruce Momjian 提交于
      document why this happens.  Remove exp() errno check because not needed.
      9c88830e
    • T
      Fix erroneous error tests in pow/exp. · 812095d6
      Tom Lane 提交于
      812095d6
    • T
      Fix btree_gist for new larger money type. · 0d5eb8f9
      Tom Lane 提交于
      0d5eb8f9
    • T
      Clean up smgr.c/md.c APIs as per discussion a couple months ago. Instead of · ef072219
      Tom Lane 提交于
      having md.c return a success/failure boolean to smgr.c, which was just going
      to elog anyway, let md.c issue the elog messages itself.  This allows better
      error reporting, particularly in cases such as "short read" or "short write"
      which Peter was complaining of.  Also, remove the kluge of allowing mdread()
      to return zeroes from a read-beyond-EOF: this is now an error condition
      except when InRecovery or zero_damaged_pages = true.  (Hash indexes used to
      require that behavior, but no more.)  Also, enforce that mdwrite() is to be
      used for rewriting existing blocks while mdextend() is to be used for
      extending the relation EOF.  This restriction lets us get rid of the old
      ad-hoc defense against creating huge files by an accidental reference to
      a bogus block number: we'll only create new segments in mdextend() not
      mdwrite() or mdread().  (Again, when InRecovery we allow it anyway, since
      we need to allow updates of blocks that were later truncated away.)
      Also, clean up the original makeshift patch for bug #2737: move the
      responsibility for padding relation segments to full length into md.c.
      ef072219
  5. 03 1月, 2007 4 次提交