ERROR: parser: parse error at or near "execute"

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: ERROR: parser: parse error at or near "execute"
Date: 2001-07-31 20:38:39
Message-ID: 200107312038.f6VKcdj25830@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Christian Villa Real Lopes (chris_br(at)email(dot)com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
ERROR: parser: parse error at or near "execute"

Long Description
I created a function to drop a table if it exists. On pgsql-7.0.3 this function returns an error, as follow :

template1=# SELECT func_drop_table('friend');
ERROR: parser: parse error at or near "execute"

On pgsql-7.1.2 this function works fine and no error returns just the following lines :

func_drop_table
---------------
friend

Sample Code
CREATE TABLE friend (
firstname CHAR(15),
lastname CHAR(20),
city CHAR(15),
state CHAR(2),
age INTEGER
);

CREATE FUNCTION "func_drop_table"(TEXT)
RETURNS TEXT AS '
DECLARE
v_reg RECORD;
v_tab TEXT;
BEGIN
FOR v_reg IN SELECT * FROM pg_tables WHERE tablename LIKE $1 LOOP
v_tab := ''DROP TABLE '' || v_reg.tablename || '';'';
EXECUTE v_tab;
END LOOP;
RETURN $1;
END;' LANGUAGE 'plpgsql';

SELECT func_drop_table('friend');

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2001-07-31 22:43:14 Re: ERROR: parser: parse error at or near "execute"
Previous Message Tom Lane 2001-07-31 18:43:51 Re: subquery results bypassed