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.