On Mon, 17 Apr 2006, Tom Lane wrote:
You didn't show us any attempt to create anything in contacts ...
To tie off the end of this thread, the application scripts have mixed case
names as well as no primary key values in some tables. The developers can now
see exactly what changes are necessa
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 i
>When I request a list of databases (psql -l), the one named contacts is
> there. However, when I open the database (psql contacts), there's no one
> home; that is, 'psql -d' returns 'no relations found.'
>
>I need a clue on how to let user 'xrms' access the database 'contacts' so
> the i
Rich Shepard <[EMAIL PROTECTED]> writes:
> postgres (from my user account):
> createdb contacts
> createuser xrms # This creates the ROLE xrms
> grant all on contacts to xrms; # This generates an error at 'to'.
That last is a SQL command, not a shell command, and anyway it would
default to as
I'm working with the XRMS Contact Management System developers to get the
application working with postgres as well as the original MySQL. My role is
trying what they've produced and reporting errors.
The application runs on a httpd server (apache-1.3.34 here) with any
browser; similar to SQL
