Opened 10 years ago

Closed 10 years ago

Last modified 10 years ago

#3007 closed defect (fixed)

raster_columns shows up in geometry_columns list if postgis not installed in public

Reported by: robe Owned by: dustymugs
Priority: medium Milestone: PostGIS 2.1.8
Component: raster Version: 2.1.x
Keywords: history Cc:

Description

Just noticed this. I guess we resolved the issue with raster_columns being excluded from geometry_columns registry, but seems to be included if I install postgis in a schema like say "postgis".

Change History (7)

comment:1 by dustymugs, 10 years ago

Status: new → assigned

Heh. I never noticed that either given that I always install PostGIS in its own schema.

comment:2 by dustymugs, 10 years ago

I guess the only real solution is to exclude raster_columns regardless of schema in the definition with one extra check for the extent column.

comment:3 by pramsey, 10 years ago

Milestone: PostGIS 2.1.5 → PostGIS 2.1.6

comment:4 by pramsey, 10 years ago

Milestone: PostGIS 2.1.6 → PostGIS 2.1.7

comment:5 by robe, 10 years ago

Milestone: PostGIS 2.1.7 → PostGIS 2.1.8

comment:6 by robe, 10 years ago

BTW - r13446 (fix for #3092) should also fix this. I got rid of reference to public schema so now will ban any raster_columns named table regardless what schema it is in.

So I'll close this one out too once backport and close #3092

comment:7 by robe, 10 years ago

Keywords: history added
Resolution: → fixed
Status: assigned → closed

Committed at r13446 for 2.1 branch.

Version 0, edited 10 years ago by robe (next)
Note: See TracTickets for help on using tickets.