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

error after dropping column

From: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: error after dropping column
Date: 2010-01-11 14:27:15
Message-ID: 92869e661001110627g3692ef9aib9c71343d6b73baa@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi all,

not sure if I should send it here; if it was reported before in
pgsql-general. you can just ignore it :-)

with postgres 8.2.4:

create table test (t1 text);
create function row2text(test) returns text as 'select $1::text' language
sql immutable;
create index test_row2text_idx on test( row2text(test) );
alter table test add t2 text;
alter table test drop t2;
insert into test(t1) select 'foo';

ERROR:  table row type and query-specified row type do not match
DETAIL:  Physical storage mismatch on dropped attribute at ordinal position
2.



-- 
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/

Responses

pgsql-bugs by date

Next:From: Robert HaasDate: 2010-01-11 14:38:34
Subject: Re: BUG #5271: pg_dump: schema with OID 22519 does not exist
Previous:From: Michael FeltDate: 2010-01-11 07:57:42
Subject: Re: BUG #5267: initdb fails on AIX: could not identify current directory

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