News for hackers. Stuff that matters.

A comment on Let Postgres Do the Work (2013). Parent comment

Re:Let Postgres Do the Work (2013) by slagfart on Saturday November 26, 2016 @05:31PM (#13046311)
You don't need a tool for this. If you store base data in one schema, and functions/views in another, you can update this second schema willy nilly without worrying about damaging your data.

Just start the second file with DROP SCHEMA IF EXISTS schemaname CASCADE; CREATE SCHEMA schemaname;. Then, make sure any functions/views/permissions built on top of this schema are also contained within this file.

[ Parent | on HN ]
Re:Let Postgres Do the Work (2013) by inopinatus on Saturday November 26, 2016 @06:21PM (#13046612)
Or you can just pull the SQL for the stored procedure from a table column and execute it dynamically.

Now it's an ops problem :-)

[ Parent | on HN ]
Re:Let Postgres Do the Work (2013) by jessaustin on Sunday November 27, 2016 @07:54AM (#13048903)
Haha, usually we hear this from smart guys who have been working for about 8 months...
[ Parent | on HN ]
Re:Let Postgres Do the Work (2013) by angersock on Saturday November 26, 2016 @10:45PM (#13047573)
Oh, that's slick. Nice!
[ Parent | on HN ]