Re: Inheriting text[] field - Mailing list pgsql-sql

From Kaloyan Iliev Iliev
Subject Re: Inheriting text[] field
Date
Msg-id 4122052F.707@faith.digsys.bg
Whole thread Raw
In response to Re: Inheriting text[] field  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
10x

I suppose you are right:)
Regard Kaloyan Iliev

Tom Lane wrote:

>Kaloyan Iliev Iliev <news1@faith.digsys.bg> 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
>
>
>  
>


pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: only last records in subgroups
Next
From: Elieser Leão
Date:
Subject: Re: Verifying data type