1. 05 Mar, 2002 1 commit
  2. 12 Nov, 2001 1 commit
  3. 25 Oct, 2001 1 commit
  4. 06 Oct, 2001 1 commit
  5. 21 Aug, 2001 1 commit
    • Tom Lane's avatar
      Restructure pg_opclass, pg_amop, and pg_amproc per previous discussions in · f933766b
      Tom Lane authored
      pgsql-hackers.  pg_opclass now has a row for each opclass supported by each
      index AM, not a row for each opclass name.  This allows pg_opclass to show
      directly whether an AM supports an opclass, and furthermore makes it possible
      to store additional information about an opclass that might be AM-dependent.
      pg_opclass and pg_amop now store "lossy" and "haskeytype" information that we
      previously expected the user to remember to provide in CREATE INDEX commands.
      Lossiness is no longer an index-level property, but is associated with the
      use of a particular operator in a particular index opclass.
      
      Along the way, IndexSupportInitialize now uses the syscaches to retrieve
      pg_amop and pg_amproc entries.  I find this reduces backend launch time by
      about ten percent, at the cost of a couple more special cases in catcache.c's
      IndexScanOK.
      
      Initial work by Oleg Bartunov and Teodor Sigaev, further hacking by Tom Lane.
      
      initdb forced.
      f933766b
  6. 10 Aug, 2001 1 commit
    • Tom Lane's avatar
      Make OIDs optional, per discussions in pghackers. WITH OIDS is still the · bf56f075
      Tom Lane authored
      default, but OIDS are removed from many system catalogs that don't need them.
      Some interesting side effects: TOAST pointers are 20 bytes not 32 now;
      pg_description has a three-column key instead of one.
      
      Bugs fixed in passing: BINARY cursors work again; pg_class.relhaspkey
      has some usefulness; pg_dump dumps comments on indexes, rules, and
      triggers in a valid order.
      
      initdb forced.
      bf56f075
  7. 09 Aug, 2001 1 commit
  8. 05 Aug, 2001 1 commit
  9. 08 Jul, 2001 1 commit
  10. 30 Jun, 2001 1 commit
  11. 28 May, 2001 1 commit
    • Bruce Momjian's avatar
      This just breaks down the indices in to three groups: · d66a4049
      Bruce Momjian authored
      non-unique: stay as they were
      unique and primary: become listed as primary keys
      unique and non-primary: become listed as unique keys
      
      I also made it so that it shows the names of check constraints ie:
      
      Check: "$1" (a > 5)
      
      Christopher Kings
      d66a4049
  12. 27 May, 2001 1 commit
  13. 09 May, 2001 3 commits
    • Bruce Momjian's avatar
      Right-align \du user-id. · d8eade37
      Bruce Momjian authored
      d8eade37
    • Bruce Momjian's avatar
      Fix memory leak in new psql \du code. · 68319f91
      Bruce Momjian authored
      68319f91
    • Bruce Momjian's avatar
      · a79b698a
      Bruce Momjian authored
      Here's a version of my suggested diffs transplanted to 7.1 beta 5.  I'm
      still looking at the best way to integrate Tom Vijlbrief's fixes
      (insofar as they're still needed); would 7.2 be a suitable time for
      incompatible API changes?
      
      
      Jeroen
      
      
      Changes:
      
      (*) Introduced bool, true, false (replacing some int, 1, 0)
      (*) Made some member functions const
      (*) Documented GetIsNull()
      (*) Marked DisplayTuples() and PrintTuples() as obsolescent; fixed possible
          portability problem (assumed that NULL pointer equals all-zero bit pattern)
      (*) PrintTuples(): renamed width parameter to fillAlign to conform with other
          usage; fixed memory leak and compile issue w.r.t. field separator (should
          also slightly improve performance)
      (*) Fixed some minor compilation issues
      (*) Moved "using namespace std;" out of headers, where they didn't belong; used
          new (temporary) preprocessor macro PGSTD to do this
      (*) Made ToString() static, removed unneeded memset(), made buffer size adapt
          to sizeof(int)
      (*) Made some constructors explicit
      (*) Changed some const std::string & parameters to plain std::string
      (*) Marked PgCursor::Cursor(std::string) as obsolescent (setter with same name
          as getter--bad style)
      (*) Renamed some paramaters previously named "string"
      (*) Introduced size_type typedef for number of tuples in result set
      (*) PgTransaction now supports re-opening after closing, and aborts if not
          explicitly committed prior to destruction
      
      J. T. Vermeulen
      a79b698a
  14. 22 Mar, 2001 1 commit
  15. 10 Feb, 2001 1 commit
    • Tom Lane's avatar
      Restructure the key include files per recent pghackers discussion: there · d08741ea
      Tom Lane authored
      are now separate files "postgres.h" and "postgres_fe.h", which are meant
      to be the primary include files for backend .c files and frontend .c files
      respectively.  By default, only include files meant for frontend use are
      installed into the installation include directory.  There is a new make
      target 'make install-all-headers' that adds the whole content of the
      src/include tree to the installed fileset, for use by people who want to
      develop server-side code without keeping the complete source tree on hand.
      Cleaned up a whole lot of crufty and inconsistent header inclusions.
      d08741ea
  16. 25 Oct, 2000 1 commit
  17. 24 Oct, 2000 1 commit
    • Tom Lane's avatar
      Major overhaul of large-object implementation, by Denis Perchine with · 4f44aa04
      Tom Lane authored
      kibitzing from Tom Lane.  Large objects are now all stored in a single
      system relation "pg_largeobject" --- no more xinv or xinx files, no more
      relkind 'l'.  This should offer substantial performance improvement for
      large numbers of LOs, since there won't be directory bloat anymore.
      It'll also fix problems like running out of locktable space when you
      access thousands of LOs in one transaction.
      Also clean up cruft in read/write routines.  LOs with "holes" in them
      (never-written byte ranges) now work just like Unix files with holes do:
      a hole reads as zeroes but doesn't occupy storage space.
      INITDB forced!
      4f44aa04
  18. 07 Sep, 2000 1 commit
  19. 09 Jul, 2000 1 commit
  20. 07 Jul, 2000 1 commit
  21. 16 Apr, 2000 2 commits
  22. 12 Apr, 2000 1 commit
  23. 26 Feb, 2000 1 commit
  24. 16 Feb, 2000 1 commit
  25. 07 Feb, 2000 1 commit
  26. 29 Jan, 2000 1 commit
    • Peter Eisentraut's avatar
      A few minor psql enhancements · 2b84cbb6
      Peter Eisentraut authored
      Initdb help correction
      Changed end/abort to commit/rollback and changed related notices
      Commented out way old printing functions in libpq
      Fixed a typo in alter table / alter column
      2b84cbb6
  27. 20 Jan, 2000 1 commit
  28. 18 Jan, 2000 2 commits
  29. 14 Jan, 2000 1 commit
  30. 12 Jan, 2000 1 commit
  31. 10 Jan, 2000 2 commits
  32. 31 Dec, 1999 1 commit
  33. 17 Dec, 1999 1 commit
  34. 26 Nov, 1999 1 commit
    • Bruce Momjian's avatar
      * Includes tab completion. It's not magic, but it's very cool. At any · 78bc83fe
      Bruce Momjian authored
      rate
        it's better than what used to be there.
      
      * Does proper SQL "host variable" substitution as pointed out by Andreas
        Zeugwetter (thanks): select * from :foo; Also some changes in how ':'
        and ';' are treated (escape with \ to send to backend). This does
      _not_
        affect the '::' cast operator, but perhaps others that contain : or ;
        (but there are none right now).
      
      * To show description with a <something> listing, append '?' to command
        name, e.g., \df?. This seemed to be the convenient and logical
      solution.
        Or append a '+' to see more useless information, e.g., \df+.
      
      * Fixed fflush()'ing bug pointed out by Jan during the regression test
        discussion.
      
      * Added LastOid variable. This ought to take care of TODO item "Add a
        function to return the last inserted oid, for use in psql scripts"
        (under CLIENTS)
        E.g.,
      insert into foo values(...);
      insert into bar values(..., :LastOid);
      \echo $LastOid
      
      * \d command shows constraints, rules, and triggers defined on the table
        (in addition to indices)
      
      * Various fixes, optimizations, corrections
      
      * Documentation update as well
      
      
      Note: This now requires snprintf(), which, if necessary, is taken from
      src/backend/port. This is certainly a little weird, but it should
      suffice
      until a source tree cleanup is done.
      
      Enjoy.
      
      --
      Peter Eisentraut                  Sernanders väg 10:115
      78bc83fe
  35. 13 Nov, 1999 1 commit