Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes: > I am useing PostgreSQL 7.2.3.
> test_libvar=# create table temp_a( > test_libvar(# name text[] > test_libvar(# ); > CREATE > test_libvar=# create table temp( name text[] ) inherits (temp_a); > NOTICE: CREATE TABLE: merging attribute "name" with inherited definition > ERROR: CREATE TABLE: attribute "name" type conflict (_text and text) Works fine for me in 7.3 and later. Time to upgrade ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match