Forgot to tell you that Im using H2 1.2.136 so the schemas in functions are already supported. Cheers, Jose
On Jun 11, 4:17 pm, jomarlla <[email protected]> wrote: > 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.
