haskell-webapps icon indicating copy to clipboard operation
haskell-webapps copied to clipboard

Setup Postgres DB

Open saurabhnanda opened this issue 9 years ago • 3 comments

  • How to handle PG specific constraints & triggers that work well with the automatic migration that Persistent does?
  • Can Persistent automatically create FK constraints in the schema?

saurabhnanda avatar Oct 10 '16 11:10 saurabhnanda

Can Persistent automatically create FK constraints in the schema?

Yes.

wz1000 avatar Oct 10 '16 11:10 wz1000

@wz1000 do take a look at https://github.com/vacationlabs/haskell-webapps/blob/master/ServantOpaleye/db/schema.sql and https://vacationlabs.github.io/haskell-webapps/ServantOpaleye/db/schema_spy/

saurabhnanda avatar Oct 10 '16 11:10 saurabhnanda

@wz1000 has this been closed by #30

saurabhnanda avatar Oct 31 '16 09:10 saurabhnanda