PgSqlDataReader.GetSchemaTable and PgSqlConnection.GetSchema

PgSqlDataReader.GetSchemaTable and PgSqlConnection.GetSchema

Postby Arnaud Durand » Thu 04 Aug 2005 16:55

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
Arnaud Durand
 

PgSqlDataReader.GetSchemaTable

Postby Yuri » Fri 05 Aug 2005 08:39

To get correct "isnotnull" value for the field you should execute ExecuteReader with CommandBehavior.KeyInfo argument
Yuri
 
Posts: 140
Joined: Mon 08 Nov 2004 12:07

Re: PgSqlDataReader.GetSchemaTable

Postby Arnaud Durand » Fri 05 Aug 2005 09:56

Yuri wrote: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
Arnaud Durand
 

PgSqlConnection.GetSchema

Postby Yuri » Fri 05 Aug 2005 11:58

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.
Yuri
 
Posts: 140
Joined: Mon 08 Nov 2004 12:07

Re: PgSqlConnection.GetSchema

Postby Arnaud » Fri 02 Sep 2005 01:15

Yuri wrote: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
Arnaud
 
Posts: 3
Joined: Fri 24 Jun 2005 14:12

PgSqlConnection.GetSchema

Postby Yuri » Fri 02 Sep 2005 07:34

Sorry for the delay with issuing the build.
We are planning to release new PostgreSQLDirect .NET version in about two weeks.
Yuri
 
Posts: 140
Joined: Mon 08 Nov 2004 12:07


Return to dotConnect for PostgreSQL