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