Thanks Khushboo. Patch applied. On Fri, Feb 3, 2017 at 3:37 PM, Dave Page <dp...@pgadmin.org> wrote:
> > > On Fri, Feb 3, 2017 at 9:59 AM, Akshay Joshi < > akshay.jo...@enterprisedb.com> wrote: > >> Hi Dave >> >> On Fri, Feb 3, 2017 at 3:10 PM, Dave Page <dp...@pgadmin.org> wrote: >> >>> Akshay, I'll leave you to review/commit this. Please ensure that any >>> tickets that patches close have the target version set to 1.2 (if they >>> don't, please update them). That way the roadmap will reflect all the >>> changes in the release. >>> >> >> In pgAdmin3 for default tablespace we have one entry(*<default >> tablespace>*) in combo box while in pgAdmin4 we don't have such entry. >> Please refer the attached screenshot. Is this the expected behaviour for >> pgAdmin4? >> > > I think that was just because you couldn't have an empty option in the > control in pgAdmin 3. I think it's fine to just be optional in pgAdmin4 > (or, just at the <default tablespace> option everywhere if you think it's > better - I really don't have a preference!) > > >> >>> Thanks. >>> >>> On Fri, Feb 3, 2017 at 7:47 AM, Khushboo Vashi < >>> khushboo.va...@enterprisedb.com> wrote: >>> >>>> Hi Akshay, >>>> >>>> Please find the attached updated patch. >>>> >>>> Thanks, >>>> Khushboo >>>> >>>> On Fri, Feb 3, 2017 at 1:08 PM, Akshay Joshi < >>>> akshay.jo...@enterprisedb.com> wrote: >>>> >>>>> Hi Khushboo >>>>> >>>>> After applying latest patch I found one error(refer attached >>>>> screenshot) when clicking on "Materialized Views" collection node. >>>>> >>>>> Fixed >>>> >>>>> On Fri, Feb 3, 2017 at 12:14 PM, Khushboo Vashi < >>>>> khushboo.va...@enterprisedb.com> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> On Fri, Feb 3, 2017 at 11:53 AM, Khushboo Vashi < >>>>>> khushboo.va...@enterprisedb.com> wrote: >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> Please find the attached rebased patch. >>>>>>> >>>>>>> This patch also include fix for RM 2139: Message (Connection to the >>>>>> server has been lost.) displayed with Materialized view and view under >>>>>> sql >>>>>> tab >>>>>> >>>>>> >>>>>> >>>>>>> Thanks, >>>>>>> Khushboo >>>>>>> >>>>>>> On Mon, Jan 30, 2017 at 6:20 PM, Dave Page <dp...@pgadmin.org> >>>>>>> wrote: >>>>>>> >>>>>>>> Hi >>>>>>>> >>>>>>>> Can you rebase this please? >>>>>>>> >>>>>>>> Thanks. >>>>>>>> >>>>>>>> On Fri, Jan 27, 2017 at 11:53 AM, Khushboo Vashi >>>>>>>> <khushboo.va...@enterprisedb.com> wrote: >>>>>>>> > Hi, >>>>>>>> > >>>>>>>> > Please find the attached updated patch. >>>>>>>> > >>>>>>>> > Thanks, >>>>>>>> > Khushboo >>>>>>>> > >>>>>>>> > On Fri, Jan 20, 2017 at 5:31 PM, Dave Page <dp...@pgadmin.org> >>>>>>>> wrote: >>>>>>>> >> >>>>>>>> >> On Fri, Jan 13, 2017 at 6:41 AM, Khushboo Vashi >>>>>>>> >> <khushboo.va...@enterprisedb.com> wrote: >>>>>>>> >> > Hi, >>>>>>>> >> > >>>>>>>> >> > Please find the attached patch to fix the RM 2069 - Wrong >>>>>>>> tablespace >>>>>>>> >> > displayed in table properties. >>>>>>>> >> > >>>>>>>> >> > When the table is created without a tablespace, the >>>>>>>> "pg_default" >>>>>>>> >> > tablespace >>>>>>>> >> > gets selected rather than the default tablespace (the current >>>>>>>> database >>>>>>>> >> > tablespace). >>>>>>>> >> > So, this issue has been fixed. >>>>>>>> >> >>>>>>>> >> Unfortunately more work is required. I started hacking on it (see >>>>>>>> >> attached), but there is more effort needed and I'm out of time. >>>>>>>> >> Specifically: >>>>>>>> >> >>>>>>>> >> - We need to remove 'pg_default' as the default tablespace when >>>>>>>> >> creating objects. Let's have no default, and let PG >>>>>>>> automatically pick >>>>>>>> >> the right tablespace, unless the user specifically overrides it. >>>>>>>> My >>>>>>>> >> updated patch removes that default, and fixes some of the SQL to >>>>>>>> >> handle it. >>>>>>>> >> >>>>>>>> > Done >>>>>>>> >> >>>>>>>> >> - Matviews don't list the correct tablespace in their properties >>>>>>>> list. >>>>>>>> >> >>>>>>>> > Done >>>>>>>> >> >>>>>>>> >> - Unique constraints ignore the tablespace option if the user >>>>>>>> selects >>>>>>>> >> pg_default, even if the database's default is something >>>>>>>> different. >>>>>>>> >> >>>>>>>> > Done >>>>>>>> >> >>>>>>>> >> So I think to complete this we need to review all objects that >>>>>>>> use >>>>>>>> >> tablespaces (databases, tables, matviews, indexes, index-backed >>>>>>>> >> constraints) and ensure: >>>>>>>> >> >>>>>>>> > Done >>>>>>>> >> >>>>>>>> >> - No default tablespace is selected when creating an object. >>>>>>>> >> >>>>>>>> > Done >>>>>>>> >> >>>>>>>> >> - If the user selects a tablespace, the CREATE SQL must handle it >>>>>>>> >> properly. Similarly, if they leave it to the default. >>>>>>>> >> >>>>>>>> > Done >>>>>>>> >> >>>>>>>> >> - The Properties views must display the actual tablespace in use, >>>>>>>> >> whether it is specific to the object, or the database default. >>>>>>>> >> >>>>>>>> > Done >>>>>>>> >> >>>>>>>> >> Thanks. >>>>>>>> >> >>>>>>>> >> -- >>>>>>>> >> Dave Page >>>>>>>> >> Blog: http://pgsnake.blogspot.com >>>>>>>> >> Twitter: @pgsnake >>>>>>>> >> >>>>>>>> >> EnterpriseDB UK: http://www.enterprisedb.com >>>>>>>> >> The Enterprise PostgreSQL Company >>>>>>>> > >>>>>>>> > >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Dave Page >>>>>>>> Blog: http://pgsnake.blogspot.com >>>>>>>> Twitter: @pgsnake >>>>>>>> >>>>>>>> EnterpriseDB UK: http://www.enterprisedb.com >>>>>>>> The Enterprise PostgreSQL Company >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> *Akshay Joshi* >>>>> *Principal Software Engineer * >>>>> >>>>> >>>>> >>>>> *Phone: +91 20-3058-9517 <+91%2020%203058%209517>Mobile: +91 >>>>> 976-788-8246 <+91%2097678%2088246>* >>>>> >>>> >>>> >>> >>> >>> -- >>> Dave Page >>> Blog: http://pgsnake.blogspot.com >>> Twitter: @pgsnake >>> >>> EnterpriseDB UK: http://www.enterprisedb.com >>> The Enterprise PostgreSQL Company >>> >> >> >> >> -- >> *Akshay Joshi* >> *Principal Software Engineer * >> >> >> >> *Phone: +91 20-3058-9517 <+91%2020%203058%209517>Mobile: +91 976-788-8246 >> <+91%2097678%2088246>* >> > > > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > -- *Akshay Joshi* *Principal Software Engineer * *Phone: +91 20-3058-9517Mobile: +91 976-788-8246*