1. 03 Oct, 1998 1 commit
  2. 02 Oct, 1998 13 commits
    • Bruce Momjian's avatar
      Please apply the patch at the end. Disables use of system · e5a8da02
      Bruce Momjian authored
          columns of views at all (not only oid, cmin etc. too).
          pgsql=> select cmin from pg_rules;
          ERROR:  system column cmin not available - pg_rules is a view
          pgsql=> select * from pg_rules where pg_rules.oid = pg_class.oid;
          ERROR:  system column oid not available - pg_rules is a view
          pgsql=>
      
      Jan
      e5a8da02
    • Thomas G. Lockhart's avatar
      Obsolete information completely superceded by the sgml sources. · 2da5e598
      Thomas G. Lockhart authored
      These weren't really "man page"-ish anyway, and I've verified that
       all information in them has moved to the newer sources.
      2da5e598
    • Thomas G. Lockhart's avatar
      Surround all identifiers with double quotes. · 96019647
      Thomas G. Lockhart authored
       Formerly did so only for those which clearly required it, but that
       would still miss things like reserved key words which also require it.
      Implement the "-n" switch to revert the double quote behavior
       to put DQs only where there is more than lower-case, digits,
       and underscores.
      96019647
    • Bruce Momjian's avatar
      Here's a combination of all the patches I'm currently waiting · f93b6974
      Bruce Momjian authored
          for against a just updated CVS tree. It contains
      
              Partial new rewrite system that handles subselects,  view
              aggregate  columns, insert into select from view, updates
              with set col = view-value and select rules restriction to
              view definition.
      
              Updates  for  rule/view  backparsing utility functions to
              handle subselects correct.
      
      
              New system views pg_tables and pg_indexes (where you  can
              see the complete index definition in the latter one).
      
              Enabling array references on query parameters.
      
              Bugfix for functional index.
      
              Little changes to system views pg_rules and pg_views.
      
      
          The rule system isn't a release-stopper any longer.
      
          But  another  stopper  is  that  I  don't  know if the latest
          changes to PL/pgSQL (not already in CVS) made it  compile  on
          AIX. Still wait for some response from Dave.
      
      Jan
      f93b6974
    • Bruce Momjian's avatar
      the following little patch adds array references to query · 9b21a18c
      Bruce Momjian authored
          parameters. With it applied a function like
      
          CREATE FUNCTION getname(oid8, int4) RETURNS name AS
              'SELECT typname FROM pg_type WHERE oid = $1[$2]'
              LANGUAGE 'sql';
      
          is possible. Mainly I need this to enable array references in
          expressions for PL/pgSQL. Complete regression test ran O.K.
      
      Jan
      9b21a18c
    • Bruce Momjian's avatar
      Summary · 772a596e
      Bruce Momjian authored
      The ident() function in src/backend/libpq/hba.c doesn't cope when
      postmaster is contacted on an IP alias. This patch fixes it.
      
       Malcolm Beattie
      772a596e
    • Bruce Momjian's avatar
      Fixes for Irix from Robert Bruccoleri · 9b7c6ee0
      Bruce Momjian authored
      9b7c6ee0
    • Bruce Momjian's avatar
      · 731ea807
      Bruce Momjian authored
      Here's the new diff for getting the NS32K assembly code into the
      spin-locks.  Notice that it's now inline assembler in s_lock.h,
      rather than seperate code in s_lock.c.  It also shrank a little
      bit...  Just rip out the S_LOCK() define and insert the tas() inline
      function.  Please let me know if there are any problems with it.
      
      Jon Buller
      731ea807
    • Bruce Momjian's avatar
      regproc cleanups · 744c3cd2
      Bruce Momjian authored
      744c3cd2
    • Bruce Momjian's avatar
    • Tom Lane's avatar
      Fix potential coredump in pg_conndefaults (assigning constant string · 820f9f8b
      Tom Lane authored
      to a field that will get free'd).  Also make it robust in cases where
      values contain Tcl special characters.
      820f9f8b
    • Bruce Momjian's avatar
      Search contrib/tcl for tcl startup. · 3f2fff5c
      Bruce Momjian authored
      3f2fff5c
    • Tom Lane's avatar
      Clean up some minor bugs concerning what was inside the main loop · e12f4162
      Tom Lane authored
      and what wasn't.  Also try to improve the comments so that doesn't happen
      again.  Changed SIGPIPE handling to SIG_IGN so that if frontend quits,
      we will finish out the current command and return to main loop before
      quitting.  This seems much safer than a forced abort mid-command.
      e12f4162
  3. 01 Oct, 1998 9 commits
  4. 30 Sep, 1998 5 commits
  5. 29 Sep, 1998 1 commit
    • Marc G. Fournier's avatar
      · 44e01bf9
      Marc G. Fournier authored
      From: Jan Wieck <jwieck@debis.com>
      
          here  is  the  patch  that  includes  PL/pgSQL into the build
          (currently with make errors ignored) and  adds  a  regression
          test for it. A clean build and regression ran fine here.
      
          Can you please apply it?
      
          The  tar  should  be  extracted  in  /usr/local/src/pgsql and
          creates the following files:
      
          src/pl/Makefile
                  called by toplevel GNUmakefile and for now only calls
                  src/pl/plpgsql/Makefile
      
          src/pl/plpgsql/Makefile
                  calls  src/pl/plpgsql/src/Makefile  (here the call to
                  make ignores build errors  -  this  must  be  changed
                  later for the final release).
      
          src/test/regress/input/install_plpgsql.source
                  SQL script installing PL/pgSQL language in regression
                  database. Will be modified by  .../input/Makefile  to
                  point  to  correct  PGLIB  directory where plpgsql.so
                  gets installed.
      
          src/test/regress/output/install_plpgsql.source
                  expected output for installation script.
      
          src/test/regress/sql/plpgsql.sql
                  the main regression  test.  It  tests  functions  and
                  triggers written in PL/pgSQL including views that use
                  supportfunctions in this language.
      
          src/test/regress/expected/plpgsql.out
                  the expected output for the above regression test.
      
          make_plpgsql.diff
                  patch that adds some lines to
      
                  src/GNUmakefile.in
                  src/test/regress/expected/Makefile
                  src/test/regress/input/Makefile
                  src/test/regress/output/Makefile
                  src/test/regress/sql/Makefile
                  src/test/regress/sql/tests
      44e01bf9
  6. 27 Sep, 1998 1 commit
  7. 25 Sep, 1998 10 commits