On Wed, Mar 11, 2009 at 8:01 AM, Woody Woodring <george.woodring@xxxxxxxxxx> wrote: > I have a table that users can update if the data is old. Once a day I > update every entry in the table. However I get primary key violations > occasionally which it seems a user inserted into the table while the bulk > insert is going on. Yeah, you need to first deny access rights to all users that aren't the one doing the loading, then kick off all the users that are already connected. To remove the rights of anyone else to connect, the easiest way is to edit pg_hba.conf / have a special pg_hba.conf to copy into place, then reload the db. After that, from a shell script or something, you need to kill the backends that are still connected. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
