Re: pg.dropped - Mailing list pgsql-general

From Tom Lane
Subject Re: pg.dropped
Date
Msg-id 1832.1263223952@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg.dropped  (Filip Rembiałkowski <plk.zuber@gmail.com>)
List pgsql-general
=?UTF-8?Q?Filip_Rembia=C5=82kowski?= <plk.zuber@gmail.com> writes:
> Full test case, reproduced in 8.4.2 on two different hosts

> create table test (id serial primary key, t1 text, t2 text);
> create function myhash(test) returns text as 'select md5($1::text)' language
> sql immutable;
> create index myhash on test( myhash(test) );
> alter table test add t3 text;
> alter table test drop t3;
> insert into test(t1,t2) select 'foo', 'bar';

I've applied a patch for this in HEAD and 8.4.

            regards, tom lane

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Composite types questions
Next
From: Vincenzo Romano
Date:
Subject: Re: Composite types questions