Opened 7 years ago

Closed 6 years ago

Last modified 6 years ago

#2222 closed enhancement (fixed)

[raster] Add ability to change behavior of WKB output for out-db bands

Reported by: Bborie Park Owned by: Bborie Park
Priority: medium Milestone: PostGIS 2.1.0
Component: raster Version: trunk
Keywords: history Cc: mateusz@…

Description (last modified by Bborie Park)

Version 1 is intended to correct the handling of out-db raster bands. In Version 0, the output of ST_AsBinary() for a band with out-db values returns the path to the out of database raster file, which is generally useless for a client unless the client has access to the database server's file system.

By using Version 1, we don't break compatibility for those already using Version 0 WKB.

Related ticket regarding ST_AsBinary() is #2217.

Attachments (1)

RFC3-WellKnownBinaryFormat-v1 (6.5 KB) - added by Bborie Park 7 years ago.
Proposed spec for raster WKB v1

Download all attachments as: .zip

Change History (8)

Changed 7 years ago by Bborie Park

Proposed spec for raster WKB v1

comment:1 Changed 7 years ago by mloskot

Cc: mateusz@… added

comment:2 Changed 7 years ago by Bborie Park

Status: newassigned

After some additional thinking and discussion, the current thought is NOT to create a new version and cause lots of waves (and probably a whole slew of bugs) but to continue using the current WKB format as is. Instead, we will allow end users to specify that they want out-db bands to be treated as in-db. By default, the current behavior where out-db bands return the path to the external file will continue. But if the user says to tread out-db as in-db, the behavior will change so that the appropriate data contained in the external file will be returned.

comment:3 Changed 7 years ago by mloskot

allow end users to specify that they want out-db bands to be treated as in-db

How that will be realise? What steps at user-end will be required?

comment:4 in reply to:  3 Changed 7 years ago by Bborie Park

Replying to mloskot:

allow end users to specify that they want out-db bands to be treated as in-db

How that will be realise? What steps at user-end will be required?

ST_AsBinary(rast raster, OutAsIn boolean DEFAULT FALSE)

For remote clients, OutAsIn? should be TRUE so that out-db bands are treated as in-db.

comment:5 Changed 7 years ago by Bborie Park

Description: modified (diff)
Summary: [raster] WKB format version 1[raster] Add ability to change behavior of WKB output for out-db bands

comment:6 Changed 6 years ago by Bborie Park

Keywords: history added
Resolution: fixed
Status: assignedclosed

Done as of r11320.

comment:7 Changed 6 years ago by mloskot

@dustymugs Thanks very much for fixing this.

Note: See TracTickets for help on using tickets.