2015-10-05 0:08 GMT+02:00 Marko Tiikkaja <ma...@joh.to>: > Hi, > > In the past I've found the error message in cases such as this somewhat > less helpful than it could be: > > =# CREATE TABLE qqq (a int); > =# CREATE UNIQUE INDEX IF NOT EXISTS qqq_a_idx ON qqq(a); > =# ALTER TABLE qqq ALTER COLUMN a TYPE json USING NULL; > ERROR: data type json has no default operator class for access method > "btree" > HINT: You must specify an operator class for the index or define a > default operator class for the data type. > > The attached patch adds a CONTEXT line to index and constraint rebuilds, > e.g: > > CONTEXT: while rebuilding index qqq_a_idx > > Any feedback welcome. >
I prefer using DETAIL field for this case. Regards Pavel > > .m > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > >