News for hackers. Stuff that matters.
Re:Row Level Security with PostgreSQL 9.5 by flannell on Wednesday April 20, 2016 @03:50PM (#11537221)
Is this an observation or have you done/seen this in action?

I ask because for my next project I'd like to tackle the issue of having to keep lots of Databases up to date with their stored procedures. Kind of wanted a common library of procs that any DB can access. I've seen third party Software do DB versioning etc but too expensive for me. A few do it via package management, but keen to see how others are doing it!

Re:Row Level Security with PostgreSQL 9.5 by tiffanyh on Wednesday April 20, 2016 @04:04PM (#11537324)
I don't know if Postgres can do what you're describing but I know Oracle can and it's called Pluggable Databases (PDB) and it's designed exactly for this use case.

(Now I just hope I don't get flammed)

Re:Row Level Security with PostgreSQL 9.5 by flannell on Wednesday April 20, 2016 @05:24PM (#11537859)
Interesting thanks, I'll look into it. Your earlier comment has sent me down a Postgresql logicdecode/Kafka/Hadoop rabbit hole. Funny where you end up.
Re:Row Level Security with PostgreSQL 9.5 by snuxoll on Thursday April 21, 2016 @02:42AM (#11540101)
In PostgreSQL extensions are the common way to solve it, you still have to manually install/uninstall in each database but writing them is pretty straightforward and a quick call to CREATE EXTENSION/DROP EXTENSION in your migrations isn't too much to ask in most cases.