From b03ee45f32e53416ce1c73fa15966db17ed4bbf9 Mon Sep 17 00:00:00 2001
From: Pete Hollobon <phollobon@renshawbay.com>
Date: Thu, 4 Jun 2015 15:12:09 +0100
Subject: Add reflection of PostgreSQL index storage options

---
 test/dialect/postgresql/test_reflection.py | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

(limited to 'test/dialect/postgresql')

diff --git a/test/dialect/postgresql/test_reflection.py b/test/dialect/postgresql/test_reflection.py
index 0ebe68cba..70b81219e 100644
--- a/test/dialect/postgresql/test_reflection.py
+++ b/test/dialect/postgresql/test_reflection.py
@@ -672,6 +672,26 @@ class ReflectionTest(fixtures.TestBase):
         eq_(ind, [{'unique': False, 'column_names': ['y'], 'name': 'idx1'}])
         conn.close()
 
+    @testing.provide_metadata
+    def test_index_reflection_with_storage_options(self):
+        """reflect indexes with storage options set"""
+
+        metadata = self.metadata
+
+        t1 = Table('t', metadata,
+                   Column('id', Integer, primary_key=True),
+                   Column('x', Integer)
+                   )
+        metadata.create_all()
+        conn = testing.db.connect().execution_options(autocommit=True)
+        conn.execute("CREATE INDEX idx1 ON t (x) WITH (fillfactor = 50)")
+
+        ind = testing.db.dialect.get_indexes(conn, "t", None)
+        eq_(ind, [{'unique': False, 'column_names': ['x'], 'name': 'idx1',
+                   'dialect_options': {"postgresql_with": {"fillfactor": "50"}}}])
+        conn.close()
+
+
     @testing.provide_metadata
     def test_foreign_key_option_inspection(self):
         metadata = self.metadata
-- 
cgit v1.2.1