[fdo-users] transaction using fdo-postgis provider

[Brent Robinson]

Hi,

The PostGIS provider executes DDL statements on a different connection than it does for other statements, which would explain why an ApplySchema cannot be rolled back in an FDO Transaction.

I'm not exactly sure of the reason why but there might have been some situations where a connection gets blocked when a transaction including DDL statements stays open. It may have something to do with the data dictionary tables that a DDL statement updates. Currently, the provider does a commit before every DDL statement, with the following comment:

           // Commit all transactions before issuing a DDL statement; Otherwise the server may block if a transaction is open
            // and accessing a table that may be modified by the DDL statement.

A commit is done on both the DDL and non-DDL connection.

Brent.

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Jackie Ng
Sent: Tuesday, July 09, 2013 3:23 AM
To: fdo-users at lists.osgeo.org
Subject: Re: [fdo-users] transaction using fdo-postgis provider

This is where I'd say you should switch on trace logging for that provider
(http://themapguyde.blogspot.com.au/2013/01/mapguide-tidbits-fdo-rdbms-provider.html)
and see what kind of SQL is being executed and if it matches what you would normally execute through pgAdmin or any PostgreSQL client admin application.

- Jackie



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/transaction-using-fdo-postgis-provider-tp5064065p5064898.html
Sent from the FDO Users mailing list archive at Nabble.com.
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users