Tersus: Re: Query no PostgreSQL (create or replace view)

Re: Query no PostgreSQL (create or replace view)Date: Jul 16, 2012I don't thing this is a PostgreSQL-specific issue.I see from the error that you're trying to use a Database Query plugin to make changes to the database, which is by definition something which cannot succeed - queries cannot change the state of the database.Changing the database should work using the Database Update plugin.
In your case, where it seems you're trying to execute multiple sql statements together, you can try the SQL Batch plugin.
Note that transaction-wise, the same can be achieved using multiple update and query statement running in succession in the same Service - basically, a server-side call automatically creates a transaction and rolls it back if an error occurs.Regards,DavidSee Also:

To use the full functionality of this web site, JavaScript needs to be turned on.

For best results, use the Firefox browser..

Loading ...