Re: BUG #6734: create table (like ...) fails if an index has a comment

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: daniele(dot)varrazzo(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6734: create table (like ...) fails if an index has a comment
Date: 2012-07-16 17:27:41
Message-ID: 13615.1342459661@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

daniele(dot)varrazzo(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Mike Wilson 2012-07-16 17:58:11 Re: BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)
Previous Message Noah Misch 2012-07-16 16:53:53 Re: Re: BUG #6712: PostgreSQL 9.2 beta2: alter table drop constraint does not work on inherited master table