Re: [pgAdmin4][Patch]: Ensure any changes to the config database are backward compatible

Thanks, patch applied.

On Fri, Aug 25, 2017 at 3:12 PM, Surinder Kumar <
surinder(dot)kumar(at)enterprisedb(dot)com> wrote:

> Created an RM <https://redmine.postgresql.org/issues/2664> to track this
> issue.
>
> On Fri, Aug 25, 2017 at 7:19 PM, Surinder Kumar <
> surinder(dot)kumar(at)enterprisedb(dot)com> wrote:
>
>> ​Hi,​
>>
>> We will use config variable `SCHEMA_VERSION` to keep track of SQLite
>> database changes. Whenever there is any change is performed in the
>> database, the count of schema version will be incremented by 1 and the same
>> will be updated in SQLite table `version`.
>>
>> So, these changes make sure the database migration is not performed on
>> the older version of pgAdmin4 and this way the same database will work
>> irrespective of pgAdmin4 version.
>>
>> Also, this will only work for future pgAdmin4 versions.
>>
>> Please find attached patch and review.
>>
>> Thanks,
>> Surinder
>>
>
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company