On May 27, 2:48 pm, Rolf Hanson <[email protected]> wrote: > Thanks, this worked great. > > I also have to add a new type of constraint, "PARTITION KEY." > Do you know where I should look to add this constraint? > > for instance, a table definition would look like: > > CREATE FACT TABLE weather ( > cityid int, > temp_lo int, > temp_hi int, > prcp real, > obs_date date, > PARTITION KEY( cityid ) > ); > > The fact tables always need a partition key. > > I've tried using the built in constraint and method_missing, but it > didn't work. Maybe I am just doing it wrong?
I'd make it a create_table option, and use it in create_table_sql. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
