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

[uyen dang]

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)
    ||

- 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' ||
    '41000000007719564100000000000000000000000000000000FFFFFFFF050005000400FDFEFDFEFEFDFEFEFDF9FAFEF' ||
    'EFCF9FBFDFEFEFDFCFAFEFEFE04004E627AADD16076B4F9FE6370A9F5FE59637AB0E54F58617087040046566487A1506CA2E3FA5A6CAFFBFE4D566DA4CB3E454C5665')::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' ||
'41000000007719564100000000000000000000000000000000FFFFFFFF050005000400FDFEFDFEFEFDFEFEFDF9FAFEF' ||
'EFCF9FBFDFEFEFDFCFAFEFEFE04004E627AADD16076B4F9FE6370A9F5FE59637AB0E54F58617087040046566487A1506CA2E3FA5A6CAFFBFE4D566DA4CB3E454C5665')::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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111009/729a40c3/attachment.html>