Re: Rights in 7.4 - Mailing list pgsql-general

From Tom Lane
Subject Re: Rights in 7.4
Date
Msg-id 4985.1074107915@sss.pgh.pa.us
Whole thread Raw
In response to Rights in 7.4  (Francisco Reyes <lists@natserv.com>)
Responses Re: Rights in 7.4  (Francisco Reyes <lists@natserv.com>)
List pgsql-general
Francisco Reyes <lists@natserv.com> writes:
> How does one now create a database and make sure that everything inside is
> owned by a particular user?

System objects are not, and should not be, owned by any nonprivileged
user.  I fail to see what your complaint is.

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

You have not given us any context to interpret this report in, but
I do not think it has anything to do with the ownership of the public
schema.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Schemas not created on restore
Next
From: Matt Davies
Date:
Subject: Re: Postgress and MYSQL