Re: Create User

Thanks Pandurangan.

The Function could not even be saved or created. The error is not at the
insert level but at the creation of the trigger function.

Regards.

Pandurangan R S wrote:

>I hope this error arises when you do a insert.
>Can u post your insert statement that caused this error?
>
>On 1/20/06, DB Subscriptions <db(dot)subscriptions(at)shepherdhill(dot)biz> wrote:
>
>
>>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
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>>
>>

___________________________________________________________
To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com