=?UTF-8?Q?Filip_Rembia=C5=82kowski?= 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( m
=?UTF-8?Q?Filip_Rembia=C5=82kowski?= 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 t
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
Filip Rembiałkowski wrote:
After dropping a column from table, there is still entry in pg_attribute
fi...@la_dev=# select * from pg_attribute where attrelid = (select oid
from pg_class where relname='thetable') order by attnum desc limit 1;
-[ RECORD 1 ]-+--
attreli
=?UTF-8?Q?Filip_Rembia=C5=82kowski?= writes:
> INSERT INTO thetable ( ... ) VALUES ( ... );
> ERROR: table row type and query-specified row type do not match
If you want any help with this you need to show a *complete* example
of how to produce this failure.
regards, tom
Hi all,
I have a deja vu or I had this very problem before.
Now I use 8.4.2 and it happened again.
After dropping a column from table, there is still entry in pg_attribute
fi...@la_dev=# select * from pg_attribute where attrelid = (select oid from
pg_class where relname='thetable') order by att