Re: [GENERAL] Rights in 7.4

2004-01-14 Thread Tom Lane
Francisco Reyes <[EMAIL PROTECTED]> writes: > Should restores be always done by the super user? If every object in the dump is owned by the same nonprivileged user, it will work to restore as that user. You can also use --no-owner to get the same effect (everything winds up owned by the user runn

Re: [GENERAL] Rights in 7.4

2004-01-14 Thread Francisco Reyes
On Wed, 14 Jan 2004, Tom Lane wrote: > > 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 th

Re: [GENERAL] Rights in 7.4

2004-01-14 Thread Tom Lane
Francisco Reyes <[EMAIL PROTECTED]> 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 th