Re: [GENERAL] what happens to postmaster?

2010-06-23 Thread zach cruise
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? On Tue, Jun

Re: [GENERAL] what happens to postmaster?

2010-06-23 Thread Scott Marlowe
On Wed, Jun 23, 2010 at 12:42 PM, zach cruise zachc1...@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

[GENERAL] what happens to postmaster?

2010-06-22 Thread zach cruise
...when i am importing a table (from oracle, or updating it), and a user queries that same table? is it ok to be concerned about corruption etc. using 8.1. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] what happens to postmaster?

2010-06-22 Thread Dann Corbit
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of zach cruise Sent: Tuesday, June 22, 2010 11:09 AM To: pgsql-general@postgresql.org Subject: [GENERAL] what happens to postmaster? ...when i am importing a table

Re: [GENERAL] what happens to postmaster?

2010-06-22 Thread Bill Moran
In response to zach cruise zachc1...@gmail.com: ...when i am importing a table (from oracle, or updating it), and a user queries that same table? I depends on a lot of information you haven't provided ... Is the update inside a transaction? Have you locked the table? The real answer is: