RE: pgAdmin problems

> -----Original Message-----
> From: Bryan Bateman [mailto:batemanb@home.com]
> Sent: 28 November 2000 13:57
> To: Dave Page; pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] pgAdmin problems
> 
> 
> Almost there.
> 
> The inserts below worked like a charm.
> 
> I have one more problem and I know it is my lack of experience with
> Postgresql.  I have scanned the doucumentaion and can not 
> figure this one
> out.  I have attached one more log file entry with the 
> username and password
> altered to protect the innocent (me).  I got this error when trying to
> execute system/users from the menu.  When I created the user 
> in question, I
> gave it permission to create tables and new users.  I then 
> did an alter user
> to assign a password.
> 
> Is there anything else I need to do to the user configuration 
> to make it
> work????

You need to logged into a superuser account - often this would be
'postgres'. Unfortunately this will still not work in PostgreSQL 7.0.X as
there was a change to the backend which prevented the execution of certain
queries within a transaction block which is alway the case via ODBC. This
has been fixed in the the current development code for PostgreSQL for USER
and VACUUM queries but CREATE/DROP DATABASE queries still seem to suffer the
same problem.

Regards,
Dave.