X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5E57B5E3639 for ; Mon, 16 Aug 2004 04:12:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56833-05 for ; Mon, 16 Aug 2004 07:12:45 +0000 (GMT) Received: from school.digsys.bg (school.digsys.bg [193.68.6.1]) by svr1.postgresql.org (Postfix) with ESMTP id 20CF95E46E4 for ; Mon, 16 Aug 2004 04:12:42 -0300 (ADT) Received: from faith.digsys.bg (sigma.digsys.bg [193.68.6.19]) by school.digsys.bg (8.11.6/8.10.1) with ESMTP id i7G7CRx09615 for ; Mon, 16 Aug 2004 10:12:38 +0300 (EEST) Message-ID: <41205CDF.1090403@faith.digsys.bg> Date: Mon, 16 Aug 2004 10:06:07 +0300 From: Kaloyan Iliev Iliev User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040115 X-Accept-Language: en-us, en, bg MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Inheriting text[] field Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=DEAR_FRIEND X-Spam-Level: * X-Archive-Number: 200408/141 X-Sequence-Number: 18638 Dear Friend, I have the following problem when I try to inherits one table with text[] field into another. I am useing PostgreSQL 7.2.3. I suppose that this is a BUG but I am not sure. Any ides. 10x in advance. Kaloyan 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) P.S. I know that I can avoid this by scipping the 'name' field into the second table but what if I need to set some CONSTRAINTS to it.