PgSqlDataReader.GetSchemaTable and PgSqlConnection.GetSchema

[Arnaud Durand]

hi all,

Related to the previous topic: PgSqlDataReader.GetSchemaTable and PgSqlConnection.GetSchema

I would also write that "isnotnull" is not populated properly. I use a query in the information_schema.columns table in order to retrieve the correct value.

Could you tell us when this fix will be ready?

Thanks for your support

[Yuri]

To get correct "isnotnull" value for the field you should execute ExecuteReader with CommandBehavior.KeyInfo argument

[Arnaud Durand]

To get correct "isnotnull" value for the field you should execute ExecuteReader with CommandBehavior.KeyInfo argument

Hi,

In order to retrieve information about Columns in a table, we use the GetSchema method of the CoreLab.PostgreSql.PgSqlConnection object which seems to be more stable way. In that case we cannot provide a CommandBehavior.KeyInfo as we don't use a Command object.

Thank you for this information.

Arnaud

[Yuri]

We reproduced your problem and fixed it.
This fix will be included in the next PostgreSqlDirect .NET build. It will be available in a week.

[Arnaud]

We reproduced your problem and fixed it.
This fix will be included in the next PostgreSqlDirect .NET build. It will be available in a week.

Hi,

Do you have any news about the new version?

Regards

[Yuri]

Sorry for the delay with issuing the build.
We are planning to release new PostgreSQLDirect .NET version in about two weeks.