On Monday, September 26, 2016 at 8:26:12 AM UTC-7, [email protected] wrote: > > Hi, > > I added a partial index to one of my (postgres) tables and noticed that > the schema dump wasn't showing this. The docs for the `indexes` method > explicitly state that 'This will not output any partial indexes'. I was > wondering what the rationale behind this was? >
The schema dumper and various other reflection methods only support a very limited subset of what most databases support. Once you start using features outside that subset, you are better off using the database's dumping tools. Other common things not supported by the schema dumper are functions, triggers, CHECK constraints, and permissions. The main reason for the schema dumper is to support cross database dumping/restoring of schema. In order to do this, the schema dumper supports the lowest-common-dominator in terms of what databases in general support. Not all databases support partial indexes. Partial indexes themselves are problematic in that the WHERE condition can be arbitrary SQL, which Sequel couldn't parse and may not be portable between database types. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
