pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedInheriting text[] field
3+ messages / 2 participants
[nested] [flat]
* Inheriting text[] field
@ 2004-08-16 07:06 Kaloyan Iliev Iliev <news1@faith.digsys.bg>
0 siblings, 1 reply; 3+ messages in thread
From: Kaloyan Iliev Iliev @ 2004-08-16 07:06 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Inheriting text[] field
@ 2004-08-16 14:28 Tom Lane <tgl@sss.pgh.pa.us>
parent: Kaloyan Iliev Iliev <news1@faith.digsys.bg>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2004-08-16 14:28 UTC (permalink / raw)
To: Kaloyan Iliev Iliev <news1@faith.digsys.bg>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Inheriting text[] field
@ 2004-08-17 13:16 Kaloyan Iliev Iliev <news1@faith.digsys.bg>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Kaloyan Iliev Iliev @ 2004-08-17 13:16 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; 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
>
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-08-17 13:16 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-16 07:06 Inheriting text[] field Kaloyan Iliev Iliev <news1@faith.digsys.bg>
2004-08-16 14:28 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-08-17 13:16 ` Kaloyan Iliev Iliev <news1@faith.digsys.bg>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox