Rights in 7.4

From: Francisco Reyes <lists(at)natserv(dot)com>
To: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Rights in 7.4
Date: 2004-01-14 10:50:01
Message-ID: 20040114104537.R10145@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Recently switched to 7.4.1 and noticed that there are now several schemas
besides public. In addition even if I create the database with
AUTHORIZATION to a particular user the schemas are owned by the superuser.
This is a problem with restores. In particular with restoring sequences.
How does one now create a database and make sure that everything inside is
owned by a particular user?

For the public schema I just dropped it and then recreated and gave a
particular user ownership, but pg_catalog has many tables and I could not
do the same procedure.

The line from the sql file that is failing, a dump, is
SELECT pg_catalog.setval('invoicesdetails_invoicesdetailsid_seq', 18,
true);

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrei Ivanov 2004-01-14 10:50:45 Re: dump/restore problem
Previous Message Paul Thomas 2004-01-14 10:24:02 Re: Nested transaction - I am a bank ??