On Sat, Sep 03, 2005 at 04:07:34PM +0200, Dick Kniep wrote: > Again after reconsidering the way this problem came to be, it struck me that > I > used a pg_dump -f /tmp/dumpdb and restored with psql. How can it be that not > all grants of the schema's, views and tables are restored? There were no > messages during the restore that could be interpreted as an indication that > the grants were not restored.
Do the necessary GRANT statements appear in the dump? What permissions do you see if you restore the dump again into a newly-created database? Among other ways, you can use psql's \z command to see permissions (you might need use "\z schemaname." or set your search_path to see what you're interested in). -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
