Permission errors on insert after schema drop/create (Pg 9.0.23)
Figured out a workaround that involved just deleting tables (and sequences) rather than dropping the schema. Leaving here in case it helps anyone else.

Changed the first few lines:

BEGIN;
drop schema if exists genome3d_data_daily CASCADE;
create schema genome3d_data_daily AUTHORIZATION genome3ddaily;


...to...

BEGIN;
create schema genome3d_data_daily AUTHORIZATION genome3ddaily;
END;

BEGIN;
drop table if exists genome3d_data_daily.annotation_type;
drop table if exists genome3d_data_daily.annotation_segment;
drop table if exists genome3d_data_daily.annotation;
drop sequence if exists genome3d_data_daily.annotation_id_seq;


This no longer disrupts existing database connections.