I apologize because I just read now other people reported the same issue. Sorry Jose
On Jun 11, 4:19 pm, jomarlla <[email protected]> wrote: > 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.
