[SQL] Serialized Transaction Locking Issues

2003-02-06 Thread Jasper Tymesman
Hello, I'm currently in the midst of working on a serializable transaction which drops indexes on several tables, does a bulk copy, and rebuilds the indexes. Based on what I've read it seemed as though I'd be able to concurrently execute read on queries against these tables, returning results

Re: [SQL] Serialized Transaction Locking Issues

2003-02-04 Thread Tom Lane
justin <[EMAIL PROTECTED]> writes: > I'm currently in the midst of working on a serializable transaction > which drops indexes on several tables, does a bulk copy, and rebuilds > the indexes. Based on what I've read it seemed as though I'd be able to > concurrently execute read only queries agai

[SQL] Serialized Transaction Locking Issues

2003-02-04 Thread justin
Hello, I'm currently in the midst of working on a serializable transaction which drops indexes on several tables, does a bulk copy, and rebuilds the indexes. Based on what I've read it seemed as though I'd be able to concurrently execute read only queries against these tables, returning result