[postgis-users] NOTICE: compute_serialized_box3d called on unknown type 0

[Pierre Racine]

What if you do this instead?

SELECT rid, Box2D(rast::geometry) As rastbox
FROM dummy_rast;


> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of uyen dang
> Sent: Sunday, October 09, 2011 7:31 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] NOTICE: compute_serialized_box3d called on unknown
> type 0
> 
> Hello,
> 
> 
> I'm a new  postgis-user and i have a postgis raster project for a moment. I
> installed postgres-8.4, postgis-2.0, gdal driver, geos-3.2,  proj-4.6 in ubuntu. But
> when i use the raster table of dummy rasters formed from the site :
>     http://postgis.refractions.net/documentation/manual-svn/RT_reference.html
> <http://postgis.refractions.net/documentation/manual-svn/RT_reference.html>
> 
> 
>     CREATE TABLE dummy_rast(rid integer, rast raster);
>     INSERT INTO dummy_rast(rid, rast)
>     VALUES (1,
>     ('01' -- little endian (uint8 ndr)
>     ||
>     '0000' -- version (uint16 0)
>     ||
>     '0000' -- nBands (uint16 0)
>     ||
>     '0000000000000040' -- scaleX (float64 2)
>     ||
>     '0000000000000840' -- scaleY (float64 3)
>     ||
>     '000000000000E03F' -- ipX (float64 0.5)
>     ||
>     '000000000000E03F' -- ipY (float64 0.5)
>     ||
>     '0000000000000000' -- skewX (float64 0)
>     ||
> 
> - Ignored:
>     '0000000000000000' -- skewY (float64 0)
>     ||
>     '00000000' -- SRID (int32 0)
>     ||
>     '0A00' -- width (uint16 10)
>     ||
>     '1400' -- height (uint16 20)
>     )::raster
>     ),
>     -- Raster: 5 x 5 pixels, 3 bands, PT_8BUI pixel type, NODATA = 0
>     (2,  ('01000003009A9999999999A93F9A9999999999A9BF000000E02B274A' ||
> 
> '41000000007719564100000000000000000000000000000000FFFFFFFF0500050
> 00400FDFEFDFEFEFDFEFEFDF9FAFEF' ||
> 
> 'EFCF9FBFDFEFEFDFCFAFEFEFE04004E627AADD16076B4F9FE6370A9F5FE59637
> AB0E54F58617087040046566487A1506CA2E3FA5A6CAFFBFE4D566DA4CB3E454
> C5665')::raster);
> 
>     and then i run this command :
> 
>     SELECT rid, Box2D(rast) As rastbox
>     FROM dummy_rast;
> 
>     i get NOTICE and no result :
> 
>     NOTICE:  compute_serialized_box3d called on unknown type 0
>     NOTICE:  compute_serialized_box3d called on unknown type 0
>     rid | rastbox
>     -----+---------
>     1 |
>     2 |
>     (2 rows)
> 
>     Can you help me to find out what's going wrong here ?
> 
>     Thanks in advance,
>     Dang Uyen.
> 
> - Done.
> 
> 
> Hello,
> I'm a new postgis-user and i have a postgis raster project for a moment. I
> installed postgres-8.4, postgis-2.0, gdal driver, geos-3.2, proj-4.6 in ubuntu. But
> when i use the raster table of dummy rasters formed from the site :
> 
> http://postgis.refractions.net/documentation/manual-svn/RT_reference.html
> 
> 
> CREATE TABLE dummy_rast(rid integer, rast raster); INSERT INTO
> dummy_rast(rid, rast) VALUES (1, ('01' -- little endian (uint8 ndr)
> ||
> '0000' -- version (uint16 0)
> ||
> '0000' -- nBands (uint16 0)
> ||
> '0000000000000040' -- scaleX (float64 2)
> ||
> '0000000000000840' -- scaleY (float64 3)
> ||
> '000000000000E03F' -- ipX (float64 0.5)
> ||
> '000000000000E03F' -- ipY (float64 0.5)
> ||
> '0000000000000000' -- skewX (float64 0)
> ||
> '0000000000000000' -- skewY (float64 0)
> ||
> '00000000' -- SRID (int32 0)
> ||
> '0A00' -- width (uint16 10)
> ||
> '1400' -- height (uint16 20)
> )::raster
> ),
> -- Raster: 5 x 5 pixels, 3 bands, PT_8BUI pixel type, NODATA = 0 (2,
> ('01000003009A9999999999A93F9A9999999999A9BF000000E02B274A' ||
> '41000000007719564100000000000000000000000000000000FFFFFFFF0500050
> 00400FDFEFDFEFEFDFEFEFDF9FAFEF' ||
> 'EFCF9FBFDFEFEFDFCFAFEFEFE04004E627AADD16076B4F9FE6370A9F5FE59637
> AB0E54F58617087040046566487A1506CA2E3FA5A6CAFFBFE4D566DA4CB3E454
> C5665')::raster);
> 
> and then i run this command :
> 
> SELECT rid, Box2D(rast) As rastbox
> FROM dummy_rast;
> 
> i get NOTICE and no result :
> 
> NOTICE: compute_serialized_box3d called on unknown type 0
> NOTICE: compute_serialized_box3d called on unknown type 0 rid | rastbox
> -----+---------
> 1 |
> 2 |
> (2 rows)
> 
> Can you help me to find out what's going wrong here ?
> 
> Thanks in advance,
> Dang Uyen.