SEO

Our naming standard here is first_name.last_name so my username at work
is jon.roberts. When I look at the DDL script created by pgAdmin, it
doesn't format my name properly for the grants. It does format it
properly for the owner.


Example:

-- Table: jon.part_test

-- DROP TABLE jon.part_test;

CREATE TABLE jon.part_test
(
id integer NOT NULL,
first_name character varying(30) NOT NULL,
last_name character varying(50) NOT NULL,
address_1 character varying(100) NOT NULL,
address_2 character varying(100),
city character varying(50) NOT NULL,
state character varying(2) NOT NULL,
zip character varying(10) NOT NULL,
load_date date NOT NULL,
load_timestamp_with_timezone timestamp with time zone NOT NULL,
load_timestamp_without_timezone timestamp without time zone NOT NULL,
CONSTRAINT part_test_pkey PRIMARY KEY (id)
)
WITH (OIDS=FALSE);
ALTER TABLE jon.part_test OWNER TO "jon.roberts";
GRANT ALL ON TABLE jon.part_test TO "\""jon.roberts\""";
GRANT SELECT ON TABLE jon.part_test TO dev;


This is incorrect:
GRANT ALL ON TABLE jon.part_test TO "\""jon.roberts\""";

This is correct:
GRANT ALL ON TABLE jon.part_test TO "jon.roberts";

Executing this incorrect line fails with this:
ERROR: role "\"jon.roberts\"" does not exist

********** Error **********

ERROR: role "\"jon.roberts\"" does not exist
SQL state: 42704



Jon

--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

On Thu, May 1, 2008 at 3:18 PM, Roberts, Jon <Jon.Roberts@asurion.com> wrote:
> Our naming standard here is first_name.last_name so my username at work
> is jon.roberts. When I look at the DDL script created by pgAdmin, it
> doesn't format my name properly for the grants. It does format it
> properly for the owner.
>

Thanks for the report - fixed in SVN for 1.8.3.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers