Re: role does not exist

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Kevin Burton <rkevinburton(at)charter(dot)net>
Cc: Kevin Grittner <kgrittn(at)mail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: role does not exist
Date: 2012-11-03 05:19:05
Message-ID: 5094A949.2080405@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/03/2012 12:17 PM, Kevin Burton wrote:
> I was not aware of the login option. That is probably the solution. Thank you.
You can ALTER the user to add the LOGIN right, or just DROP it and
re-CREATE it again.

CREATE USER is shorthand for CREATE ROLE ... LOGIN

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Arvind Singh 2012-11-03 07:03:21 Update latest column in master table from transaction table
Previous Message Hernán Cano Martínez 2012-11-03 05:11:14 About PostgreSQL as developer