BUG #1248: pg_dump produces grants with concatonated elements

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1248: pg_dump produces grants with concatonated elements
Date: 2004-09-08 21:48:54
Message-ID: 20040908214854.43C555A1174@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1248
Logged by: Timothy LoGrasso

Email address: timlograsso(at)yahoo(dot)com

PostgreSQL version: 7.3.5

Operating system: SunOS 5.9

Description: pg_dump produces grants with concatonated elements

Details:

pg_dump produces the following grants:
GRANT INSERTSELECTUPDATE ON TABLE camp_score TO mn;

Obviously there are no commas or spaces seperating the different privs. I'm
actually running the following version: PostgreSQL 7.3.6 on
i386-pc-solaris2.8, compiled by cc -fast -xarch=386 -Xa

Attached is the ddl to create the table and grant permissions.

CREATE USER mn PASSWORD 'mn';
CREATE USER mnview PASSWORD 'mnview';
CREATE USER mgr PASSWORD 'mgr';
CREATE USER mndb PASSWORD 'mndb';

CREATE TABLE camp_score (
ipr_number character varying(15) NOT NULL,
performed_by character(6),
score_date date,
hs_comp smallint,
hs_tech smallint,
hs_hyg smallint,
hs_safe smallint,
hs_fire smallint,
hs_hp smallint,
hs_crit smallint,
hs_infr smallint,
ew_comp smallint,
ew_tech smallint,
ew_liq smallint,
ew_sol smallint,
ew_air smallint,
ew_min smallint,
ew_rest smallint,
ew_corr smallint,
ew_infr smallint,
ss_comp smallint,
ss_tech smallint,
ss_snm_acc smallint,
ss_snm_prot smallint,
ss_class_prot smallint,
ss_prop_prot smallint,
ss_hostile_prot smallint,
ss_infr smallint,
mi_comp smallint,
mi_tech smallint,
mi_bb smallint,
mi_mission smallint,
mi_asset smallint,
mi_natl smallint,
mi_infr smallint
);

--
-- TOC entry 8 (OID 37311)
-- Name: camp_score; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE camp_score FROM PUBLIC;
GRANT INSERT, SELECT, UPDATE ON TABLE camp_score TO mn;
GRANT ALL ON TABLE camp_score TO mndb;
GRANT SELECT ON TABLE camp_score TO mgr;
GRANT INSERT, SELECT, UPDATE ON TABLE camp_score TO mnview;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Devrim GUNDUZ 2004-09-08 22:07:33 Re: BUG #1247: pltcl.so does not exist in postgresql-pl RPM
Previous Message Tom Lane 2004-09-08 20:54:08 Re: PosgreSQL is crashing with a signal 11 - Bug?