Re: [GENERAL] Basic question on PGSQL and Transactions

2010-09-29 Thread Alban Hertroys
On 29 Sep 2010, at 18:31, Henri De Feraudy wrote: > I mean, if you are inserting into a table from PLPGSQL do you have to do an > explicit commit at some stage? I suppose you meant psql here, as otherwise the above statement wouldn't make sense ;) Alban Hertroys -- Screwing up is an excellent

Re: [GENERAL] Basic question on PGSQL and Transactions

2010-09-29 Thread Merlin Moncure
On Wed, Sep 29, 2010 at 12:38 PM, Andy Colson wrote: > On 9/29/2010 11:31 AM, Henri De Feraudy wrote: >> >> Hello, >> I've been writing an application that allows me to edit simple maps. It >> involves Postgis but here I think I have run into >> a basic Postgres consideration. >> I did a bit of ed

Re: [GENERAL] Basic question on PGSQL and Transactions

2010-09-29 Thread Andy Colson
On 9/29/2010 11:31 AM, Henri De Feraudy wrote: Hello, I've been writing an application that allows me to edit simple maps. It involves Postgis but here I think I have run into a basic Postgres consideration. I did a bit of editing of a map which involved creating a polygon with a selection, inser

[GENERAL] Basic question on PGSQL and Transactions

2010-09-29 Thread Henri De Feraudy
Hello, I've been writing an application that allows me to edit simple maps. It involves Postgis but here I think I have run into a basic Postgres consideration. I did a bit of editing of a map which involved creating a polygon with a selection, inserting into a database and reloading the "lay