On 3/21/07, Merlin Moncure <[EMAIL PROTECTED]> wrote:

On 3/21/07, Pavan Deolasee <[EMAIL PROTECTED]> wrote:
> It seems much simpler to me do something like this. But important
> question is whether the restriction that CREATE INDEX can not
> be run in a transaction block is acceptable ?

yikes -- this is huge, huge price to pay, IMHO.  Think about DDL that
implies index creation such as adding unique constraint to a table,
many postgresql users (including me) take advantage of that in update
systems to production databases.

I didn't understand that quite well. How does it help to run CREATE
INDEX inside a transaction ?



EnterpriseDB     http://www.enterprisedb.com

Reply via email to