I am looking to model a hierarchical structure where the parent nodes on
each level will contain calculations based on immediate children's values.
For example the parent row may have an average of all the child rows (the
calculations will be more complicated than that of course).
So every time a
What is the most efficient way to model key value tags on records. The keys
and values will be variable and changing over time. The values may be of
various types (numbers, dates, strings etc). There will be filters and
group by selects based on tag names and maybe even tag values.
Postgres giv
On 11/12/2014 02:45 PM, Ted Toth wrote:
I'm running selinux mls policy I've got labeled ipsec working and my
postgresql configured to load
sepgsql. I've created a db, run the sepgsql.sql script on it, created
tables and inserted data. How do I
query the security labels on the data?
I do not use
I'm running selinux mls policy I've got labeled ipsec working and my
postgresql configured to load
sepgsql. I've created a db, run the sepgsql.sql script on it, created
tables and inserted data. How do I
query the security labels on the data? As best I can tell there is no
security_context
column o
On 11/11/2014 07:52 PM, David G Johnston wrote:
> TL;DR - the interaction of ANALYZE and inheritance hierarchies seems to be
> broken for the uncommon use case where the inserts temporarily remain on the
> master table in order to allow RETURNING to work.
Yeah, if I do:
# vacuum verbose public.t
We're trying to use bdr replication with DJango. Django's default primary
keys are SERIAL columns which is a pseudo type that uses global sequences (
http://www.postgresql.org/docs/devel/static/datatype-numeric.html#DATATYPE-SERIAL
). BDR requires a global sequence to be defined using an explicit U
