1. 20 Jan, 2009 3 commits
    • Peter Eisentraut's avatar
      Revise the permission checking on user mapping DDL commands. · 93a6be63
      Peter Eisentraut authored
      CREATE/ALTER/DROP USER MAPPING are now allowed either by the server owner or
      by a user with USAGE privileges for his own user name.  This is more or less
      what the SQL standard wants anyway (plus "implementation-defined")
      
      Hide information_schema.user_mapping_options.option_value, unless the current
      user is the one associated with the user mapping, or is the server owner and
      the mapping is for PUBLIC, or is a superuser.  This is to protect passwords.
      
      Also, fix a bug in information_schema._pg_foreign_servers, which hid servers
      using wrappers where the current user did not have privileges on the wrapper.
      The correct behavior is to hide servers where the current user has no
      privileges on the server.
      93a6be63
    • Bruce Momjian's avatar
      Update \d*S documentation to be more accurate; system objects are added · fe626982
      Bruce Momjian authored
      to the display, not restricted in the display; new text:
      
              The letter <literal>S</literal> adds the listing of system
              objects; without <literal>S</literal>, only non-system
              objects are shown.
      fe626982
    • Bruce Momjian's avatar
      Make psql \d and \dt consistent for system tables, i.e prevent \d from · 71928e7b
      Bruce Momjian authored
      showing system tables, make \dS pattern show system table details, and
      have \dtS show system and _user_ tables, to be consistent with other \d*
      commands.
      71928e7b
  2. 19 Jan, 2009 7 commits
  3. 18 Jan, 2009 1 commit
    • Tom Lane's avatar
      Fix a pg_dump output ordering problem introduced in 8.3 by the addition of · 390081e3
      Tom Lane authored
      array types for composite types.  Although pg_dump understood it wasn't
      supposed to dump these array types as separate objects, it must include
      them in the dependency ordering analysis, and it was improperly assigning them
      the same relatively-high sort priority as regular types.  This resulted in
      effectively moving composite types and tables up to that same high priority,
      which broke any ordering requirements that weren't explicitly enforced by
      dependencies.  In particular user-defined operator classes, which should come
      out before tables, failed to do so.  Per report from Brendan Jurd.
      
      In passing, also fix an ill-considered decision to give text search objects
      the same sort priority as functions and operators --- the sort result looks
      a lot nicer if different object types are kept separate.  The recent
      foreign-data patch had copied that decision, making the sort ordering even
      messier :-(
      390081e3
  4. 17 Jan, 2009 2 commits
  5. 16 Jan, 2009 4 commits
  6. 15 Jan, 2009 11 commits
  7. 14 Jan, 2009 9 commits
  8. 13 Jan, 2009 3 commits