Re: ALTER TABLE behind-the-scenes effects' CONTEXT

2015-10-05 0:08 GMT+02:00 Marko Tiikkaja <marko(at)joh(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
>