How to read members Item from Groups GetSchema ?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Andrea Rocca
Posts: 5
Joined: Fri 10 Mar 2006 15:50

How to read members Item from Groups GetSchema ?

Post by Andrea Rocca » Thu 11 May 2006 06:35

Can yuo help us of how to decode Row.Iem("members") of Groups GetSchema in VB2005

It return a type String: "{38196}"

Dim Dtl As System.Data.DataTable
Dim Row As System.Data.DataRow

Dtl = mvarConnectionDB.GetSchema("Groups")
For Each Row In Dtl.Rows

How to convert this ?

Row.Item("members")

'This return System.Byte[]

String: "{38196}"

Next Row

Thanks

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 11 May 2006 07:08

This happens because the table pg_group has a column with type "int4[]" which we do not currently support. That's why we return the value from this column as System.String.
We are working on a resolution now. Look forward to the next build.

Post Reply