Package: pgadmin3 Version: 1.4.0-0.3.release.sarge.2 Severity: normal Tags: patch
I define two or more schemas in a database (say schema1 and schema2) and restrict user access to them (say user1 can work on schema1 only, and user2 can work on schema2 only). user1 creates table "addressbook" in schema1 user2 creates table "addressbook" in schema2 They work fine on their tables, but if user1 select table addressbook in pgadmin3 object browser and tries to backup that table, pgadmin3 refuses to execute the requested operation saying that user1 has not enough rights to access table addressbook. Problem is: pgadmin3 invokes command line tool pg_dump, without specifying the --schema=schema1 option in the command line. Solution/Patch: add --schema=schemaNameOfTheSelectedTable to the command line of pg_dump -- System Information: Debian Release: 3.1 APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.11.5-686-smp-p4-w4l-himem Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1) Versions of packages pgadmin3 depends on: ii libc6 2.3.2.ds1-22 GNU C Library: Shared libraries an ii libgcc1 1:3.4.3-13sarge1 GCC support library ii libpq3 7.4.7-6sarge2 PostgreSQL C client library ii libssl0.9.7 0.9.7e-3sarge2 SSL shared libraries ii libstdc++5 1:3.3.5-13 The GNU Standard C++ Library v3 ii libwxgtk2.6-0 2.6.1.0-0.pgadmin3.sarge.1 wxWidgets Cross-platform C++ GUI t ii pgadmin3-data 1.4.0-0.3.release.sarge.2 Graphical administration tool for -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
