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

Поиск
Список
Период
Сортировка
От Peter Gagarinov
Тема bug in pgadmin 1.8.2: Create script command doesn't recognize inherited fields at the end of the list
Дата
Msg-id 10010621055.20080216020028@gmail.com
обсуждение исходный текст
Ответ на bug in pgadmin 1.8.2: missing entry in 'Data Type' list  (Peter Gagarinov <heartofmars@gmail.com>)
Ответы Re: bug in pgadmin 1.8.2: Create script command doesn't recognize inherited fields at the end of the list
Small feature request for pgadmin 1.8.2: in Create script window show merged columns as '-- Merged' instead of '-- Inherited'
Список 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.



В списке pgadmin-support по дате отправления:

Предыдущее
От: "Raphaël Enrici"
Дата:
Сообщение: Re: Compiling PgAdmin 1.8.x on Debian LennyAMD64 ?
Следующее
От: "Glenn White"
Дата:
Сообщение: pgAdmin Hangs On Fedora 8