RE: Creating users

Dave,

I have used the facility that the C++ Builder suite provides, called
Database Explorer. As the name shows, you can explore
databases, connecting through the BDE alias (through the ODBC driver) and
execute queries.

I have tried using this tool, and I can add a user. What I do not
understand is why I cannot inside my C++ Builder application. I assume that
if It is possible through the ODBC driver, It can be also in my application.

By the way, where I can get the pgAdmin tool? I have read that it is the
best tool for administrating PostgreSQL in Windows.

Also I would like to ask something OFF-TOPIC. I have searched on the web,
read docs and ask in other mailing list but nobody tells me how the password
politics in PostgreSQL works. I would like to have some kind on encryption
accessing the database, I have tried to set in the pg_hba.conf an entry for
the host where my C++ application is, but when I use the crypt option rather
than password, I cannot connect through the ODBC driver.

Many thanks in advance

Miguel

pd: Dave - thanks for the compliment about my English.

> It used to be the case that you couldn't execute certain queries within a
> transaction - specifically CREATE/ALTER/DROP USER/DATA. I haven't noticed
> that it's changed, but the ODBC driver also wraps queries in a transaction
> if they're not already so you can't just drop the BEGIN; COMMIT;
>
> In pgAdmin, the workaround we use is to place a single space before the
> CREATE/ALTER/DROP eg.
>
> CREATE USER dpage
>
> becomes
>
> CREATE USER dpage
>
> This works currently but may not in the future releases of PostgreSQL if
the
> behaviour is changed.
>
> > Many thanks in advance and sorry for my English
>
> Why? It sounds better than mine and I've lived in .uk all my life!
>
> Regards, Dave.