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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Using Execute with Dynamic Raise Commands



Hi All,
I've been trying to create a debugging function that would receive a tablename and a list of columns and then the function would display all the contents of the table using the RAISE command.

CREATE OR REPLACE FUNCTION usp_PG_DUMPTEMPTABLE(varchar(100), text[])
  RETURNS void AS
$BODY$
DECLARE
   _temptable ALIAS FOR $1;
   _temparray alias for $2;
_i integer;
   _max             integer;
   _tempstring        varchar(2000);

BEGIN
_tempstring := 'RAISE INFO''';
   for _i in 1 ..array_upper(_temparray, 1)
   loop
       _tempstring := _tempstring || _temparray[_i] || '   ' ;
   end loop;
   _tempstring := _tempstring || ''';';

   raise info'%', _tempstring;
   execute _tempstring;
   raise info '---';

RETURN;
END;
$BODY$
  LANGUAGE 'plpgsql';


for some reason, the EXECUTE command issues an error at the start fo the RAISE command...help?

Error from PG Admin III

ERROR:  syntax error at or near "RAISE"
LINE 1: RAISE DEBUG 'SKUID   CatID   ';
       ^
QUERY:  RAISE DEBUG 'SKUID   CatID   ';
CONTEXT: PL/pgSQL function "usp_pg_dumptemptable" line 42 at EXECUTE statement


Regards



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group