Various minor issues in schema tables

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Matthias3
Posts: 8
Joined: Tue 22 May 2012 15:10

Various minor issues in schema tables

Post by Matthias3 » Fri 25 May 2012 12:30

Hello,

There seem to be some (minor) issues in the schema information tables returned by PgSqlConnection.GetSchema("...").

1. In the "MetaDataCollection" table, the "DataTypes" collection is not shown (but it exists).

2. In the "DataTypes" table, the uuid type is not shown.

3. In the "Columns" table, there are some misspelled columns: "commment", "sername", "serschema".

4. In the "Columns" table, the length of varchar columns in shown in the "precision" column, not in the "length" column.

Best regards!

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

Re: Various minor issues in schema tables

Post by Pinturiccio » Mon 28 May 2012 14:12

Matthias3 wrote:3. In the "Columns" table, there are some misspelled columns: "commment", "sername", "serschema".
"sername" and "serschema" are correct column names. Values in these columns contain the name and the schema of the sequence for the Serial field. ser - is an abbreviation for serial.

We have reproduced all other issues you had specified. We will investigate them and notify you about the results as soon as possible.

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

Re: Various minor issues in schema tables

Post by Pinturiccio » Tue 29 May 2012 11:46

We have fixed the bugs with the GetSchema method of the PgSqlConnection class. We will notify you when the corresponding build of dotConnect for PostgreSQL is available for download.

Matthias3
Posts: 8
Joined: Tue 22 May 2012 15:10

Re: Various minor issues in schema tables

Post by Matthias3 » Tue 29 May 2012 12:07

Great, that was quick. Sorry about the mistake with the ser* columns.

Regards,

Matthias

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

Re: Various minor issues in schema tables

Post by Pinturiccio » Fri 08 Jun 2012 13:47

The new build of dotConnect for PostgreSQL 6.0.17 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 http://forums.devart.com/viewtopic.php?t=24292

Post Reply