1. 24 Sep, 1999 1 commit
    • Tom Lane's avatar
      Several changes here, not very related but touching some of the same files. · e812458b
      Tom Lane authored
      * Buffer refcount cleanup (per my "progress report" to pghackers, 9/22).
      * Add links to backend PROC structs to sinval's array of per-backend info,
      and use these links for routines that need to check the state of all
      backends (rather than the slow, complicated search of the ShmemIndex
      hashtable that was used before).  Add databaseOID to PROC structs.
      * Use this to implement an interlock that prevents DESTROY DATABASE of
      a database containing running backends.  (It's a little tricky to prevent
      a concurrently-starting backend from getting in there, since the new
      backend is not able to lock anything at the time it tries to look up
      its database in pg_database.  My solution is to recheck that the DB is
      OK at the end of InitPostgres.  It may not be a 100% solution, but it's
      a lot better than no interlock at all...)
      * In ALTER TABLE RENAME, flush buffers for the relation before doing the
      rename of the physical files, to ensure we don't get failures later from
      mdblindwrt().
      * Update TRUNCATE patch so that it actually compiles against current
      sources :-(.
      You should do "make clean all" after pulling these changes.
      e812458b
  2. 18 Sep, 1999 1 commit
    • Tom Lane's avatar
      Mega-commit to make heap_open/heap_openr/heap_close take an · bd272cac
      Tom Lane authored
      additional argument specifying the kind of lock to acquire/release (or
      'NoLock' to do no lock processing).  Ensure that all relations are locked
      with some appropriate lock level before being examined --- this ensures
      that relevant shared-inval messages have been processed and should prevent
      problems caused by concurrent VACUUM.  Fix several bugs having to do with
      mismatched increment/decrement of relation ref count and mismatched
      heap_open/close (which amounts to the same thing).  A bogus ref count on
      a relation doesn't matter much *unless* a SI Inval message happens to
      arrive at the wrong time, which is probably why we got away with this
      sloppiness for so long.  Repair missing grab of AccessExclusiveLock in
      DROP TABLE, ALTER/RENAME TABLE, etc, as noted by Hiroshi.
      Recommend 'make clean all' after pulling this update; I modified the
      Relation struct layout slightly.
      Will post further discussion to pghackers list shortly.
      bd272cac
  3. 19 Jul, 1999 1 commit
  4. 17 Jul, 1999 1 commit
  5. 16 Jul, 1999 1 commit
  6. 15 Jul, 1999 3 commits
  7. 25 May, 1999 1 commit
  8. 10 May, 1999 1 commit
  9. 13 Feb, 1999 1 commit
  10. 15 Dec, 1998 1 commit
  11. 14 Dec, 1998 1 commit
    • Marc G. Fournier's avatar
      · 7c3b7d27
      Marc G. Fournier authored
      Initial attempt to clean up the code...
      
      Switch sprintf() to snprintf()
      Remove any/all #if 0 -or- #ifdef NOT_USED -or- #ifdef FALSE sections of
      	code
      7c3b7d27
  12. 27 Nov, 1998 1 commit
  13. 01 Sep, 1998 2 commits
  14. 19 Aug, 1998 1 commit
    • Bruce Momjian's avatar
      heap_fetch requires buffer pointer, must be released; heap_getnext · 79715390
      Bruce Momjian authored
      no longer returns buffer pointer, can be gotten from scan;
      	descriptor; bootstrap can create multi-key indexes;
      pg_procname index now is multi-key index; oidint2, oidint4, oidname
      are gone (must be removed from regression tests); use System Cache
      rather than sequential scan in many places; heap_modifytuple no
      longer takes buffer parameter; remove unused buffer parameter in
      a few other functions; oid8 is not index-able; remove some use of
      single-character variable names; cleanup Buffer variables usage
      and scan descriptor looping; cleaned up allocation and freeing of
      tuples; 18k lines of diff;
      79715390
  15. 27 Jul, 1998 1 commit
  16. 20 Jul, 1998 2 commits
  17. 15 Jun, 1998 1 commit
  18. 15 Jan, 1998 1 commit
    • PostgreSQL Daemon's avatar
      Thank god for searchable mail archives. · baef78d9
      PostgreSQL Daemon authored
      Patch by: wieck@sapserv.debis.de (Jan Wieck)
      
         One  of  the design rules of PostgreSQL is extensibility. And
         to follow this rule means (at least for me) that there should
         not  only  be a builtin PL.  Instead I would prefer a defined
         interface for PL implemetations.
      baef78d9
  19. 07 Jan, 1998 1 commit
  20. 05 Jan, 1998 1 commit
  21. 24 Nov, 1997 1 commit
  22. 20 Nov, 1997 1 commit
  23. 18 Sep, 1997 1 commit
  24. 08 Sep, 1997 3 commits
  25. 07 Sep, 1997 1 commit
  26. 19 Aug, 1997 1 commit
  27. 12 Aug, 1997 1 commit
  28. 22 May, 1997 1 commit
  29. 10 Jan, 1997 1 commit
  30. 13 Nov, 1996 1 commit
    • Marc G. Fournier's avatar
      Commit of a *MAJOR* patch from Dan McGuirk <djm@indirect.com> · 07a65b22
      Marc G. Fournier authored
      Changes:
      
              * Unique index capability works using the syntax 'create unique
                index'.
      
              * Duplicate OID's in the system tables are removed.  I put
                little scripts called 'duplicate_oids' and 'find_oid' in
                include/catalog that help to find and remove duplicate OID's.
                I also moved 'unused_oids' from backend/catalog to
                include/catalog, since it has to be in the same directory
                as the include files in order to work.
      
              * The backend tries converting the name of a function or aggregate
                to all lowercase if the original name given doesn't work (mostly
                for compatibility with ODBC).
      
              * You can 'SELECT NULL' to your heart's content.
      
              * I put my _bt_updateitem fix in instead, which uses
                _bt_insertonpg so that even if the new key is so big that
                the page has to be split, everything still works.
      
              * All literal references to system catalog OID's have been
                replaced with references to define'd constants from the catalog
                header files.
      
              * I added a couple of node copy functions.  I think this was a
                preliminary attempt to get rules to work.
      07a65b22
  31. 10 Nov, 1996 1 commit
  32. 05 Nov, 1996 1 commit
  33. 03 Nov, 1996 1 commit
  34. 31 Oct, 1996 1 commit