Re: Index trouble with 8.3b4

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Index trouble with 8.3b4
Date: 2008-01-13 19:55:59
Message-ID: fmdqck$23ui$3@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hannes Dorbath wrote:
> ERROR: relation "ts_test_tsv" already exists
> test=# drop INDEX ts_test_tsv ;
> DROP INDEX

This is a general thing I'd like to ask. If the creation of an index
fails, why is it nevertheless there? No matter if deadlock or my GIN
error, why isn't the whole operation "rolled back"? And what state is it
it leaves me on? Do I end up with a corrupt index on my table?

--
Best regards,
Hannes Dorbath

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-01-13 20:54:50 Re: Index trouble with 8.3b4
Previous Message Hannes Dorbath 2008-01-13 19:48:29 Re: Index trouble with 8.3b4

Browse pgsql-hackers by date

  From Date Subject
Next Message Sean Utt 2008-01-13 20:41:40 Re: Postgresql Materialized views
Previous Message Hannes Dorbath 2008-01-13 19:48:29 Re: Index trouble with 8.3b4