Page 1 of 1

PgSqlDataReader.GetSchemaTable and PgSqlConnection.GetSchema

Posted: Thu 04 Aug 2005 16:55
by 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

PgSqlDataReader.GetSchemaTable

Posted: Fri 05 Aug 2005 08:39
by Yuri
To get correct "isnotnull" value for the field you should execute ExecuteReader with CommandBehavior.KeyInfo argument

Re: PgSqlDataReader.GetSchemaTable

Posted: Fri 05 Aug 2005 09:56
by Arnaud Durand
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

PgSqlConnection.GetSchema

Posted: Fri 05 Aug 2005 11:58
by 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.

Re: PgSqlConnection.GetSchema

Posted: Fri 02 Sep 2005 01:15
by Arnaud
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

PgSqlConnection.GetSchema

Posted: Fri 02 Sep 2005 07:34
by Yuri
Sorry for the delay with issuing the build.
We are planning to release new PostgreSQLDirect .NET version in about two weeks.