<div dir="ltr"><div>ok, it's supported according to <a href="http://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_Analysis">http://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_Analysis</a><br>

<br></div>but I maybe the FDO provider doesn't support it<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Jul 9, 2013 at 4:39 PM, taiyabali <span dir="ltr"><<a href="mailto:rjpillai@tatapowersed.com" target="_blank">rjpillai@tatapowersed.com</a>></span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Ok then does that mean we cannot have DDL in transaction. But when we write<br>
create SQL in a transaction block it works. Are you sure about that because<br>
i think transactions should work for DDL and DML both.<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/transaction-using-fdo-postgis-provider-tp5064065p5064883.html" target="_blank">http://osgeo-org.1560.x6.nabble.com/transaction-using-fdo-postgis-provider-tp5064065p5064883.html</a><br>


<div class="HOEnZb"><div class="h5">Sent from the FDO Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
fdo-users mailing list<br>
<a href="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/fdo-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr">Zac Spitzer<br>+61 405 847 168<br><br></div>
</div>