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

need help with drop table command



I'm writing a function to drop tables until there is no table left,
but I get an error

ERROR:  query has no destination for result data, It seems to be on
the line with the EXECUTE command.
Can someone help me understand this error?


CREATE OR REPLACE FUNCTION droptables() RETURNS void AS $$
DECLARE
	post RECORD;
BEGIN
	LOOP
		FOR post IN SELECT tablename FROM pg_tables WHERE tableowner='bduser' LOOP
			BEGIN
				EXECUTE 'DROP TABLE '||post.tablename;
			EXCEPTION WHEN OTHERS THEN
			END;
		END LOOP;
		SELECT count(*) FROM pg_tables WHERE tableowner='bduser';
		IF NOT FOUND THEN
			EXIT; --avbryt om vi inte hittar fler
		END IF;
	END LOOP;
END;
$$ LANGUAGE plpgsql;



Home | Main Index | Thread Index

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