Re: Syntax Help Requested - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Syntax Help Requested
Date
Msg-id 1145293906.9080.13.camel@localhost.localdomain
Whole thread Raw
In response to Syntax Help Requested  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
>    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 install script runs correctly.

You can't grant all on multiple objects. You have to grant on each
object explicitly.

Joshua D. Drake



>
> TIA,
>
> Rich
>
--

            === The PostgreSQL Company: Command Prompt, Inc. ===
      Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
      Providing the most comprehensive  PostgreSQL solutions since 1997
                     http://www.commandprompt.com/





pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Syntax Help Requested
Next
From: Tom Lane
Date:
Subject: Re: Will changing the server date/time cause problems?