Postgres Pro
Downloads
Home   >   mailing lists

Thread: Function problem -- how do I drop this function?

Function problem -- how do I drop this function?

From
"Thomas T. Veldhouse"
Date:
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@veldy.net

Re: Function problem -- how do I drop this function?

From
Alex Knight
Date:
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@veldy.net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

Re: Function problem -- how do I drop this function?

From
"Thalis A. Kalfigopoulos"
Date:
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@veldy.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
>

Re: Function problem -- how do I drop this function?

From
Alex Knight
Date:
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@veldy.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
>