Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group