From: | Alex Knight <knight(at)phunc(dot)com> |
---|---|
To: | "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> |
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:03:08 |
Message-ID: | Pine.LNX.4.33.0106261602580.18309-100000@blowfish.phunc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Been a while since I've dropped a function :)
On Tue, 26 Jun 2001, Thalis A. Kalfigopoulos wrote:
> 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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Knight | 2001-06-26 23:04:22 | Re: Capitalizing First Letter of Every Word |
Previous Message | Alex Knight | 2001-06-26 23:02:26 | Re: Capitalizing First Letter of Every Word |