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

From Tom Lane
Subject Re: Inheriting text[] field
Date
Msg-id 13183.1092666522@sss.pgh.pa.us
Whole thread Raw
In response to Inheriting text[] field  (Kaloyan Iliev Iliev <news1@faith.digsys.bg>)
Responses Re: Inheriting text[] field  (Kaloyan Iliev Iliev <news1@faith.digsys.bg>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: George Weaver
Date:
Subject: Re: Returning A Varchar From A Function
Next
From: Achilleus Mantzios
Date:
Subject: SQL_ASCII and UNICODE server_encoding