Re: LIBPQ Exception

On Dec 12, 2007 7:36 AM, Abraham, Danny <danny_abraham@bmc.com> wrote:
> Any other alternative?

There are no anonymous blocks in PostgreSQL:

You could try creating a function:

create or replace function
  shootmyselfinthefoot()
returns boolean as
$$
declare
  (...);
begin
  execute 'SOME DML HERE';
  execute 'SOME MORE DML HERE';
  execute 'ETC.';
  (...)
  exception when others then
    -- whatever...
end;
$$ language plpgsql;

... and call that from your C program.