Re: Index trouble with 8.3b4 - Mailing list pgsql-hackers

From Hannes Dorbath
Subject Re: Index trouble with 8.3b4
Date
Msg-id fmdqck$23ui$3@news.hub.org
Whole thread Raw
In response to Re: Index trouble with 8.3b4  (Hannes Dorbath <light@theendofthetunnel.de>)
Responses Re: Index trouble with 8.3b4  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Hannes Dorbath
Date:
Subject: Re: Index trouble with 8.3b4
Next
From: "Sean Utt"
Date:
Subject: Re: Postgresql Materialized views