PostgreSQL: Exception when relation does not exist

Question

Here I am trying to display a error message when relation does not exist then exception occurred.

Example:

Create or replace function fun_test() returns void as
$$ 
Begin
     Truncate testtb;
     Exception 
     When does_not_exist then /* When testtb does not exist*/
          raise info 'Relation does not exists';
     ...

ERROR: unrecognized exception condition "does_not_exist"

double_word_disruptor · Accepted Answer · 2014-05-23 10:57:40Z

7

The condition "does_not_exist" does not exist. Refer to http://www.postgresql.org/docs/9.3/static/errcodes-appendix.html

For testing use code like this ...

EXCEPTION
  WHEN others THEN
    RAISE NOTICE '%; SQLSTATE: %', SQLERRM, SQLSTATE;

If you want to truncate more tables I suggest to use a function.

edited May 23, 2014 at 10:57

answered May 23, 2014 at 10:49

double_word_disruptor

1894 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dijkstra · Accepted Answer · 2014-12-25 09:32:42Z

6

You can handle with "undefined_table".

EXCEPTION WHEN undefined_table THEN
     RAISE NOTICE '%; SQLSTATE: %', SQLERRM, SQLSTATE;

answered Dec 25, 2014 at 9:32

dijkstra

1,0682 gold badges16 silver badges40 bronze badges

Collectives™ on Stack Overflow

PostgreSQL: Exception when relation does not exist

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related