[TinyOWS-users] RES: Tinyows - Postgis Schema support

[Marcelo]

Hello Olivier,

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
your help.

Best regards,
Marcelo Vismari


-----Mensagem original-----
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:

Hi Marcelo,

> 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 ?

--
Olivier