error on pg_admin post_beta 3 (Nov 2 2004)

From: "Riccardo G(dot) Facchini" <abief_ag_-postgresql(at)yahoo(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: error on pg_admin post_beta 3 (Nov 2 2004)
Date: 2004-11-10 12:58:14
Message-ID: 20041110125814.16468.qmail@web13925.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi All,

small issue on the table generator:

the create sentence for a table that inherits from two other tables is
erroneous.

my example:

CREATE TABLE test1
(
test1_id int4,
test1_value text
);
CREATE TABLE test2
(
test2_id int4,
test2_value text
);
CREATE TABLE test3
(
)
INHERITS (test1, test2)
WITHOUT OIDS;

should produce
CREATE TABLE test3
(
test1_id int4,
test1_value text,
test2_id int4,
test2_value text
) INHERITS (test1, test2)
WITHOUT OIDS;

and makes:
CREATE TABLE test3
(
test1_id int4,
test1_value text,
test2_id int4,
test2_value text
) INHERITS (test1test2)
WITH OIDS;

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2004-11-10 13:21:09 Re: error on pg_admin post_beta 3 (Nov 2 2004)
Previous Message MAR - Secretariado Geral 2004-11-10 12:30:12 majordomo@postgresql.org