Re: Inheriting text[] field

From: Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)bg>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Inheriting text[] field
Date: 2004-08-17 13:16:31
Message-ID: 4122052F.707@faith.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

10x

I suppose you are right:)

Regard Kaloyan Iliev

Tom Lane wrote:

>Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)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
>
>
>
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Elieser Leão 2004-08-17 13:48:49 Re: Verifying data type
Previous Message Achilleus Mantzios 2004-08-17 11:35:04 Re: only last records in subgroups