From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'Bryan Bateman'" <batemanb(at)home(dot)com>, pgsql-interfaces(at)postgresql(dot)org |
Subject: | RE: pgAdmin problems |
Date: | 2000-11-29 08:28:54 |
Message-ID: | 8568FC767B4AD311AC33006097BCD3D61A2787@woody.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
> -----Original Message-----
> From: Bryan Bateman [mailto:batemanb(at)home(dot)com]
> Sent: 28 November 2000 13:57
> To: Dave Page; pgsql-interfaces(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2000-11-29 08:37:29 | RE: slow odbc access.... |
Previous Message | Martin Zeigler | 2000-11-29 02:11:34 | Fwd: errors with getObject() with JDBC driver |