1. 03 10月, 1998 6 次提交
    • B
      · e5a8da02
      Bruce Momjian 提交于
          Please apply the patch at the end. Disables use of system
          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
    • T
      Obsolete information completely superceded by the sgml sources. · 2da5e598
      Thomas G. Lockhart 提交于
      These weren't really "man page"-ish anyway, and I've verified that
       all information in them has moved to the newer sources.
      2da5e598
    • T
      Surround all identifiers with double quotes. · 96019647
      Thomas G. Lockhart 提交于
       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
    • B
      Here's a combination of all the patches I'm currently waiting · f93b6974
      Bruce Momjian 提交于
          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
    • B
      the following little patch adds array references to query · 9b21a18c
      Bruce Momjian 提交于
          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
    • B
      Summary · 772a596e
      Bruce Momjian 提交于
      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
  2. 02 10月, 1998 9 次提交
  3. 01 10月, 1998 7 次提交
  4. 30 9月, 1998 5 次提交
  5. 29 9月, 1998 1 次提交
    • M
      · 44e01bf9
      Marc G. Fournier 提交于
      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. 28 9月, 1998 1 次提交
  7. 25 9月, 1998 10 次提交
  8. 24 9月, 1998 1 次提交