PgSqlDataTable descendant does not delete old Columns

PgSqlDataTable descendant does not delete old Columns

Postby chris901 » Sun 02 Oct 2016 13:35

Hello,

Postgres 9.5 and latest dotConnect version installed.

Steps to reproduce:

1. Create a descendant of PgSqlDataTable:
Code: Select all
    public partial class MyDataTable : Devart.Data.PostgreSql.PgSqlDataTable
    {
        public MyDataTable()
        {
        }
    }

2. Drop a PgSqlDataTable and MyDataTable on the form and connect them with PgSqlConnection
3. Insert SelectCommand for both:
Code: Select all
select '1' as First,
       '2' as Second;

4. Create Columns for both: http://i.imgur.com/KjEVwHv.jpg
5. Change the SelectCommand for both:
Code: Select all
select '1' as First,
       '3' as Third,
       '5' as Fifth;

6. Recreate the Columns.
7. "Press Yes to delete existing columns and create new ones" - Press Yes.
8. Here is the result: http://i.imgur.com/o5kBAWH.jpg

As you can see the original PgSqlDataTable correctly removed the DataColumn "second" as it is no longer in the query statement.

However the column is not deleted in the descendant.
chris901
 
Posts: 64
Joined: Wed 20 Jul 2016 04:21

Re: PgSqlDataTable descendant does not delete old Columns

Postby Pinturiccio » Tue 04 Oct 2016 13:49

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 2024
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlDataTable descendant does not delete old Columns

Postby Pinturiccio » Wed 05 Oct 2016 09:29

We have fixed the bug with old columns left in a PgSqDataTable descendant when recreating columns. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.
Pinturiccio
Devart Team
 
Posts: 2024
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlDataTable descendant does not delete old Columns

Postby Pinturiccio » Thu 06 Oct 2016 15:30

New build of dotConnect for PostgreSQL 7.6.753 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgresql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=34382
Pinturiccio
Devart Team
 
Posts: 2024
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlDataTable descendant does not delete old Columns

Postby chris901 » Fri 07 Oct 2016 05:24

Just installed, working fine! :)
chris901
 
Posts: 64
Joined: Wed 20 Jul 2016 04:21


Return to dotConnect for PostgreSQL