Hi, I try to stick with OGC Simple Feature Access using their unit test called Conformance Test. Regarding theses test I should create and/or update some tables when a table contain a geometry column. Creation of table must not be different of this one :
CREATE TABLE lakes ( > > fid INTEGER NOT NULL PRIMARY KEY, > > name CHARACTER VARYING(64), > > shore POLYGON); > Then a table *geometry_columns* should be created/updated automatically by referencing the column in the *lakes* table here. There is a way to register a listener on h2 in order to get a call-back when someone call "CREATE TABLE" and "ALTER TABLE", or when a domain is used ? -Nicolas Le vendredi 26 avril 2013 07:13:59 UTC+2, Thomas Mueller a écrit : > > Hi, > > You currently can't as the domain name is not stored. > > What you could do as a workaround is add a comment on the column, as you > can retrieve that, in the column metadata (information_schema.columns). Or, > as an alternative, add a "fake" column constraint on the domain. The column > constraint is propagated to the column, and can be read as well. > > Regards, > Thomas > > > On Thu, Apr 25, 2013 at 9:20 AM, Nicolas Fortin (OrbisGIS) < > [email protected] <javascript:>> wrote: > >> Hi, >> >> When I use CREATE DOMAIN and use this domain when creating the table, >> using ResultSetMetaData.getColumnTypeName I don't get the domain name but >> the OTHER (if I use create domain geometry as JAVA_OBJECT). How can I >> retrieve the domain name of my column ? >> >> Thx >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> Visit this group at http://groups.google.com/group/h2-database?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
