[Geoserver-users] REST PostGIS upload shapefile with changed schema

Hi,

When reuploading a shapefile with a changed schema (additional attribute) to a postgis datastore like this:

/rest/workspaces/cite/datastores/postgis/file.shp?update=overwrite&charset=UTF-8

···

I receive a 201 created response, but the PostGIS table is not changed. The new attribute nor the additional records are added to the PostGIS table. The response suggests that the data has been changed in the PostGIS table.

This issue has been addressed earlier in the user email list, but I could not find anything else on it. Any suggestions or comments are more then welcome.

Thanks!


Anton Bakker, Software Engineer
www.geocat.net | anton.bakker@anonymised.com603…

Hi Anton,
while removeSchema has indeed been added to the GeoTools API,
I don’t believe it has been used in the REST API.
That seems to explain why what you’re trying to do does not work.

I believe the code would have to be modified here, dropping and re-creating
the schema, assuming source and target schema are not the same,
and the target store supports dropping to start with:
https://github.com/geoserver/geoserver/blob/master/src/restconfig/src/main/java/org/geoserver/catalog/rest/DataStoreFileResource.java#L368

Cheers
Andrea

···

On Fri, Feb 26, 2016 at 3:56 PM, Anton Bakker <anton.bakker@anonymised.com> wrote:

Hi,

When reuploading a shapefile with a changed schema (additional attribute) to a postgis datastore like this:

/rest/workspaces/cite/datastores/postgis/file.shp?update=overwrite&charset=UTF-8

I receive a 201 created response, but the PostGIS table is not changed. The new attribute nor the additional records are added to the PostGIS table. The response suggests that the data has been changed in the PostGIS table.

This issue has been addressed earlier in the user email list, but I could not find anything else on it. Any suggestions or comments are more then welcome.

Thanks!


Anton Bakker, Software Engineer
www.geocat.net | anton.bakker@anonymised.com


Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140


Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.

Ing. Andrea Aime

@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
phone: +39 0584 962313

fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

AVVERTENZE AI SENSI DEL D.Lgs. 196/2003

Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy’s New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.