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.subscriptions@shepherdhill.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
>