Dear all !
I have a postgis database and tables which schema is not public. I’ve configured the datastore with success. When I try to create a new entity, it lists me all the tables but when I select one a click “New” (I have a French version so I hope the button’s label is what I wrote!) it tells me : “SQL Error building feature type my_table ; relation “my_table” does not exists”. One the one hand I think it doesn’t care about the schema because it would have tell “my_schema.my_table” and on the other hand it lists me all the table which are in my schema…
I hope you could help me!
Thanks!
Best regards,
P N’imprimez ce message que si vous en avez l’utilité …
Virginie BERRE ha scritto:
Dear all !
I have a postgis database and tables which schema is not public. I’ve configured the datastore with success. When I try to create a new entity, it lists me all the tables but when I select one a click “New” (I have a French version so I hope the button’s label is what I wrote!) it tells me : “SQL Error building feature type my_table ; relation “my_table” does not exists”. One the one hand I think it doesn’t care about the schema because it would have tell “my_schema.my_table” and on the other hand it lists me all the table which are in my schema…
It defaults to reporting only the tables in the public schema, unless you specify one.
Unfortunately I don't know what's the issue, can you send me the
Geoserver logs by private mail? There I may find a stack trace,
which may inform me about the issue.
Also, can you dump the database structure for me?
If you use the command line psql tool, once logged in, you can get
it using "\d tablename".
Cheers
Andrea Aime
I suppose when u talk about "new entity" you mean new feature. If is like this, I have a same situation in my postGIS but it works perfectly!
I am using geoserver1.5beta2, I hope my experience can help.
bye Antonello
Andrea Aime wrote:
Virginie BERRE ha scritto:
Dear all !
I have a postgis database and tables which schema is not public. I’ve configured the datastore with success. When I try to create a new entity, it lists me all the tables but when I select one a click “New” (I have a French version so I hope the button’s label is what I wrote!) it tells me : “SQL Error building feature type my_table ; relation “my_table” does not exists”. One the one hand I think it doesn’t care about the schema because it would have tell “my_schema.my_table” and on the other hand it lists me all the table which are in my schema…
It defaults to reporting only the tables in the public schema, unless you specify one.
Unfortunately I don't know what's the issue, can you send me the
Geoserver logs by private mail? There I may find a stack trace,
which may inform me about the issue.
Also, can you dump the database structure for me?
If you use the command line psql tool, once logged in, you can get
it using "\d tablename".
Cheers
Andrea Aime
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
