PgSqlDataTable descendant does not delete old Columns

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
chris901
Posts: 64
Joined: Wed 20 Jul 2016 04:21

PgSqlDataTable descendant does not delete old Columns

Post by 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.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlDataTable descendant does not delete old Columns

Post by 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: 2192
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlDataTable descendant does not delete old Columns

Post by 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: 2192
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlDataTable descendant does not delete old Columns

Post by 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/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=34382

chris901
Posts: 64
Joined: Wed 20 Jul 2016 04:21

Re: PgSqlDataTable descendant does not delete old Columns

Post by chris901 » Fri 07 Oct 2016 05:24

Just installed, working fine! :)

Post Reply