Обсуждение: error on pg_admin post_beta 3 (Nov 2 2004)

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;

Riccardo G. Facchini wrote:
> Hi All,
> 
> small issue on the table generator:
> 
> the create sentence for a table that inherits from two other tables is
> erroneous.

Fixed in CVS, thanks for reporting.

Regards,
Andreas