Re: BUG #6734: create table (like ...) fails if an index has a comment - Mailing list pgsql-bugs

daniele.varrazzo@gmail.com writes:
> CREATE TABLE foo
> (
>   id serial primary key,
>   f1 integer NOT NULL
> );

> CREATE INDEX foo_idx1 ON foo (f1);

> CREATE INDEX foo_idx2 ON foo (f1) WHERE id > 10;

> COMMENT ON INDEX foo_idx2 IS 'whatever';

> create table foo2 (like foo including all);

I've applied a fix for this in 9.2 and up.  The issue exists since
CREATE TABLE LIKE grew the ability to copy comments, in 9.0, but
it seems too risky to fix in already-released branches.

            regards, tom lane