Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group