Opened 6 years ago

Closed 6 years ago

Last modified 5 years ago

#1216 closed enhancement (fixed)

[raster] Make raster_columns a view

Reported by: pracine Owned by: pramsey
Priority: low Milestone: PostGIS 2.0.0
Component: postgis Version: trunk
Keywords: Cc: mateusz@…


What do we need to make raster_column a view?

Isn't there a limitations on the quantity of info typmod can take?

Change History (7)

comment:1 Changed 6 years ago by mloskot

Cc: mateusz@… added

comment:2 Changed 6 years ago by robe

Yah there is so I don't think we can ever make it a view if we want all that information.

comment:3 Changed 6 years ago by pracine

That's the point. We might want to get rid of some of this info but we need to know what are the constraint first. What is the limit on the quantity of info we can keep? Browsing the doc I see that "this information must be capable of being packed into a single non-negative integer value for storage in the system catalogs". Does this mean we have to fit everything which is not r_table_catalog, r_table_schema, r_table_name and r_column into a 32bit int? This is kind of very limitative...

comment:4 Changed 6 years ago by robe

yes that is why I quickly dismissed it for raster. The fact you can have an undefined number of bands kind of screws you already. Maybe in the future they will make it more expansive then you can revisit.

comment:5 Changed 6 years ago by robe

Resolution: fixed
Status: newclosed

this is done already and I think it might be a duplicate ticket too.

comment:6 Changed 5 years ago by mloskot

Summary: [raster] Make raster_column a view[raster] Make raster_columns a view

archive yanitor

comment:7 Changed 5 years ago by mloskot

(archive janitor)

Related/dup ticket #1319

Note: See TracTickets for help on using tickets.