1. 20 Aug, 1997 1 commit
  2. 19 Aug, 1997 1 commit
  3. 22 May, 1997 1 commit
  4. 29 Apr, 1997 1 commit
  5. 23 Apr, 1997 1 commit
  6. 05 Apr, 1997 1 commit
  7. 02 Apr, 1997 2 commits
  8. 16 Jan, 1997 1 commit
  9. 13 Jan, 1997 1 commit
  10. 17 Dec, 1996 1 commit
  11. 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
  12. 04 Nov, 1996 1 commit
  13. 03 Nov, 1996 1 commit
  14. 30 Oct, 1996 1 commit
  15. 19 Oct, 1996 2 commits
  16. 28 Aug, 1996 1 commit
  17. 26 Aug, 1996 1 commit
  18. 24 Aug, 1996 1 commit
    • Marc G. Fournier's avatar
      The patch does several things: · 208a30f2
      Marc G. Fournier authored
              It adds a WITH OIDS option to the copy command, which allows
      dumping and loading of oids.
      
              If a copy command tried to load in an oid that is greater than
      its current system max oid, the system max oid is incremented.  No
      checking is done to see if other backends are running and have cached
      oids.
      
              pg_dump as its first step when using the -o (oid) option, will
      copy in a dummy row to set the system max oid value so as rows are
      loaded in, they are certain to be lower than the system oid.
      
              pg_dump now creates indexes at the end to speed loading
      
      
      Submitted by:  Bruce Momjian <maillist@candle.pha.pa.us>
      208a30f2
  19. 06 Aug, 1996 2 commits
    • Marc G. Fournier's avatar
      Fixes: · 6c684b18
      Marc G. Fournier authored
      Previously Postgres95 wouldn't accept 'order by' clauses with fields
      referred to as '<table>.<field>', e.g.:
      
              select t1.field1, t2.field2 from table1 t1, table2 t2
                      order by t2.field2;
      
      This syntax is required by the ODBC SQL spec.
      
      Submitted by: Dan McGuirk <mcguirk@indirect.com>
      6c684b18
    • Marc G. Fournier's avatar
      Fixes: · ab22b348
      Marc G. Fournier authored
      While a normal SELECT statement can contain a GROUP BY clause, a cursor
      declaration cannot. This was not the case in PG-1.0. Was there a good
      reason why this was changed? Are cursors being phased out? Is there any way
      to get data with just a SELECT (and without a DECLARE CURSOR ...)?
      
      The patch below seems to fix things. If anyone can see a problem with it,
      please let me know. Thanks.
      
      Submitted by:  David Smith <dasmith@perseus.tufts.edu>
      ab22b348
  20. 09 Jul, 1996 1 commit