Re: Syntax Help Requested

On Mon, 17 Apr 2006, Tom Lane wrote:

> That last is a SQL command, not a shell command, and anyway it would
> default to assuming you were trying to grant privileges on a table named
> "contacts" not a database named contacts.

Tom,

I should have been clearer, that I was logged in to psql when I issued the
latter command.

An off-list suggestion to use the syntax shown in psql's '\h grant' seems
to have worked:
grant all priviledges on database contacts to xrms;
returned no errors.

> You didn't show us any attempt to create anything in contacts ...

The install script does this.

> What exactly happens when you try to run the script?

I get a bunch of error messages. I've passed those on to the xrms
developers.

> With the default setup it shouldn't really matter whether xrms is the owner
> of the contacts database or not.

I didn't think so.

Thanks,

Rich

--
Richard B. Shepard, Ph.D. | Quantifying subjectivity for the
Applied Ecosystem Services, Inc.(TM) | benefit of business and society.
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863