[Geoserver-users] How do I delete an SQL view?

[N L]

Hello!

I've made a lot of SQL views during my tests of geoserver and now I can't
find where to delete them.
They are all visible in New Layer window and that's so confusing.
How do I clean this list?
Thanks.

Nick

[Rahkonen Jukka]

Hi,

The list shows you the candidate tables and layers which are available from the database. Dropping the unnecessary views from the database will help.

-Jukka Rahkonen-


________________________________

Lähettäjä: N L [mailto:***@gmail.com]
Lähetetty: 17. maaliskuuta 2011 16:12
Vastaanottaja: geoserver-***@lists.sourceforge.net
Aihe: [Geoserver-users] How do I delete an SQL view?


Hello!

I've made a lot of SQL views during my tests of geoserver and now I can't find where to delete them.
They are all visible in New Layer window and that's so confusing.
How do I clean this list?
Thanks.

Nick

[N L]

Hello!

I don't have this views in my PostGIS database.
It seems to me they're generated outside the database.
And I can't figure out where. That's the problem.

Nick


On Thu, Mar 17, 2011 at 5:19 PM, Rahkonen Jukka

Post by Rahkonen Jukka
Hi,
The list shows you the candidate tables and layers which are available from
the database. Dropping the unnecessary views from the database will help.
-Jukka Rahkonen-
------------------------------
*Lähetetty:* 17. maaliskuuta 2011 16:12
*Aihe:* [Geoserver-users] How do I delete an SQL view?
Hello!
I've made a lot of SQL views during my tests of geoserver and now I can't
find where to delete them.
They are all visible in New Layer window and that's so confusing.
How do I clean this list?
Thanks.
Nick

[Rahkonen Jukka]

Hi,

Sorry, sent the message just before I understood you have been playing with the new "layer from SQL query" feature. I have never tried them myself yet and thus can't give any advice.

-Jukka-




________________________________

Lähettäjä: N L [mailto:***@gmail.com]
Lähetetty: 17. maaliskuuta 2011 16:29
Vastaanottaja: Rahkonen Jukka
Aihe: Re: [Geoserver-users] How do I delete an SQL view?


Hello!

I don't have this views in my PostGIS database.
It seems to me they're generated outside the database.
And I can't figure out where. That's the problem.

Nick


On Thu, Mar 17, 2011 at 5:19 PM, Rahkonen Jukka <***@mmmtike.fi> wrote:


Hi,

The list shows you the candidate tables and layers which are available from the database. Dropping the unnecessary views from the database will help.

-Jukka Rahkonen-


________________________________

Lähettäjä: N L [mailto:***@gmail.com]
Lähetetty: 17. maaliskuuta 2011 16:12
Vastaanottaja: geoserver-***@lists.sourceforge.net
Aihe: [Geoserver-users] How do I delete an SQL view?


Hello!

I've made a lot of SQL views during my tests of geoserver and now I can't find where to delete them.
They are all visible in New Layer window and that's so confusing.
How do I clean this list?
Thanks.

Nick

[Ivan PRICE]

do you mean delete the view or delete the layers in geoserver ?

to delete a view you can goto the SQL prompt of the database and do
something like 'drop view xxx'

to delete layers in geoserver use the web admin or if theres a huge
number make a batch of delete statements to execute via the REST api

curl -u admin:password -v -XDELETE -H 'Accept: text/xml'
http://localhost:8080/geoserver/rest/layers/<layername>.xml

-i

Post by N L
Hello!
I've made a lot of SQL views during my tests of geoserver and now I
can't find where to delete them.
They are all visible in New Layer window and that's so confusing.
How do I clean this list?
Thanks.
Nick
------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
Geoserver-users mailing list
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[N L]

No, I mean I've made a lot of layers through "Create new SQL view" geoserver
feature.
And now they're all in my layer list.
And I don't see them here http://localhost:8080/geoserver/rest/layers/, also
can't find them neither in postgis database, nor in my filesystem.

---------

do you mean delete the view or delete the layers in geoserver ?

to delete a view you can goto the SQL prompt of the database and do
something like 'drop view xxx'

to delete layers in geoserver use the web admin or if theres a huge
number make a batch of delete statements to execute via the REST api

curl -u admin:password -v -XDELETE -H 'Accept: text/xml'
http://localhost:8080/geoserver/rest/layers/<
layername>.xml

-i

Post by N L
Hello!
I've made a lot of SQL views during my tests of geoserver and now I
can't find where to delete them.
They are all visible in New Layer window and that's so confusing.
How do I clean this list?
Thanks.
Nick

[c***@nvoe.at]

Post by N L
No, I mean I've made a lot of layers through "Create new SQL view" geoserver
feature.
And now they're all in my layer list.
And I don't see them here http://localhost:8080/geoserver/rest/layers/, also
can't find them neither in postgis database, nor in my filesystem.
---------
do you mean delete the view or delete the layers in geoserver ?
to delete a view you can goto the SQL prompt of the database and do
something like 'drop view xxx'
to delete layers in geoserver use the web admin or if theres a huge

Have you searched under

GEOSERVER_DATA_DIR/workspaces/<yourworkspace>/

I assume you will find the xml config for the views there.

Post by N L
number make a batch of delete statements to execute via the REST api
curl -u admin:password -v -XDELETE -H 'Accept: text/xml'
http://localhost:8080/geoserver/rest/layers/<
layername>.xml
-i

Post by N L
Hello!
I've made a lot of SQL views during my tests of geoserver and now I
can't find where to delete them.
They are all visible in New Layer window and that's so confusing.
How do I clean this list?
Thanks.
Nick

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.