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

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

pgadmin-support by date

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

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