From: | "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> |
---|---|
To: | Alex Knight <knight(at)phunc(dot)com> |
Cc: | "Thomas T(dot) Veldhouse" <veldy(at)veldy(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Function problem -- how do I drop this function? |
Date: | 2001-06-26 23:01:16 |
Message-ID: | Pine.LNX.4.21.0106261859560.27771-100000@aluminum.cs.pitt.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
you have to name all the args as well:
DROP FUNCTION CREATEUSER(varchar,varchar,varchar,car,varchar,varchar,boolean);
should work.
cheers,
thalis
On Tue, 26 Jun 2001, Alex Knight wrote:
> Thomas,
>
> DROP FUNCTION CREATEUSER; should suffice I believe.
>
> -Knight
>
> On Tue, 26 Jun 2001, Thomas T. Veldhouse wrote:
>
> > I have created the following procedure (using phpPgAdmin -- which is very
> > buggy). When I try to drop it using 'drop function CreateUser();', I am
> > told it does not exist. If I try using 'drop function
> > CreateUser(varchar(12), varchar(12), varchar(30), char(1), varchar(30),
> > varchar(30), boolean)', I am told it does not exist either. If I try it
> > from phpPgAdmin, I get this error;
> >
> > "PostgreSQL said: ERROR: parser: parse error at or near "varying"
> > Your query:
> > DROP FUNCTION
> > "CreateUser"(character,varying,,character,varying,,character,varying,,charac
> > ter,,character,varying,,character,varying,,boolean)
> > ".
> >
> > So, is there no way to drop this function?
> >
> > CREATE FUNCTION CreateUser(varchar(12), varchar(12), varchar(30), char(1),
> > varchar(30), varchar(30), boolean) RETURNS int4 AS '
> > DECLARE
> > id int4;
> > un ALIAS FOR $1;
> > pw ALIAS FOR $2;
> > fn ALIAS FOR $3;
> > mi ALIAS FOR $4;
> > ln ALIAS FOR $5;
> > ea ALIAS FOR $6;
> > a ALIAS FOR $7;
> > BEGIN
> > SELECT id = nextval('users_id_seq');
> > INSERT INTO users (id, username, password, firstname, middleinitial,
> > lastname, emailaddr, admin)
> > VALUES (id, un, pw, fn, mi, ln, ea, ad);
> > RETURN id;
> > END ' LANGUAGE 'plpgsql';
> >
> > Thanks,
> >
> > Tom Veldhouse
> > veldy(at)veldy(dot)net
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Knight | 2001-06-26 23:02:26 | Re: Capitalizing First Letter of Every Word |
Previous Message | Brian T. Allen | 2001-06-26 22:56:48 | Capitalizing First Letter of Every Word |