Tom Lane wrote: > Greg Stark <[EMAIL PROTECTED]> writes: > > Sorry to followup to my own message, but it occurs to me that COPY could be > > made to automatically do this for the case of an empty destination table > > too. > > Not unless you are proposing to change COPY to acquire a lock strong > enough to lock out other writers to the table for the duration ...
Well, if the table is initally empty, what harm is there in locking the table? How many people query the table while it is being loaded, and because the transaction isn't committed, the table is empty to everyone else anyway. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
