Thank you- that makes sense! Cheers, Sachin
On Monday, September 26, 2016 at 11:41:51 AM UTC-4, Jeremy Evans wrote: > > On Monday, September 26, 2016 at 8:26:12 AM UTC-7, [email protected] > <javascript:> 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.
