[Mono-list] Re: [Mono-devel-list] Problem with DbDataAdapter...

[Francisco Figueiredo Jr.]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Konstantin Triger wrote:
> Hello Hubert,
> 
> There was a change during this week end: the Mainsoft changes were
> merged into the trunk (they were previously available at
> Mainsoft.System.Data branch).
> 
> From the stack I suppose that PG provider does not fully initialize the
> SchemaTable and some columns contain nulls.
> 

Hi Konstantin!

Npgsql is returning the following metadata schema:


		result.Columns.Add ("ColumnName", typeof (string));
                result.Columns.Add ("ColumnOrdinal", typeof (int));
                result.Columns.Add ("ColumnSize", typeof (int));
                result.Columns.Add ("NumericPrecision", typeof (int));
                result.Columns.Add ("NumericScale", typeof (int));
                result.Columns.Add ("IsUnique", typeof (bool));
                result.Columns.Add ("IsKey", typeof (bool));
                result.Columns.Add ("BaseCatalogName", typeof (string));
                result.Columns.Add ("BaseColumnName", typeof (string));
                result.Columns.Add ("BaseSchemaName", typeof (string));
                result.Columns.Add ("BaseTableName", typeof (string));
                result.Columns.Add ("DataType", typeof(Type));
                result.Columns.Add ("AllowDBNull", typeof (bool));
                result.Columns.Add ("ProviderType", typeof (int));
                result.Columns.Add ("IsAliased", typeof (bool));
                result.Columns.Add ("IsExpression", typeof (bool));
                result.Columns.Add ("IsIdentity", typeof (bool));
                result.Columns.Add ("IsAutoIncrement", typeof (bool));
                result.Columns.Add ("IsRowVersion", typeof (bool));
                result.Columns.Add ("IsHidden", typeof (bool));
                result.Columns.Add ("IsLong", typeof (bool));
                result.Columns.Add ("IsReadOnly", typeof (bool));


Please, let me know if you are using any other metadata info so I can
add it accordingly.

Thanks in advance.




- --
Regards,

Francisco Figueiredo Jr.
Npgsql Lead Developer
http://gborg.postgresql.org/project/npgsql
MonoBrasil Project Founder Member
http://monobrasil.softwarelivre.org


- -------------
"Science without religion is lame;
religion without science is blind."

                  ~ Albert Einstein
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iQEVAwUBQo30PP7iFmsNzeXfAQJaTwf9H85e6MGVDWo6uyE6jnewkaL5ivq7JS4z
6/Vvwwk3xmMkj5WhKcF2wQa9Zo4RWZYpTcmT5uoyYJl68Yl5puSnNinWeSa7h5rg
QTD9FXrhQ+IGvylGqS+U1reKC6JGJZC/A2fwJZPKYqjKh7MXutNy3cwERVzLqpYr
kSxHLdQt7kIPC5arpzcQMjOMAhg96X/03XxqnrupO7ACAdqyoC/uCfRGWte3+DDZ
UHg8Uka+OK0EsNPwVGUH7PpUWZp5Cn1qbiJ/eFJphaXTxZMLKKOTawvYVFI5lOxP
qCDe4RsFjosp4kYOkS+m9UtKbtr0vp2euY8+Y7l6TjyRADHNijemQg==
=BBjE
-----END PGP SIGNATURE-----