error after dropping column
От | Filip Rembiałkowski |
---|---|
Тема | error after dropping column |
Дата | |
Msg-id | 92869e661001110627g3692ef9aib9c71343d6b73baa@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: error after dropping column
|
Список | pgsql-bugs |
Hi all,<br /><br />not sure if I should send it here; if it was reported before in pgsql-general. you can just ignore it:-)<br /><br />with postgres 8.2.4:<br /><br />create table test (t1 text);<br />create function row2text(test) returnstext as 'select $1::text' language sql immutable;<br /> create index test_row2text_idx on test( row2text(test) );<br/> alter table test add t2 text;<br />alter table test drop t2;<br />insert into test(t1) select 'foo';<br /><br />ERROR: table row type and query-specified row type do not match<br />DETAIL: Physical storage mismatch on dropped attributeat ordinal position 2.<br /><br /><br clear="all" /><br />-- <br />Filip Rembiałkowski<br />JID,mailto:<a href="mailto:filip.rembialkowski@gmail.com"target="_blank">filip.rembialkowski@gmail.com</a><br /><a href="http://filip.rembialkowski.net/"target="_blank">http://filip.rembialkowski.net/</a><br />
В списке pgsql-bugs по дате отправления: