Anton A. Patrushev wrote:
> Hi Alvaro,
>
> In the function I'm trying to drop this table if it already exists:
>
> BEGIN
>
> DROP TABLE vertices_tmp;
> EXCEPTION
> WHEN UNDEFINED_TABLE THEN
> END;
>
> CREATE TABLE vertices_tmp ( id serial );
>
> ...
It still works for me. Can you try my function on your system? Does it
crash?
create or replace function test_anton() returns void language plpgsql
as $$
begin
begin
drop table anton;
exception
when undefined_table then
end;
create table anton(a serial);
end; $$;
--
Alvaro Herrera Developer, http://www.PostgreSQL.org/
"Digital and video cameras have this adjustment and film cameras don't for the
same reason dogs and cats lick themselves: because they can." (Ken Rockwell)
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
