[postgis-devel] shp2pgsql transactions

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Wed Oct 21 08:03:28 PDT 2009


Michael Orlitzky wrote:

> I see that the shp2pgsql utility is adding END/BEGIN transaction 
> delimiters once for every 250 INSERT statements.

Yeah; I'm not a fan of this since generally you either want everything 
in a transaction or you don't. I'd like to propose just adding a single 
transaction block around the whole file, which people can then strip off 
really easily if they don't want it.


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs



More information about the postgis-devel mailing list