Create User

DB Subscriptions <db.subscriptions@xxxxxxxxxxxxxxxx> · Fri, 20 Jan 2006 09:16:59 +0100

Hi,

I have this table:

CREATE TABLE users
(
 userid varchar(100) NOT NULL,
 nama varchar(50) NOT NULL,
 pword varchar(255) NOT NULL,
 groupe varchar(7) NOT NULL,
 rolle int2 NOT NULL DEFAULT 2,
 statux varchar(9) NOT NULL DEFAULT 'Active'::character varying,
 CONSTRAINT users_pkey PRIMARY KEY (userid)
)
WITHOUT OIDS;

I created a trigger to create a user based on the new insert into the 
table as follows:

CREATE OR REPLACE FUNCTION users_insert()
 RETURNS "trigger" AS
$BODY$
BEGIN
   CREATE USER NEW.userid WITH PASSWORD NEW.pword IN GROUP NEW.groupe;

   RETURN new;
END;

$BODY$
 LANGUAGE 'plpgsql' VOLATILE;

Surprisingly, I get this error message:

ERROR:  syntax error at or near "$1" at character 14
QUERY:  CREATE USER  $1  WITH PASSWORD  $2  IN GROUP  $3
CONTEXT:  SQL statement in PL/PgSQL function "users_insert" near line 10

I would appreciate your guidance.

Cheers.

Chris.

___________________________________________________________ 
Yahoo! Photos ? NEW, now offering a quality print service from just 8p a photo http://uk.photos.yahoo.com