SCM

[#1010650] DbConnection.GetSchema: Metadata for Indexes

View Trackers | Feature Requests | Download .csv | Monitor

Date:
2009-06-10 20:59
Priority:
3
State:
Open
Submitted by:
Dario Quintana (darioquintana)
Assigned to:
Nobody (None)
Category:
Group:
Resolution:
None
 
Summary:
DbConnection.GetSchema: Metadata for Indexes

Detailed description
Useful for frameworks that use this information in Schema Update, like NHibernate.

Followup

Message
Date: 2010-10-18 02:50
Sender: Josh Cooley

I've added support sufficient for NHibernate, but did not include the stared columns. If you can, please test what's in CVS and let me know if it works for you.

The queries for indexes are in NpgsqlSchema.cs. If more data is desired, just send us an updated query.
Date: 2010-09-01 08:08
Sender: Pablo Ruiz

Any updates on this?
Date: 2009-06-11 16:13
Sender: Dario Quintana

I saw that SQLite, MySQL and SqlClient providers had the
metadata for 'Indexes' and 'IndexColumns' but there are some
minimals values:

For 'Indexes':
-TABLE_CATALOG,
-TABLE_SCHEMA,
-TABLE_NAME,
-INDEX_NAME,
-PRIMARY_KEY (as boolean),*
-UNIQUE (as boolean),*
-TYPE.*

For 'IndexColumns':
-TABLE_CATALOG,
-TABLE_SCHEMA,
-TABLE_NAME,
-INDEX_NAME,
-COLUMN_NAME,
-ORDINAL_POSITION.*

* NH don't need these.
Date: 2009-06-11 03:19
Sender: Josh Cooley

This is not listed in DbMetaDataCollectionNames. And there's not documented standard. I see that SQLite and SqlClient have variations in their implementations. Do the DataTables have to support some minimal list of columns for this to be useful? Do they have to have a specific name?

Attached Files:

Changes:

No Changes Have Been Made to This Item

Powered By FusionForge