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

Re: pgAdmin3 bug

From: "Giovanni P(dot) Tirloni" <gpt(at)tirloni(dot)org>
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: pgAdmin3 bug
Date: 2004-08-18 15:23:36
Message-ID: 20571.200.181.210.22.1092842616.squirrel@webmail.bs2.com.br (view raw or flat)
Thread:
Lists: pgadmin-support
Andreas Pflug disse:
> min(at)pse-consulting(dot)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(at)postgresql(dot)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


In response to

pgadmin-support by date

Next:From: Andreas PflugDate: 2004-08-18 17:05:09
Subject: Re: pgAdmin3 bug
Previous:From: Patel, BirenDate: 2004-08-18 15:10:41
Subject: Error Message: Index out of bounds

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