Skip to content

Instantly share code, notes, and snippets.

@gbb
gbb / 2485_workaround.txt
Created July 31, 2014 13:36
Workaround for postgis bug #2485 (often noticed as ST_BandMetaData error during pg_dump)
- - PSQL script - - run as postgres - -
drop table if exists bug2485move;
drop sequence if exists bug2485move_seq;
create sequence bug2485move_seq;
select r_table_schema as schema, r_table_name as name, 'bug2485___'||nextval('bug2485move_seq')::text as bug2485move into public.bug2485move from raster_columns;