1. 09 8月, 2005 9 次提交
  2. 08 8月, 2005 4 次提交
  3. 07 8月, 2005 1 次提交
    • T
      COPY performance improvements. Avoid calling CopyGetData for each input · 9b29f9f3
      Tom Lane 提交于
      character, tighten the inner loops of CopyReadLine and CopyReadAttribute,
      arrange to parse out all the attributes of a line in just one call instead
      of one CopyReadAttribute call per attribute, be smarter about which client
      encodings require slow pg_encoding_mblen() loops.  Also, clean up the
      mishmash of static variables and overly-long parameter lists in favor of
      passing around a single CopyState struct containing all the state data.
      Original patch by Alon Goldshuv, reworked by Tom Lane.
      9b29f9f3
  4. 05 8月, 2005 2 次提交
  5. 04 8月, 2005 1 次提交
    • T
      ALTER TABLE OWNER must change the ownership of the table's rowtype too. · 33f5bf97
      Tom Lane 提交于
      This was not especially critical before, but it is now that we track
      ownership dependencies --- the dependency for the rowtype *must* shift
      to the new owner.  Spotted by Bernd Helmle.
      Also fix a problem introduced by recent change to allow non-superusers
      to do ALTER OWNER in some cases: if the table had a toast table, ALTER
      OWNER failed *even for superusers*, because the test being applied would
      conclude that the new would-be owner had no create rights on pg_toast.
      A side-effect of the fix is to disallow changing the ownership of indexes
      or toast tables separately from their parent table, which seems a good
      idea on the whole.
      33f5bf97
  6. 03 8月, 2005 5 次提交
    • B
      · e48b28b6
      Bruce Momjian 提交于
      Done:
      
      < * Prevent inherited tables from expanding temporary subtables of other
      > * -Prevent inherited tables from expanding temporary subtables of other
      e48b28b6
    • T
      Tweak BgBufferSync() so that a persistent write error on a dirty buffer · 6eac4e69
      Tom Lane 提交于
      doesn't block the bgwriter from making progress writing out other buffers.
      This was a hard problem in the context of the ARC/2Q design, but it's
      trivial in the context of clock sweep ... just advance the sweep counter
      before we try to write not after.
      6eac4e69
    • T
      Prevent planner from including temp tables of other backends when expanding · 688784f6
      Tom Lane 提交于
      an inheritance tree.  Per recent discussions.
      688784f6
    • T
      Clean up CREATE DATABASE processing to make it more robust and get rid · 558730ac
      Tom Lane 提交于
      of special case for Windows port.  Put a PG_TRY around most of createdb()
      to ensure that we remove copied subdirectories on failure, even if the
      failure happens while creating the pg_database row.  (I think this explains
      Oliver Siegmar's recent report.)  Having done that, there's no need for
      the fragile assumption that copydir() mustn't ereport(ERROR), so simplify
      its API.  Eliminate the old code that used system("cp ...") to copy
      subdirectories, in favor of using copydir() on all platforms.  This not
      only should allow much better error reporting, but allows us to fsync
      the created files before trusting that the copy has succeeded.
      558730ac
    • T
      Code and docs review for pg_column_size() patch. · 0001e98d
      Tom Lane 提交于
      0001e98d
  7. 02 8月, 2005 7 次提交
  8. 01 8月, 2005 5 次提交
    • B
      Done: · 614b6e25
      Bruce Momjian 提交于
      > * -Allow limits on per-db/role connections
      614b6e25
    • B
      Done: · 523997da
      Bruce Momjian 提交于
      < 	o Allow objects to be moved to different schemas
      > 	o -Allow objects to be moved to different schemas
      
      Fix word wrap:
      
      < 	* Allow GRANT/REVOKE permissions to be applied to all schema objects with one
      < 	  command
      > 	o Allow GRANT/REVOKE permissions to be applied to all schema objects
      > 	  with one command
      523997da
    • T
      Add ALTER object SET SCHEMA capability for a limited but useful set of · 35508d1c
      Tom Lane 提交于
      object kinds (tables, functions, types).  Documentation is not here yet.
      Original code by Bernd Helmle, extensive rework by Bruce Momjian and
      Tom Lane.
      35508d1c
    • B
      Add description: · a85e5d1b
      Bruce Momjian 提交于
      < 	  This would require a new global table that is dumped to flat file for
      < 	  use by the postmaster.  We do a similar thing for pg_shadow currently.
      > 	  This would add a function to load the SQL table from
      >           pg_hba.conf, and one to writes its contents to the flat file.
      > 	  The table should have a line number that is a float so rows
      > 	  can be inserted between existing rows, e.g. row 2.5 goes
      > 	  between row 2 and row 3.
      a85e5d1b
    • T
      Add per-user and per-database connection limit options. · d42cf5a4
      Tom Lane 提交于
      This patch also includes preliminary update of pg_dumpall for roles.
      Petr Jelinek, with review by Bruce Momjian and Tom Lane.
      d42cf5a4
  9. 31 7月, 2005 6 次提交