Re: Rights in 7.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Francisco Reyes <lists(at)natserv(dot)com>
Cc: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Rights in 7.4
Date: 2004-01-14 19:18:35
Message-ID: 4985.1074107915@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Francisco Reyes <lists(at)natserv(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ezra epstein 2004-01-14 19:23:40 Re: Trigger Question
Previous Message Tom Lane 2004-01-14 19:15:38 Re: Schemas not created on restore