Committed - after rebased the patch. --
Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company <http://www.enterprisedb.com> *http://www.linkedin.com/in/asheshvashi* <http://www.linkedin.com/in/asheshvashi> On Thu, May 26, 2016 at 4:41 PM, Murtuza Zabuawala < murtuza.zabuaw...@enterprisedb.com> wrote: > Hi, > > PFA updated patch which will also include new query given by Thom for "Of > type" drop-down. > > > Regards, > Murtuza > > > -- > Regards, > Murtuza Zabuawala > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > On Thu, May 26, 2016 at 4:04 PM, Thom Brown <t...@linux.com> wrote: > >> On 26 May 2016 at 11:20, Murtuza Zabuawala < >> murtuza.zabuaw...@enterprisedb.com> wrote: >> >>> Hi, >>> >>> PFA patch for RM#1231 & RM#1237. >>> >>> Additionally I have shifted 'Advanced tab' after columns & constraint >>> tab. >>> >>> >>> @Thom, >>> >>> Reading "Of type" drop-down, We borrowed sql query from pgadmin3 to >>> populate "Of type" combo box as given below. >>> I was not able to find a way to differentiate between table & composite >>> type populating from below given query, >>> I'll put in todo list, may be someone from community can help in future. >>> >>> SELECT t.oid, >>> quote_ident(n.nspname)||'.'||quote_ident(t.typname) AS typname >>> FROM pg_type t, pg_namespace n >>> WHERE t.typtype='c' AND t.typnamespace=n.oid >>> AND NOT (n.nspname like 'pg_%' OR n.nspname='information_schema') >>> ORDER BY typname; >>> >>> >> This should work: >> >> SELECT c.oid, >> quote_ident(n.nspname)||'.'||quote_ident(c.relname) AS typname >> FROM pg_namespace n, pg_class c >> WHERE c.relkind = 'c' AND c.relnamespace=n.oid >> AND NOT (n.nspname like 'pg_%' OR n.nspname='information_schema') >> ORDER BY typname; >> >> Although, to avoid confusion, the "typname" alias should probably just be >> "relname". >> >> Thom >> > >