Hi, I have a view which uses in his definition a function stored in another schema (JASPA.ST_AsWKTSRS)
This is the view: CREATE VIEW spatial_ref_sys (srid, auth_name, auth_srid, srtext) as SELECT srid,'EPSG'::varchar as auth_name,srid, JASPA.ST_AsWKTSRS(srid) FROM JASPA._availableSRIDs; In the information schema H2 stores the schema about the table but it does not store the schema of the function ST_AsWKTSRS as you can see below: select * from INFORMATION_SCHEMA.VIEWS ; TABLE_CATALOG TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION CHECK_OPTION IS_UPDATABLE STATUS REMARKS ID JASPA21 PUBLIC SPATIAL_REF_SYS CREATE FORCE VIEW PUBLIC.SPATIAL_REF_SYS(SRID, AUTH_NAME, AUTH_SRID, SRTEXT) AS SELECT SRID, 'EPSG' AS AUTH_NAME, SRID, ST_ASWKTSRS(SRID) FROM JASPA._AVAILABLESRIDS /* JASPA._AVAILABLESRIDS.tableScan */ NONE NO VALID 429 As a result the view is not working. Could it be a bug? Thanks, Jose -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
