Обсуждение: pgAdmin3 bug

I downloaded the latest win32 version - dated 8/17, although the
executable was dated 8/15?

(This is where it pays off to do things different from everyone else.)

I created for myself an account named "stevie-o".  Thus, to grant
access to the database, I have to do this:

grant select on foo to "stevie-o";

However, the little preview window that shows the script to recreate
the table gets a teeny little bit overzealous with the quote marks:

GRANT SELECT ON TABLE foo TO "\""stevie-o\""";

-- 
-- Stevie-O
Real programmers use COPY CON PROGRAM.EXE

Stephen Oberholtzer wrote:
> I downloaded the latest win32 version - dated 8/17, although the
> executable was dated 8/15?

This is correct, the new snapshot includes an old executable, with new docs.
> 
> However, the little preview window that shows the script to recreate
> the table gets a teeny little bit overzealous with the quote marks:
> 
> GRANT SELECT ON TABLE foo TO "\""stevie-o\""";

Don't enter " in the name field. pgAdmin adds them as required.

Regards,
Andreas

On Wed, 18 Aug 2004 10:18:42 +0000, Andreas Pflug
<pgadmin@pse-consulting.de> wrote:
> Stephen Oberholtzer wrote:
> > I downloaded the latest win32 version - dated 8/17, although the
> > executable was dated 8/15?
> 
> This is correct, the new snapshot includes an old executable, with new docs.
> >
> > However, the little preview window that shows the script to recreate
> > the table gets a teeny little bit overzealous with the quote marks:
> >
> > GRANT SELECT ON TABLE foo TO "\""stevie-o\""";
> 
> Don't enter " in the name field. pgAdmin adds them as required.

I didn't enter " in the name field.  The login name is stevie-o.
Because the hyphen is treated as a token separator, the grant
statement (as SQL) needs to look like this:

GRANT SELECT ON TABLE foo TO "stevie-o"

But when pgAdmin3 tries to show the SQL that would recreate table foo,it appears to be adding two additional pairs of
quotationmarks.
 

> 
> Regards,
> Andreas
> 


-- 
-- Stevie-O
Real programmers use COPY CON PROGRAM.EXE

min@pse-consulting.de> wrote:

> 
> I didn't enter " in the name field.  The login name is stevie-o.
> Because the hyphen is treated as a token separator, the grant
> statement (as SQL) needs to look like this:
> 
> GRANT SELECT ON TABLE foo TO "stevie-o"
> 
> But when pgAdmin3 tries to show the SQL that would recreate table foo,
>  it appears to be adding two additional pairs of quotation marks.
> 

Can anybody check this on 7.4? On 8.0 the acl has \" in it, seems this 
is new.

Regards,
Andreas

Andreas Pflug disse:
> min@pse-consulting.de> wrote:
>
>>
>> I didn't enter " in the name field.  The login name is stevie-o.
>> Because the hyphen is treated as a token separator, the grant
>> statement (as SQL) needs to look like this:
>>
>> GRANT SELECT ON TABLE foo TO "stevie-o"
>>
>> But when pgAdmin3 tries to show the SQL that would recreate table foo,
>>  it appears to be adding two additional pairs of quotation marks.
>>
>
> Can anybody check this on 7.4? On 8.0 the acl has \" in it, seems this
> is new.
>
> Regards,
> Andreas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
This is pgadmin3 (2004/08/17) with PostgreSQL 7.4.3. It shows:
GRANT SELECT ON TABLE foo TO "\""stevie-o\""";
after I used this on psql:
GRANT SELECT ON TABLE foo TO "stevie-o";

-- 
Giovanni P. Tirloni

Fixed in CVS, thanks for reporting.

Regards,
Andreas