On (14/06/05 09:32), John Hasler wrote: > I wrote: > > I get exactly the same error here. The user I am running pgAccess as is > > a PostgreSQL user. When I run psql I can create the database and then > > open it in pgAccess, but I can't create it in pgAccess. > > Clive writes: > > It's not a bug. If you've created a user and you want that user to be > > able to create databases or users, you need to grant those privileges, > > initially, as user postgres: > > Read what I wrote. The user (john) _has_ database creation privileges:
Apologies. I think the OP was in a different situation .... but I may be wrong. Your case does sound like a bug. I struggled with pgaccess at first and found pgadmin3 easier to use until I'd learnt more SQL. I created a postgresql user with superuser and create database permissions and then used pgadmin3 to create databases. I'll go and check whether I can create with pgaccess. Regards Clive -- www.clivemenzies.co.uk ... ...strategies for business -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
