> -----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.