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
