Re: pg.dropped - Mailing list pgsql-general

From Tom Lane
Subject Re: pg.dropped
Date
Msg-id 5490.1262962013@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:
> 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';

Mph.  That seems to be an unhandled case that we ought to handle.

            regards, tom lane

pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: Server name in psql prompt
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: dynamic insert in plpgsql