On Thu, May 12, 2011 at 12:11 PM, Simon Payne
<[email protected]> wrote:
> Hi Andrea,
>
> I have got this to work, using GeoServer 2.1.RC5. I explicitly included the
> gt_pk_metadata_table, qualified by its schema name, in the primary key
> metadata table field and then reloaded the configuration. If I left the
> field blank, it didn't work. If I had the name of the table but no schema
> name qualifying it, likewise it didn't work. Hence it had to be in this
> format:
>
> MY_SCHEMA_NAME.GT_PK_METADATA_TABLE
>
> It also worked like this when I gave the metadata table a different name,
> provided I had it fully qualified in the field.
>
> Given that leaving the field blank didn't work, is this a bug, or is it
> expected behaviour (in which case the docs need clarifying)?
As far as I remember if you don't specify the schema the store will
look for the table
in the schema you specified for the store. Some databases have a
default one that
gets used if you don't specify one (e.g., "public" in postgresql).
So for example in postgresql the following query gets run by default
to get info out
of the metadata table:
select * from public.GT_PK_METADATA_TABLE
where table_schema = '...' and
table_name = '...'
order by pk_column_idx ASC
Hope this helps
Cheers
Andrea
--
-------------------------------------------------------
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
-------------------------------------------------------
------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
