Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am using Geoserver + GeoWebCache + Postgres for an application. On the application side there is no bugs but on postgres I am getting this log. Please explain and help me to solve this

2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA 2014-03-14 10:14:50 IST ERROR: relation "public.gt_pk_metadata" does not exist at character 15 2014-03-14 10:14:50 IST STATEMENT: SELECT * FROM public.GT_PK_METADATA

share|improve this question

2 Answers 2

up vote 2 down vote accepted

Table or view named GT_PK_METADA in public shema does not exists in your database. Postgresql uses lower cases by default. So if you have GT_PK_METADATA in your database your query should be SELECT * FROM public."GT_PK_METADATA"

share|improve this answer

The table gt_pk_metadata is an optional table that GeoTools (and GeoServer) use to work out what the primary key columns in a view are. It is needed to generate consistent feature IDs (FIDS) otherwise GeoTools will use the feature's java ID which will change from run to run.

It is explained in this document. So you can ignore this error if you don't care about consistent feature IDs (FIDS) across server restarts.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.