On Wed, Jun 23, 2010 at 12:42 PM, zach cruise <zachc1980@xxxxxxxxx> wrote: > using navicat 8's import wizard which does row inserts > (provider=msdaora.1; persist security info=true). more > http://www.navicat.com/manual/online_manual/win_manual/ImportODBC.html > > i know this is not navicat support, but can anyone from navicat > support also try answer this question? >> Some documentation to read up on: >> http://www.postgresql.org/docs/8.4/static/explicit-locking.html >> >>> is it ok to be concerned about corruption etc. >> As long as the import process is going through a regular postgresql backend connection, and not trying to write directly to the database files, you should have nothing ot worry about as far as corruption goes. Now pg_bulkloader, that's another story. There you shut down the database and let the bulk loader do its magical, dangerous stuff. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general