Skip site navigation (1) Skip section navigation (2)

Re: Bug#387256: pgadmin3: missing schema parameter

From: Raphaël Enrici <blacknoz(at)club-internet(dot)fr>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: PgAdmin Hackers <pgadmin-hackers(at)postgresql(dot)org>,Luca Arzeni <l(dot)arzeni(at)iname(dot)com>, 387256-forwarded(at)bugs(dot)debian(dot)org
Subject: Re: Bug#387256: pgadmin3: missing schema parameter
Date: 2006-09-28 08:17:39
Message-ID: 451B8523.1040302@club-internet.fr (view raw or flat)
Thread:
Lists: pgadmin-hackers
Dave Page wrote:
> Thanks, tweaked version of the patch applied for 1.6.

Thanks Dave, I'll apply my patch to 1.4.3 in debian rapidly. If I 
understand well, 1.4.3 is the last version which will ever be released 
in the 1.4.x branch. Right? If not, maybe we should add it to 
/branches/REL-1_4_0_PATCHES?

Regards,
Raph

> 
> Regards, Dave 
> 
> 
>>-----Original Message-----
>>From: pgadmin-hackers-owner(at)postgresql(dot)org 
>>[mailto:pgadmin-hackers-owner(at)postgresql(dot)org] On Behalf Of 
>>Raphaël Enrici
>>Sent: 27 September 2006 21:44
>>To: PgAdmin Hackers
>>Cc: Luca Arzeni; 387256-forwarded(at)bugs(dot)debian(dot)org
>>Subject: Re: [pgadmin-hackers] Bug#387256: pgadmin3: missing 
>>schema parameter during backup
>>
>>Hi Luca,
>>
>>sorry for the delay. I confim I can reproduce this and the 
>>the solution
>>you propose seems to be viable. I've managed to produce a patch for it
>>I'm sending upstream so that it can be validated.
>>
>>@pgadmin-hackers: Luca is facing the issue described below. In short,
>>when you try to export a table from a schema A which is also 
>>present in
>>a schema B, both the table are tried for backup. The patch attached
>>forces the table's schema name to be passed as an argument to pg_dump.
>>
>>Something off topic, @Luca: it seems you are using an old backport of
>>pgAdmin III although apt prefers unstable. Any reason for not 
>>upgrading
>>to latest 1.4.3-1?
>>
>>Regards,
>>Raph
>>
>>Luca Arzeni wrote:
>>
>>>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
>>


In response to

Responses

pgadmin-hackers by date

Next:From: svnDate: 2006-09-28 08:20:44
Subject: SVN Commit by dpage: r5405 - in trunk/pgadmin3: i18n i18n/es_ES pkg/win32/src
Previous:From: Dave PageDate: 2006-09-28 08:09:23
Subject: Re: Patches and a .po file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group