| From: | Keith F Irwin <kirwin14(at)home(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | HELP! BUG? pg_dump mucks up grant/revoke |
| Date: | 2001-07-18 02:44:49 |
| Message-ID: | 995424289.30421.20.camel@c234192-a |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
(Hm. Not sure this went through the first time, so resending: sorry for
the duplicate.)
Hi:
I'm using pg 7.1.2.
I've got a database with views which have permissions granted to a
certain
user. Defined something like:
create view whatever....
revoke all on whatever from user
grant select on whatever to user
(If I get the syntax wrong, it doesn't matter here.)
THEN, I do a pg_dump:
pg_dump --attribute-inserts database > dump.sql
all well and good expect for one thing: the grant/revoke lines appear
BEFORE the create view definitions, so when I read the dump back into
postgres via:
dropdb database
createdb database
cat dump.sql | psql database
I get "relation doesn't exist" errors and my "user" no longer has
permission to use those views. This is a bug, isn't it?
Keith
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2001-07-18 02:57:47 | Re: PG rules! (RULES being the word ;->) |
| Previous Message | Justin Clift | 2001-07-18 02:28:47 | Re: undeleteable records |