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: | Raw Message | Whole Thread | 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 |