Re: [PERFORM] Regarding ALTER Command

2006-06-08 Thread Tom Lane
"soni de" <[EMAIL PROTECTED]> writes: > One more thing I have to mention is that we are using 2 postmasters running > on different machines and both are accessing same data directory. (i.e both > the machines uses same tables or the databases) The above is guaranteed NOT to work. I'm surprised yo

Re: [PERFORM] Regarding ALTER Command

2006-06-07 Thread soni de
Hello,   We are planning to use latest postgres version. I have one query as below:   One more thing I have to mention is that we are using 2 postmasters running on different machines and both are accessing same data directory. ( i.e both the machines uses same tables or the databases) In that case

Re: [PERFORM] Regarding ALTER Command

2006-06-07 Thread Jim C. Nasby
On Wed, Jun 07, 2006 at 06:13:11PM +0530, soni de wrote: > Hello, > > > > We have database on which continueous operations of INSERT, DELETE, UPDATE > are going on, In the mean time irrespective of INSERT and UPDATE we want to > ALTER some filelds from the table can we do that? > > Would the AL