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
>
>
>
>
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 |