bug in pgadmin 1.8.2: Create script command doesn't recognize inherited fields at the end of the list

From: Peter Gagarinov <heartofmars(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: bug in pgadmin 1.8.2: Create script command doesn't recognize inherited fields at the end of the list
Date: 2008-02-15 23:00:28
Message-ID: 10010621055.20080216020028@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Prerequisites:

pgAdmin 1.8.2, Windows Xp SP2, Postgres 8.3.0

Steps to reproduce:

1)Run the following sequence.

create table basic_table(
a integer,
b integer);

create table derived_table(
c integer
) inherits (basic_table);

create table basic_table_b
(d integer);

alter table derived_table add column d integer;
alter table derived_table inherit basic_table_b;

2)Right click on derived_table and select "Scripts->CREATE script".
You should see the following text:

-- Table: derived_table

-- DROP TABLE derived_table;

CREATE TABLE derived_table
(
-- Inherited: a integer,
-- Inherited: b integer,
c integer,
-- Inherited: d integer
)
INHERITS (basic_table, basic_table_b)
WITH (OIDS=FALSE);
ALTER TABLE derived_table OWNER TO postgres;

which is incorrect because "c integer" is followed by "," though it it
is at the end of the list.

Peter G.

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Glenn White 2008-02-16 12:00:35 pgAdmin Hangs On Fedora 8
Previous Message Raphaël Enrici 2008-02-15 18:50:12 Re: Compiling PgAdmin 1.8.x on Debian LennyAMD64 ?