No Primary Key Set Using ADO.NET

[leeottaway]

Hi

I've come from using an Access database and have always simply used the .Fill method on the datatable using an oledbdataadapter that has the MissingSchemaAction set to AddWithKey. This always gets the primary key of the table, however using your provider with pgSQL, I notice it never gets the primary key using .Fill and I have to set it manually even when the MissingSchemaAction is defined as AddWithKey.

Any ideas why this might be?

Thanks

[Alexey]

Please describe the problem in detail. Where do you expect primary key to appear? Provide your database table definition.