1. 29 Oct, 2003 1 commit
  2. 25 Sep, 2003 1 commit
  3. 15 Sep, 2003 1 commit
  4. 09 Sep, 2003 1 commit
  5. 17 Aug, 2003 1 commit
    • Tom Lane's avatar
      Create a 'type cache' that keeps track of the data needed for any particular · ec646dbc
      Tom Lane authored
      datatype by array_eq and array_cmp; use this to solve problems with memory
      leaks in array indexing support.  The parser's equality_oper and ordering_oper
      routines also use the cache.  Change the operator search algorithms to look
      for appropriate btree or hash index opclasses, instead of assuming operators
      named '<' or '=' have the right semantics.  (ORDER BY ASC/DESC now also look
      at opclasses, instead of assuming '<' and '>' are the right things.)  Add
      several more index opclasses so that there is no regression in functionality
      for base datatypes.  initdb forced due to catalog additions.
      ec646dbc
  6. 14 Aug, 2003 1 commit
  7. 04 Aug, 2003 2 commits
  8. 27 Jul, 2003 1 commit
  9. 27 Jun, 2003 1 commit
    • Tom Lane's avatar
      Create real array comparison functions (that use the element datatype's · b3c0551e
      Tom Lane authored
      comparison functions), replacing the highly bogus bitwise array_eq.  Create
      a btree index opclass for ANYARRAY --- it is now possible to create indexes
      on array columns.
      Arrange to cache the results of catalog lookups across multiple array
      operations, instead of repeating the lookups on every call.
      Add string_to_array and array_to_string functions.
      Remove singleton_array, array_accum, array_assign, and array_subscript
      functions, since these were for proof-of-concept and not intended to become
      supported functions.
      Minor adjustments to behavior in some corner cases with empty or
      zero-dimensional arrays.
      
      Joe Conway (with some editorializing by Tom Lane).
      b3c0551e
  10. 25 Jun, 2003 1 commit
  11. 24 Jun, 2003 1 commit
  12. 11 Jun, 2003 1 commit
  13. 02 Jun, 2003 1 commit
  14. 24 Jan, 2003 1 commit
  15. 23 Jan, 2003 1 commit
  16. 05 Dec, 2002 1 commit
  17. 13 Nov, 2002 1 commit
  18. 11 Nov, 2002 1 commit
  19. 10 Nov, 2002 1 commit
  20. 24 Sep, 2002 1 commit
  21. 04 Sep, 2002 1 commit
  22. 03 Sep, 2002 1 commit
    • Tom Lane's avatar
      Arrange for the default permissions on a database to allow temp table · d61de589
      Tom Lane authored
      creation to world, but disallow temp table creation in template1.  Per
      latest round of pghackers discussion.
      I did not force initdb, but the permissions lockdown on template1 will
      not take effect unless you do one (or manually REVOKE TEMP ON DATABASE template1 FROM public).
      d61de589
  23. 27 Aug, 2002 1 commit
  24. 26 Aug, 2002 1 commit
    • Tom Lane's avatar
      Modify array operations to include array's element type OID in the · 5cabcfcc
      Tom Lane authored
      array header, and to compute sizing and alignment of array elements
      the same way normal tuple access operations do --- viz, using the
      tupmacs.h macros att_addlength and att_align.  This makes the world
      safe for arrays of cstrings or intervals, and should make it much
      easier to write array-type-polymorphic functions; as examples see
      the cleanups of array_out and contrib/array_iterator.  By Joe Conway
      and Tom Lane.
      5cabcfcc
  25. 09 Aug, 2002 1 commit
    • Tom Lane's avatar
      has_table_privilege spawns scions has_database_privilege, has_function_privilege, · 4ab8e690
      Tom Lane authored
      has_language_privilege, has_schema_privilege to let SQL queries test
      all the new privilege types in 7.3.  Also, add functions pg_table_is_visible,
      pg_type_is_visible, pg_function_is_visible, pg_operator_is_visible,
      pg_opclass_is_visible to test whether objects contained in schemas are
      visible in the current search path.  Do some minor cleanup to centralize
      accesses to pg_database, as well.
      4ab8e690
  26. 20 Jun, 2002 1 commit
  27. 27 Apr, 2002 1 commit
  28. 26 Apr, 2002 1 commit
  29. 21 Apr, 2002 1 commit
    • Tom Lane's avatar
      Restructure AclItem representation so that we can have more than eight · b0bcf8aa
      Tom Lane authored
      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
  30. 26 Mar, 2002 1 commit
  31. 21 Mar, 2002 1 commit
  32. 02 Mar, 2002 1 commit
    • Bruce Momjian's avatar
      Commit to match discussed elog() changes. Only update is that LOG is · a033daf5
      Bruce Momjian authored
      now just below FATAL in server_min_messages.  Added more text to
      highlight ordering difference between it and client_min_messages.
      
      ---------------------------------------------------------------------------
      
      REALLYFATAL => PANIC
      STOP => PANIC
      New INFO level the prints to client by default
      New LOG level the prints to server log by default
      Cause VACUUM information to print only to the client
      NOTICE => INFO where purely information messages are sent
      DEBUG => LOG for purely server status messages
      DEBUG removed, kept as backward compatible
      DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1 added
      DebugLvl removed in favor of new DEBUG[1-5] symbols
      New server_min_messages GUC parameter with values:
              DEBUG[5-1], INFO, NOTICE, ERROR, LOG, FATAL, PANIC
      New client_min_messages GUC parameter with values:
              DEBUG[5-1], LOG, INFO, NOTICE, ERROR, FATAL, PANIC
      Server startup now logged with LOG instead of DEBUG
      Remove debug_level GUC parameter
      elog() numbers now start at 10
      Add test to print error message if older elog() values are passed to elog()
      Bootstrap mode now has a -d that requires an argument, like postmaster
      a033daf5
  33. 18 Feb, 2002 1 commit
  34. 16 Nov, 2001 1 commit
    • Tom Lane's avatar
      IsSystemRelationName() treats TOAST relations as system relations. · c845b427
      Tom Lane authored
      This seems the right thing for most usages, but I notice two places
      where it is the wrong thing.  One is that the default permissions on
      TOAST rels should be no-access, not world-readable; the other is that
      PrepareForTupleInvalidation doesn't really need to spend time looking
      at tuples of TOAST relations.
      c845b427
  35. 25 Oct, 2001 1 commit
  36. 14 Jun, 2001 1 commit
  37. 12 Jun, 2001 2 commits
    • Bruce Momjian's avatar
      Back out has_table_privilege patch. · 76e9ad1f
      Bruce Momjian authored
      76e9ad1f
    • Bruce Momjian's avatar
      OK -- here's take #5. · 58c909bb
      Bruce Momjian authored
      It "make"s and "make check"s clean against current cvs tip.
      
      There are now both Text and Name variants, and the regression test support
      is rolled into the patch. Note that to be complete wrt Name based variants,
      there are now 12 user visible versions of has_table_privilege:
      
      has_table_privilege(Text usename, Text relname, Text priv_type)
      has_table_privilege(Text usename, Name relname, Text priv_type)
      has_table_privilege(Name usename, Text relname, Text priv_type)
      has_table_privilege(Name usename, Name relname, Text priv_type)
      has_table_privilege(Text relname, Text priv_type) /* assumes current_user */
      has_table_privilege(Name relname, Text priv_type) /* assumes current_user */
      has_table_privilege(Text usename, Oid reloid, Text priv_type)
      has_table_privilege(Name usename, Oid reloid, Text priv_type)
      has_table_privilege(Oid reloid, Text priv_type)  /* assumes current_user */
      has_table_privilege(Oid usesysid, Text relname, Text priv_type)
      has_table_privilege(Oid usesysid, Name relname, Text priv_type)
      has_table_privilege(Oid usesysid, Oid reloid, Text priv_type)
      
      For the Text based inputs, a new internal function, get_Name is used
      (shamelessly copied from get_seq_name in sequence.c) to downcase if not
      quoted, or remove quotes if quoted, and truncate. I also added a few test
      cases for the downcasing, quote removal, and Name based variants to the
      regression test.
      
      Joe Conway
      58c909bb
  38. 09 Jun, 2001 1 commit