Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group