On Wed, Jun 23, 2010 at 12:42 PM, zach cruise <zachc1980@gmail.com> 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.