Hello,
Could someone show me how to catch exceptions generated by plpy.execute()?
From the documentation and other posts I understand that you need to call plpy.
error() but I still cannot figure out how to use it.
For example, say I need a function that creates table foo if it doesn't
exists, otherwise returns the rows in foo. Initially I thought the following
shouldl work... but it doesn't!
--
create or replace function test_tryex() returns void AS $$
try:
plpy.execute('create table tmp_foo (v1 int);')
except:
plpy.execute('select * from tmp_foo;')
$$
language plpythonu;
--
-- If tmp_foo already exists I get:
select test_tryex();
********** Error **********
ERROR: relation "tmp_foo" already exists
SQL state: 42P07
Context: SQL statement "create table tmp_foo (v1 int);"
Many thanks in advance
Dario
