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 по дате отправления: