Drop function in Postgres

Question

I have the following function:

CREATE FUNCTION "updateStat"(_request_date timestamp without time zone, _calls integer, _latency integer) RETURNS void AS $$
BEGIN
  LOCK TABLE "statistics" IN SHARE ROW EXCLUSIVE MODE;
  WITH upsert AS (UPDATE "statistics" set calls = calls + _calls, total_latency = total_latency + _latency WHERE request_date=_request_date RETURNING request_date)
  INSERT INTO "statistics" ("request_date", "calls", "total_latency") SELECT _request_date, _calls, _latency WHERE NOT EXISTS (SELECT "request_date" FROM upsert);
END;
$$ LANGUAGE plpgsql;

How can I drop such function?

I have tried the following:

# DROP FUNCTION updateStat(void);
ERROR:  function updatestat(void) does not exist
# DROP FUNCTION updateStat();
ERROR:  function updatestat() does not exist

What do you pass void as argument types list ?

Denys Séguret
– Denys Séguret

2015-02-20 14:37:40 +00:00
Commented Feb 20, 2015 at 14:37 — Denys Séguret
– Denys Séguret, Commented Feb 20, 2015 at 14:37
Becouse I though that it needs the return type

lante
– lante

2015-02-20 14:38:21 +00:00
Commented Feb 20, 2015 at 14:38 — lante
– lante, Commented Feb 20, 2015 at 14:38

cms · Accepted Answer · 2015-02-20 14:37:16Z

7

DROP FUNCTION "updateStat"(timestamp without time zone, integer, integer);

You might want to consider using CREATE OR REPLACE FUNCTION... in your create script, so you can redefine it without needing to drop it each time.

answered Feb 20, 2015 at 14:37

cms

5,9922 gold badges31 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

lante Over a year ago

thanks for your reply, but it doesnt work for me :(, this is returning ERROR: function updatestat(timestamp without time zone, integer, integer) does not exist. but when I do a \df in the CLI this is showing me the function as you describe: see this image

cms Over a year ago

@lante even with the quotes ? I left those out of the first edit, sorry. They're necessary to get the mixed case name to work.

user330315 Over a year ago

@lante: for details on why you need the quotes, please see the manual: postgresql.org/docs/current/static/… In general it's better to avoid quoted identifiers alltogether.

bcag2 Over a year ago

in my case, I created two functions with the same name, one with json param and one with 3 text params. To drop one, in psql (CLI), I typed DROP FUNCTION my_function( then I typed tab keyboard key and psql suggest json or text, text, text

Collectives™ on Stack Overflow

Drop function in Postgres

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related