1. 18 5月, 2002 3 次提交
  2. 17 5月, 2002 1 次提交
    • T
      Merge the last few variable.c configuration variables into the generic · f0811a74
      Tom Lane 提交于
      GUC support.  It's now possible to set datestyle, timezone, and
      client_encoding from postgresql.conf and per-database or per-user
      settings.  Also, implement rollback of SET commands that occur in a
      transaction that later fails.  Create a SET LOCAL var = value syntax
      that sets the variable only for the duration of the current transaction.
      All per previous discussions in pghackers.
      f0811a74
  3. 15 5月, 2002 1 次提交
  4. 14 5月, 2002 1 次提交
    • T
      Make operators have their own comments separate from those of the · f69bc37b
      Tom Lane 提交于
      underlying function; but cause psql's \do to show the underlying
      function's comment if the operator has no comment of its own, to preserve
      the useful functionality of the original behavior.  Also, implement
      COMMENT ON SCHEMA.  Patch from Rod Taylor.
      f69bc37b
  5. 11 5月, 2002 1 次提交
  6. 07 5月, 2002 1 次提交
    • T
      Accept SET SESSION AUTHORIZATION DEFAULT and RESET SESSION AUTHORIZATION · 28227889
      Tom Lane 提交于
      to reset session userid to the originally-authenticated name.  Also,
      relax SET SESSION AUTHORIZATION to allow specifying one's own username
      even if one is not superuser, so as to avoid unnecessary error messages
      when loading a pg_dump file that uses this command.  Per discussion from
      several months ago.
      28227889
  7. 30 4月, 2002 2 次提交
  8. 26 4月, 2002 1 次提交
  9. 24 4月, 2002 4 次提交
  10. 23 4月, 2002 2 次提交
  11. 22 4月, 2002 1 次提交
    • T
      Augment the date/time examples in the User's Guide to reflect the newer · c05f29e8
      Thomas G. Lockhart 提交于
       capabilities of specifying time zones as intervals per SQL9x.
      Put refentrytitle contents on the same line as the tag.
       Otherwise, leading whitespace is propagated into the product, which
       (at least) messes up the ToC layout.
      Remove (some) docinfo tags containing dates. Best to omit if the dates
       are not accurate; maybe use CVS dates instead or leave them out.
      c05f29e8
  12. 21 4月, 2002 1 次提交
    • T
      Restructure AclItem representation so that we can have more than eight · b0bcf8aa
      Tom Lane 提交于
      different privilege bits (might as well make use of the space we were
      wasting on padding).  EXECUTE and USAGE bits for procedures, languages
      now are separate privileges instead of being overlaid on SELECT.  Add
      privileges for namespaces and databases.  The GRANT and REVOKE commands
      work for these object types, but we don't actually enforce the privileges
      yet...
      b0bcf8aa
  13. 20 4月, 2002 2 次提交
    • T
      Change naming rule for ON SELECT rules of views: they're all just · 6d6ca216
      Tom Lane 提交于
      _RETURN now, since there's no need to keep 'em unique anymore.
      6d6ca216
    • T
      pg_trigger's index on tgrelid is replaced by a unique index on · 20173716
      Tom Lane 提交于
      (tgrelid, tgname).  This provides an additional check on trigger name
      uniqueness per-table (which was already enforced by the code anyway).
      With this change, RelationBuildTriggers will read the triggers in
      order by tgname, since it's scanning using this index.  Since a
      predictable trigger ordering has been requested for some time, document
      this behavior as a feature.  Also document that rules fire in name
      order, since yesterday's changes to pg_rewrite indexing cause that too.
      20173716
  14. 19 4月, 2002 1 次提交
    • T
      Rule names are now unique per-relation, rather than unique globally. · b3120804
      Tom Lane 提交于
      DROP RULE and COMMENT ON RULE syntax adds an 'ON tablename' clause,
      similar to TRIGGER syntaxes.  To allow loading of existing pg_dump
      files containing COMMENT ON RULE, the COMMENT code will still accept
      the old syntax --- but only if the target rulename is unique across
      the whole database.
      b3120804
  15. 17 4月, 2002 1 次提交
    • T
      Operators live in namespaces. CREATE/DROP/COMMENT ON OPERATOR take · 6cef5d25
      Tom Lane 提交于
      qualified operator names directly, for example CREATE OPERATOR myschema.+
      ( ... ).  To qualify an operator name in an expression you need to write
      OPERATOR(myschema.+) (thanks to Peter for suggesting an escape hatch).
      I also took advantage of having to reformat pg_operator to fix something
      that'd been bugging me for a while: mergejoinable operators should have
      explicit links to the associated cross-data-type comparison operators,
      rather than hardwiring an assumption that they are named < and >.
      6cef5d25
  16. 12 4月, 2002 2 次提交
    • B
      Add mention of function CREATE INDEX usage. · 50b5d4bf
      Bruce Momjian 提交于
      50b5d4bf
    • T
      Restructure representation of aggregate functions so that they have pg_proc · 902a6a0a
      Tom Lane 提交于
      entries, per pghackers discussion.  This fixes aggregates to live in
      namespaces, and also simplifies/speeds up lookup in parse_func.c.
      Also, add a 'proimplicit' flag to pg_proc that controls whether a type
      coercion function may be invoked implicitly, or only explicitly.  The
      current settings of these flags are more permissive than I would like,
      but we will need to debate and refine the behavior; for now, I avoided
      breaking regression tests as much as I could.
      902a6a0a
  17. 05 4月, 2002 1 次提交
  18. 04 4月, 2002 1 次提交
    • B
      Authentication improvements: · 43a3543a
      Bruce Momjian 提交于
      A new pg_hba.conf column, USER
      Allow specifiction of lists of users separated by commas
      Allow group names specified by +
      Allow include files containing lists of users specified by @
      Allow lists of databases, and database files
      Allow samegroup in database column to match group name matching dbname
      Removal of secondary password files
      Remove pg_passwd utility
      Lots of code cleanup in user.c and hba.c
      New data/global/pg_pwd format
      New data/global/pg_group file
      43a3543a
  19. 03 4月, 2002 1 次提交
  20. 01 4月, 2002 1 次提交
  21. 28 3月, 2002 1 次提交
  22. 25 3月, 2002 2 次提交
  23. 24 3月, 2002 1 次提交
  24. 23 3月, 2002 1 次提交
  25. 21 3月, 2002 1 次提交
  26. 19 3月, 2002 2 次提交
  27. 11 3月, 2002 1 次提交
  28. 10 3月, 2002 1 次提交
  29. 08 3月, 2002 1 次提交