Re: pgAdmin3 bug

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