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 n
Hi list,
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
Hi list/Michael,
Sorry I forgot "reply to all"
It proved to be a problem with the permissions on the table and view! So, the
error that was reported was completely different from the actual error. I do
not know how this can happen, but by making a direct connection to the
database within Zope,
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion. I've quoted more of your message
than I ordinarily would because other people won't have seen it and
they won't find it in the list archives.]
On Thu, Sep 01, 2005 at 11:35:43PM +0200, Dick Kniep w
On Thu, Sep 01, 2005 at 06:13:13PM +0200, Dick Kniep wrote:
>
> cvix=# SELECT set_config('search_path', '"' || t2.schema || '"', true)
> cvix-# FROM "Lindix"."Gebruikers" as t1, "Lindix"."Administratie" as t2
> cvix-# WHERE uid = 'zon0023'
> cvix-# AND t1.administratie_id = t2.administratie_id;
>
Hi list,
we are using schema's to separate different administrations, and are using
Zope/Plone as a front-end portal to the database.
In this installation almost the first statement is:
cvix=# SELECT set_config('search_path', '"' || t2.schema || '"', true)
cvix-# FROM "Lindix"."Gebruikers" as