[TinyOWS-users] RES: Tinyows - Postgis Schema support
vismari at ig.com.br
Mon Oct 25 07:35:02 EST 2010
Thank you for your reply.
- I'm using 0.9.
- Yes, the select query works well. Using Openlayers I can see the records
on the map through a WFS layer, but I could not update them. Before getting
this error everything was working fine, I could make select, update and
delete commands without problems, but when I moved the table from public
schema to other schema the update command stopped working. I though strange
because I put the schema name in the configuration file, so looked for more
further information in the Postgres log and I found the command that raised
the error. The error came up because there is no schema name before table
name in the update command, like this:
"Updade myTable set....."
I think you can make a simple test just moving some table from public schema
to other schema and do some transactions like update and delete.
I you need more information please let me know and thank you very much for
De: Olivier Courtin [mailto:olivier.courtin at gmail.com]
Enviada em: segunda-feira, 25 de outubro de 2010 05:22
Para: TinyOWS users discuss list; Marcelo
Assunto: Re: [TinyOWS-users] Tinyows - Postgis Schema support
On Oct 18, 2010, at 9:53 PM, Marcelo wrote:
> I am doing some tests with Tinyows and I could not make Updates on
> Postgres using a table from a different schema than "public". I put
> the schema tag in config.xml and I could display the records on the
> map but I could not update them. I read the error message from
> Postgres and I found out that Tinyows didn't put the schema name
> before table name, it put just:
Sorry for the delay,
What is the Tinyows version you use ?
Is a SELECT query (GetFeature) work well on the same layer ?
More information about the TinyOWS-users