1. 25 Jul, 2007 1 commit
    • Tom Lane's avatar
      Arrange to put TOAST tables belonging to temporary tables into special schemas · 82eed4db
      Tom Lane authored
      named pg_toast_temp_nnn, alongside the pg_temp_nnn schemas used for the temp
      tables themselves.  This allows low-level code such as the relcache to
      recognize that these tables are indeed temporary, which enables various
      optimizations such as not WAL-logging changes and using local rather than
      shared buffers for access.  Aside from obvious performance benefits, this
      provides a solution to bug #3483, in which other backends unexpectedly held
      open file references to temporary tables.  The scheme preserves the property
      that TOAST tables are not in any schema that's normally in the search path,
      so they don't conflict with user table names.
      
      initdb forced because of changes in system view definitions.
      82eed4db
  2. 15 Jul, 2007 1 commit
  3. 19 Oct, 2006 1 commit
  4. 11 Mar, 2006 1 commit
  5. 15 Oct, 2005 1 commit
  6. 21 Jun, 2005 1 commit
    • Tom Lane's avatar
      Cause initdb to create a third standard database "postgres", which · 6f7fc0ba
      Tom Lane authored
      unlike template0 and template1 does not have any special status in
      terms of backend functionality.  However, all external utilities such
      as createuser and createdb now connect to "postgres" instead of
      template1, and the documentation is changed to encourage people to use
      "postgres" instead of template1 as a play area.  This should fix some
      longstanding gotchas involving unexpected propagation of database
      objects by createdb (when you used template1 without understanding
      the implications), as well as ameliorating the problem that CREATE
      DATABASE is unhappy if anyone else is connected to template1.
      Patch by Dave Page, minor editing by Tom Lane.  All per recent
      pghackers discussions.
      6f7fc0ba
  7. 02 Dec, 2004 1 commit
  8. 05 Nov, 2004 1 commit
    • Tom Lane's avatar
      Create 'default_tablespace' GUC variable that supplies a TABLESPACE · 98e8b480
      Tom Lane authored
      clause implicitly whenever one is not given explicitly.  Remove concept
      of a schema having an associated tablespace, and simplify the rules for
      selecting a default tablespace for a table or index.  It's now just
      (a) explicit TABLESPACE clause; (b) default_tablespace if that's not an
      empty string; (c) database's default.  This will allow pg_dump to use
      SET commands instead of tablespace clauses to determine object locations
      (but I didn't actually make it do so).  All per recent discussions.
      98e8b480
  9. 17 Sep, 2004 1 commit
  10. 03 Mar, 2004 1 commit
  11. 04 Aug, 2003 1 commit
  12. 27 Jul, 2003 3 commits
    • Bruce Momjian's avatar
      Updatge to skip composite types. · 606debf2
      Bruce Momjian authored
      606debf2
    • Bruce Momjian's avatar
      51e46d14
    • Bruce Momjian's avatar
      Here is 4 file in tgz: · 524cfad2
      Bruce Momjian authored
      the new timetravel.c,
      new timetravel.README (cut from spi/README and modified),
      modified timetravel.sql.in
      and modified timetravel.example.
      
      Features:
      - optionally 3 parameter for insert/update/delete user name
      
      - work with CREATE UNIQUE INDEX ixxx on table xxx
      (unique_field,time_off);
          (the  original version was work with unique index on 6.5.0-6.5.3,
      and not work on 7.3.2,7.3.3)
           (before 6.5.0 and between 6.5.3 and 7.3.2 I dont know)
      
      - get_timetravel(tablename) function for check timetravel-status.
      
      - timetravel trigger not change  oid of the active record. (it is not a
      good feature, because the  old version is automatice prevent the paralel
      update with "where oid=nnn")
      
      B?jthe Zolt?n
      524cfad2
  13. 14 May, 2003 1 commit
  14. 10 Mar, 2003 1 commit
  15. 18 Oct, 2002 1 commit
  16. 15 Aug, 2002 1 commit
    • Bruce Momjian's avatar
      The attached patch changes most of the usages of sprintf() to · 66eb8df6
      Bruce Momjian authored
      snprintf() in contrib/. I didn't touch the places where pointer
      arithmatic was being used, or other areas where the fix wasn't
      trivial. I would think that few, if any, of the usages of sprintf()
      were actually exploitable, but it's probably better to be paranoid...
      
      Neil Conway
      66eb8df6
  17. 12 Jun, 2002 1 commit
  18. 05 Mar, 2002 1 commit
    • Bruce Momjian's avatar
      Currently, contrib/oid2name doesn't bother to free() the memory that it · 66cd6a0f
      Bruce Momjian authored
      malloc()'s. This isn't too serious (because oid2name is a short-lived
      utility, so the memory will soon be returned to the OS on process
      termination), but I still think it's poor style.
      
      This patch changes oid2name so that it allocates memory on the stack
      where possible and free()s the remaining heap-allocated memory. The
      patch also fixes a typo a comment and adds 'const' qualifiers to a few
      'char *' function parameters.
      
      Neil Conway
      66cd6a0f
  19. 25 Jan, 2002 1 commit
  20. 10 Jan, 2002 1 commit
  21. 15 Nov, 2001 1 commit
  22. 02 Oct, 2001 1 commit
  23. 18 Jun, 2001 1 commit
    • Bruce Momjian's avatar
      The attached patch enables the contrib subtree to build cleanly under · 558fae16
      Bruce Momjian authored
      Cygwin with the possible exception of mSQL-interface.  Since I don't
      have mSQL installed, I skipped this tool.
      
      Except for dealing with a missing getopt.h (oid2name) and HUGE (seg),
      the bulk of the patch uses the standard PostgreSQL approach to deal with
      Windows DLL issues.
      
      I tested the build aspect of this patch under Cygwin and Linux without
      any ill affects.  Note that I did not actually attempt to test the code
      for functionality.
      
      The procedure to apply the patch is as follows:
      
          $ # save the attachment as /tmp/contrib.patch
          $ # change directory to the top of the PostgreSQL source tree
          $ patch -p0 </tmp/contrib.patch
      
      Jason
      558fae16
  24. 22 Mar, 2001 1 commit
  25. 12 Feb, 2001 3 commits
  26. 24 Jan, 2001 3 commits