From: | iafmgc(at)unileon(dot)es |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Creating Users |
Date: | 2001-08-14 20:29:12 |
Message-ID: | 200108141829.UAA20974@isidoro2.unileon.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
dear all,
I am developing a client application with C++ Builder 3 to access a
Database designed with PostgreSQL 7.0.4 using a BDE alias through the ODBC
driver.
I would like to have a form where I can add users to my users table of my
database and also create the corresponding entry to the postgres pg_user
table.
What I have tried through the Database Explorer is the following
transaction (I use begin and commit, otherwise the parser complains):
BEGIN;
CREATE USER user1 WITH PASSWORD 'passwd_user1' IN GROUP users_invui;
COMMIT;
I check in the pg_user table but no entry is added. I execute without the
begin and the commit comands the same query in the backend (psql) and it
works perfectly. What am I doing wrong?
Many thanks in advance and sorry for my English
Miguel
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2001-08-15 10:47:42 | Re: Can someone please send me an original |
Previous Message | Allan Engelhardt | 2001-08-14 20:20:46 | Re: Find a broken table |