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

Re: Please help me to take a look of the erros in my functions. Thanks.

From: leaf_yxj <leaf_yxj(at)163(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Please help me to take a look of the erros in my functions. Thanks.
Date: 2012-04-03 14:01:39
Message-ID: 1333461699378-5615212.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-general
***********************************************************

CREATE OR REPLACE FUNCTION truncate_t (IN tablename text)
RETURNS VOID
AS
$$
BEGIN
	EXECUTE 'TRUNCATE TABLE ' || quote_ident(tablename) || 'CASCADE;';
EXCEPTION
	WHEN undefined_table THEN
		RAISE EXCEPTION 'Table "%" does not exists', tablename;
END;
$$
LANGUAGE plpgsql SECURITY DEFINER STRICT;

***********************************************************

This works . Thank you very much.


***********************************************************

CREATE OR REPLACE FUNCTION truncate_t (tablename text)
RETURNS VOID
AS
$$
BEGIN
	EXECUTE 'TRUNCATE TABLE ' || quote_ident(tablename) || 'CASCADE;';
EXCEPTION
	WHEN undefined_table THEN
		RAISE EXCEPTION 'Table "%" does not exists', tablename;
END;
$$
LANGUAGE plpgsql SECURITY DEFINER STRICT;

***********************************************************
This works,too. Thank you very much.   What's the difference between ( IN
tablename text)
and ( tablename text).



---------- one more questions  thanks.



After I created the function sucessfully , I want to execute the function. I
get errors as follows :

rrp=> select truncate_t(t1);
ERROR: column "t1" does not exist
LINE 1 : select truncate_t(t1);
                                    ^



rrp=> select truncate_t(rrp.t1);
ERROR:missing FROM-clause entry for table "rrp" 
LINE 1 : select truncate_t(rrp.t1);
                                    ^


--
View this message in context: http://postgresql.1045698.n5.nabble.com/Please-help-me-to-take-a-look-of-the-erros-in-my-functions-Thanks-tp5613507p5615212.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

pgsql-general by date

Next:From: leaf_yxjDate: 2012-04-03 14:06:54
Subject: Re: Please help me to take a look of the erros in my functions. Thanks.
Previous:From: Robert HaasDate: 2012-04-03 12:22:31
Subject: Re: Switching to Homebrew as recommended Mac install?

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